Let’s be #BrilliantTogether

Overview:

We are looking for a Senior Data Engineer to join our Index Engineering team in Gurgaon. You will be part of a team that builds and evolves critical data platforms on a up-to-date 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 robust 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 pipeline-

📌 Senior Data Engineer – Python Gurugram
🏢 ISS STOXX
📍 Gurugram