Senior Data Engineer
S&P Global, Inc.
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
S&P Global in Islamabad, Pakistan, is seeking a Senior Data Engineer to lead enterprise-scale ELT/ETL and data governance initiatives. You will architect robust data systems, mentor engineers, and collaborate across business and technical teams to deliver scalable data solutions using Informatica Cloud and Snowflake.
The role emphasizes data security, RBAC/ABAC controls, encryption, and performance tuning, with opportunities to work on AI-enabled data projects and modern visualization tools
Qualifications
- Bachelor’s degree and 6+ years of progressive experience in data engineering or related fields.
- 5+ years of hands-on experience with Informatica Cloud (IICS) ELT/ETL.
- 5 years of experience working with Snowflake in a data engineering capacity, including Streams, Tasks, stored procedures, UDFs.
- Expert-level SQL proficiency with advanced window functions, CTEs, recursive queries and Snowflake optimisations.
- Experience implementing data governance policies and security compliance using Collibra, Alation, or native Snowflake features.
- Deep understanding of data security principles, encryption standards (AES-256), key management (AWS KMS, Azure Key Vault).
- Strong Python skills for data transformation, automation, and API integration.
- Proven track record of designing and implementing enterprise system integrations.
- Proficiency in data lakehouse architecture and data product development.
- Excellent communication skills for collaboration across teams.
Responsibilities
- Lead the architectural design of enterprise-scale data systems for robust, scalable data architecture.
- Lead ELT/ETL pipelines using Informatica Cloud (IICS) to integrate data into Snowflake with quality and transformation standards.
- Architect and enforce data governance frameworks, including data lineage, metadata management, and regulatory compliance (GDPR, CCPA, SOC 2).
- Design, implement RBAC and ABAC 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.
- Perform advanced SQL query optimisation and Snowflake performance tuning (Streams, Tasks, materialised views, clustering keys, query profiling).
- Mentor junior and mid-level data engineers on Snowflake optimization, Informatica development, and secure data handling.
- Leverage cloud technologies to optimize data operations and performance.
- Collaborate across business and technical teams to ensure effective communication and successful project delivery.
- Manage large-scale data projects from inception to completion.
Skills
Education
Tools
Job description
Grade Level (for internal use): 10
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 visualisation tools, to enhance our data platforms and deliver exceptional results.
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 optimisation, 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 organisation’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.
- 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 optimisation and performance tuning in Snowflake, leveraging features like Streams, Tasks, materialised views, clustering keys, and query profiling.
- Mentor junior and mid-level data engineers, providing technical guidance on best practices for Snowflake optimisation, Informatica development, and secure data handling.
- Leverage cloud technologies to optimise 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.
- 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 optimisations (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.
- 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 operationalising ML models within data pipelines, including feature engineering and model monitoring.
- Experience developing Streamlit applications and familiarity with data visualisation tools like Tableau or Power BI.
- Strong collaborative skills and the ability to work effectively in fast-paced, team-oriented environments.
- 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 programme with a company-matched student loan contribution, and financial wellness programmes.
- 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.
S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, colour, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law.
Know Your Rights: Workplace discrimination is illegal
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.
Integrity, Discovery, Partnership Throughout our history, the world's leading organisations 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 everything 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.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
