COMPANY PROFILE
Bain & Company is one of the world’s top management consulting firms, partnering with ambitious organizations across 65 cities in 40 countries to achieve extraordinary results. Global Business Services (GBS) is a network of five hubs across India, Poland, Malaysia, Mexico, and Portugal — a 1,000+ strong team supporting operations, finance, tech, data analytics, and more. Our mantra: “shared innovation, seamless execution.”
JOB SUMMARY
The Senior Associate Data Engineer is a hands-on technical role within the NGSS team focused on building and maintaining data pipelines, data models, and cloud data infrastructure. You will work closely with senior engineers to deliver reliable data solutions that support Bain case teams and clients globally. This role suits a data engineering professional with around 2 years of experience looking to grow in a high-impact consulting setting.
KEY RESPONSIBILITIES
Data Engineering — Pipelines, Modeling & Quality (80%)




Build and maintain ETL/ELT pipelines to ingest and transform data from multiple sources into cloud data warehouses using tools such as Azure Data Factory, dbt, or Airflow.
Write efficient SQL and Python scripts for data extraction, transformation, and workflow automation.
Implement error handling, alerting, and incremental load strategies to ensure pipeline reliability and resilience.
Develop and run Python-based data workloads and notebooks on Databricks using PySpark for large-scale data processing and transformation.
Develop and maintain dimensional data models (star/snowflake schema) on Snowflake or Azure Synapse; support schema design and query performance optimization.
Implement automated data validation checks and monitor pipelines for failures, drift, and anomalies.
Maintain documentation of data sources, transformation logic, and data lineage to support governance requirements.
Software Engineering & Cloud/DevOps (20%)
Apply software engineering best practices — version control (Git), modular co

📌 Senior Associate Engineer, Data Engineering (Gurugram)
🏢 Bain
📍 Gurugram