Overview:

We are looking for a Senior Data Engineer – Python, BigQuery and DBT to join our Index Engineering team in Gurgaon. You will be part of a team that builds and evolves critical data platforms on a modern cloud-native stack using dbt, BigQuery, and Apache Airflow on Google Cloud Platform. You will work with large-scale financial datasets, including securities master data, corporate actions, and market data from external vendors — designing robust ELT pipelines, improving data models, and driving platform enhancements using up-to-date engineering practices. This is a hands-on role for someone with strong data engineering fundamentals — someone who understands how to design scalable pipelines, model data effectively, and build reliable systems that serve business-critical workloads.

Responsibilities:

Data Modelling & Transformation
• Design and build data models that accurately represent business domains — applying dimensional modelling, slowly changing dimensions, and normalisation/denormalisation trade-offs appropriate to the use case.





• Develop and maintain data transformation logic using dbt on BigQuery — leveraging models, macros, incremental strategies, and tests to keep transformations modular, version-controlled, and well-documented.

• Define and enforce naming conventions, modelling standards, and layering practices (staging, intermediate, marts) across the data warehouse.

Data Pipeline Engineering
• Design, build, and maintain ELT pipelines that ingest, transform, validate, and serve financial data at scale — with a focus on reliability, idempotency, and observability.

• Build ingestion frameworks for external data vendor feeds — handling diverse file formats, schema variations, validation rules, reconciliation, and error recovery.

• Orchestrate pipeline workflows using Apache Airflow (Cloud Composer), managing dependencies, retries, SLAs, and alerting.

• Design and implement full- and incremental-load strategies, backfill mechanisms, and pipeli

📌 Senior Data Engineer – Python, BigQuery and DBT (Gurugram)
🏢 ISS STOXX
📍 Gurugram