Associate Director, Data Engineer

Overview

Associate Director, Data Engineer for the DTS Business Intelligence team, designing and building data pipelines, lakehouse datasets, and Power BI data products.

What you'll do

• Design, build, and maintain scalable ETL/ELT pipelines for ingesting data into a lakehouse and warehouse.
• Perform SQL/Python/Power BI transformations and maintain datasets used by data products.
• Design and evolve data models and gold-tier datasets in Databricks and Microsoft Fabric.
• Use Azure services for data ingestion, transformation, storage, and processing.
• Implement automated job scheduling, monitoring, and observability with self-healing where possible.
• Own data quality using automated testing, validation, reconciliation, and continuous improvement.
• Build and maintain Power BI dataflows and semantic models and support reliable report refresh.

What you'll need

• 8+ years in data engineering, business intelligence, or a related discipline, including senior/lead technical contribution.
• Bachelor’s or Master’s degree in Computer Science, Engineering, Information Systems, or a related field.
• Strong ETL/ELT pipeline design and dimensional/lakehouse data modeling plus Python for data transformation.
• Advanced SQL for data manipulation, transformation, and performance tuning.
• Power BI proficiency including DAX, Power Query, dataflows, and semantic model design.
• Hands-on experience with Databricks and Microsoft Fabric for lakehouse architectures.
• Proficiency with Azure cloud services for scalable processing and storage, plus experience with automated testing and data governance/documentation.

Details

• Location: Gurugram, Haryana.