Senior Data Engineer — ELT/ETL Architect & Snowflake Lead

S&P Global, Inc.; Islamabad; On-site; PKR 2,500,000 - 3,500,000; Full time

Benefits offered by this job

Health & Wellness

Flexible Downtime

Continuous Learning

Invest in Your Future

Family Friendly Perks

Beyond the Basics

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

ELT/ETL design

Snowflake optimization

Python for data transformation

Data governance

SQL proficiency

Security concepts (RBAC/ABAC)

Cloud technologies

Mentoring / leadership

Communication skills

Education

Bachelor’s degree

Tools

Informatica Cloud (IICS)

Snowflake

Collibra

Alation

AWS KMS

Azure Key Vault

CI/CD tooling

Data quality tools

Streamlit/Tableau/Power BI

Job description

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