Senior Data Engineer

About the role

Grade Level (for internal use): 11 The Team: Our Enterprise Data Technology organization at S&P Global is a dynamic group of professionals dedicated to building innovative and scalable data solutions. We pride ourselves on our expertise in cloud technologies, particularly Informatica and Snowflake, and our commitment to data security and governance. Our team maintains SOC 2 compliance and implements enterprise-grade data governance using industry-leading frameworks and tools. We thrive on collaboration, working closely with business and technical stakeholders to drive impactful data initiatives. We value continuous learning and are always exploring new technologies, such as AI-driven models and advanced data visualization tools, to enhance our data platforms and deliver exceptional results.

Responsibilities

• Lead the architectural design of enterprise-scale data systems, ensuring robust, scalable, and efficient data architecture.
• Lead the design and deployment of ELT/ETL pipelines using Informatica Cloud (IICS) to integrate data from multiple sources into Snowflake, ensuring data quality and transformation standards.
• Architect and enforce data governance frameworks, including data lineage, metadata management, and compliance with regulatory requirements (GDPR, CCPA, SOC 2).
• Design, implement, and audit comprehensive RBAC and ABAC (Attribute-Based Access Control) security models within Snowflake to maintain secure data environments.
• Establish and maintain advanced data security protocols, including dynamic data masking, row-level security, and encryption at rest/in transit within Snowflake.
• Perform advanced SQL query optimization and performance tuning in Snowflake, leveraging features like Streams, Tasks, materialized views, clustering keys, and query profiling.
• Mentor junior and mid-level data engineers, providing technical guidance on best practices for Snowflake optimization, Informatica development, and secure data handling.
• Leverage cloud technologies to optimize data operations and enhance performance.
• Collaborate across business and technical teams to ensure effective communication and successful project delivery.
• Manage large-scale data projects from inception to completion, ensuring timely and successful outcomes.
• Required Skills:
• Bachelor's degree and 6+ years of progressive experience in data engineering or related fields.
• 5 years of hands-on experience designing and deploying production ELT/ETL solutions using Informatica Cloud (IICS), including Mapping Designer, Data Integration, and API management.
• 5 years of experience working with Snowflake in a data engineering capacity, including advanced features like Streams, Tasks, stored procedures, UDFs, and external functions.
• Expert-level proficiency in SQL, including complex window functions, CTEs, recursive queries, and Snowflake-specific optimizations (zero-copy cloning, time travel, result caching).
• Proven experience implementing data governance policies and security compliance frameworks, using tools like Collibra, Alation, or native Snowflake features.
• Deep understanding of data security principles, including encryption standards (AES-256), key management (AWS KMS, Azure Key Vault), and secure data sharing protocols.
• Strong Python skills for data transformation, automation, and API integration.
• Proven track record of designing and implementing enterprise system integrations for seamless data interoperability.
• Proficiency in data lakehouse architecture and data product development.
• Excellent communication skills for effective collaboration across diverse teams.
• Preferred Qualities:
• Snowflake SnowPro Core or Advanced certification (Data Engineer, Architect, or Security Spe

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at spgi? Share your experience