Senior Data Engineer

About the Role:

Grade Level (for internal use):

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.

What’s in it for you:

As a Senior Data Engineer, you will be at the forefront of transforming our data landscape, playing a crucial leadership role in shaping the future of our data-driven strategies. You will lead the design and implementation of enterprise-scale ELT/ETL pipelines using Informatica Cloud (IICS), ensuring data quality, security, and governance. You will mentor junior and mid-level engineers, providing technical guidance on best practices for Snowflake optimization, Informatica development, and secure data handling. Engage in exciting projects leveraging cutting-edge cloud and AI technologies, and work in a collaborative environment that encourages professional growth. Benefit from opportunities to expand your skills, influence strategic initiatives, and make a significant impact on our organization’s success.

Our Enterprise Data Technology organization at S&P Global is dedicated to driving innovation and ensuring the seamless integration and management of data across our commercial and marketing platforms. Our team values collaboration, continuous learning, and a commitment to excellence. We pride ourselves on our ability to adapt quickly to technological advancements and our focus on delivering high-quality data solutions to our clients.

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 Specialist).
• Experience with data quality frameworks (Informatica Data Quality) and DataOps/CI/CD practices.
• Familiarity with AWS data services (S3, Glue, Lambda, Step Functions) for cloud-native data architectures.
• Experience with Snowflake Cortex AI and ML functions for embedding AI capabilities into data workflows.
• Knowledge of operationalizing ML models within data pipelines, including feature engineering and model monitoring.
• Experience developing Streamlit applications and familiarity with data visualization tools like Tableau or Power BI.
• Strong collaborative skills and the ability to work effectively in fast-paced, team-oriented environments.

What’s In It For You?

Our Mission:

Advancing Essential Intelligence.

Our People:

We're more than 35,000 strong worldwide-so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all.From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing the way people see things and empowering them to make an impact on the world we live in. We’re committed to a more equitable future and to helping our customers find new, sustainable ways of doing business. Join us and help create the critical insights that truly make a difference.

Our Values:

Integrity, Discovery, Partnership

Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead. We start with a foundation of integrity in all we do, bring a spirit of discovery to our work, and collaborate in close partnership with each other and our customers to achieve shared goals.

Benefits:

We take care of you, so you can take care of business. We care about our people. That’s why we provide everything you-and your career-need to thrive at S&P Global.

Our benefits include:

• Health & Wellness: Health care coverage designed for the mind and body.

• Flexible Downtime: Generous time off helps keep you energized for your time on.

• Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.

• Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.

• Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in class benefits for families.

• Beyond the Basics: From retail discounts to referral incentive awards-small perks can make a big difference.

For more information on benefits by country visit: https://spgbenefits.com/benefit-summaries

Global Hiring and Opportunity at S&P Global:

At S&P Global, we are committed to fostering a connected and engaged workplace where all individuals have access to opportunities based on their skills, experience, and contributions. Our hiring practices emphasize fairness, transparency, and merit, ensuring that we attract and retain top talent. By valuing different perspectives and promoting a culture of respect and collaboration, we drive innovation and power global markets.

Recruitment Fraud Alert:

If you receive an email from a spglobalind.com domain or any other regionally based domains, it is a scam and should be reported to [email protected]. S&P Global never requires any candidate to pay money for job applications, interviews, offer letters, “pre-employment training” or for equipment/delivery of equipment. Stay informed and protect yourself from recruitment fraud by reviewing our guidelines, fraudulent domains, and how to report suspicious activity here.

-----------------------------------------------------------

Equal Opportunity Employer

S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. Only electronic job submissions will be considered for employment.

If you need an accommodation during the application process due to a disability, please send an email to: [email protected] and your request will be forwarded to the appropriate person.

US Candidates Only: Know Your Rights: Workplace discrimination is illegal

-----------------------------------------------------------