Senior Associate, Org CoE (Data Engineer)

Bain & Company; Delhi; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Bain & Company is seeking a senior data engineer to join the BCN within the Data & Tech cluster in New Delhi. The role focuses on building and evolving state-of-the-art data assets and analytics pipelines across Snowflake, Azure, and AWS.

You will work with Bain case teams globally, delivering scalable ETL solutions, advanced SQL, Python scripts, and end-to-end data workflows to support operating model and organization analytics.

Qualifications

• 5–7 years of relevant experience in Data Management, BI or Analytics.
• Strong background in cloud-based data platforms (Snowflake/Azure).
• Proficiency in Python and advanced SQL queries.

Responsibilities

• End-to-end data processing: gathering requirements, cleaning, and automation.
• Design, build, and maintain data pipelines and infrastructure for large datasets.
• Collaborate with Bain teams and clients to deliver data-driven insights.
• Transform data to end-user oriented formats and ensure scalable architecture.
• Investigate data quality and ETL issues; propose practical solutions.
• Lead client/case team discussions and communicate findings effectively.
• Document data architecture and processes for future reference.
• Support product development with scalable pipelines and automation.

Skills

Snowflake

Azure Data Factory

DataBricks

Python

SQL

ETL

Cloud platforms

Data analysis

Education

Graduate/Post-Graduate

Tools

SnowPark

Azure

AWS

GitHub

Job description

About Us

Bain & Company is a global consultancy that helps the world’s most ambitious change makers define the future. Across 61 offices in 39 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperform the competition and redefine industries. Since our founding in 1973, we have measured our success by the success of our clients, and we proudly maintain the highest level of client advocacy in the industry.

About Us

Bain & Company is a global consultancy that helps the world’s most ambitious change makers define the future. Across 61 offices in 39 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperform the competition and redefine industries. Since our founding in 1973, we have measured our success by the success of our clients, and we proudly maintain the highest level of client advocacy in the industry.

In 2004, the firm established its presence in the Indian market by opening the Bain Capability Center (BCC) in New Delhi. The BCC is now known as BCN (Bain Capability Network) with its nodes across various geographies. BCN plays a critical role in supporting Bain's case teams globally to help with analytics and research across all industries, for corporate cases, client development, private equity diligence or Bain intellectual property. The BCN comprises of Consulting Services, Knowledge Services and Shared Services.

Who You’ll Work With

This role is based out of the People & ORG CoE which sits in the broader Data & Tech cluster at the BCN. People & ORG CoE works on building and deploying analytical solutions pertaining to Operating Model and Organization Practice. The team primarily helps Bain case teams, across geographies and industries, solve critical client issues by applying battle-proven diagnostics/ solutions that can identify client pain points related to org, culture, and talent. The team also plays a significant role in creating, testing, and contributing to the proprietary products and Bain IP within the Org domain. This role will focus on development, maintenance and evolution of the state-of-the art org tool and data assets.

What You’ll Do

• Responsible for end-to-end handling of the entire process, i.e., requirement gathering, data cleaning, processing and automation
• Design, build, and maintain infrastructure and systems that enable the Extraction, Transformation, and Storage of large datasets for analysis
• Work with Bain team or end-clients as an expert on specific platform/tool/language (Snowflake/Azure/AWS/Python/SQL etc.) in individual capacity or lead teams of analysts and associates to design and deliver impactful insights
• Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
• Ensure that the data architecture is scalable and maintainable
• Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
• Apply knowledge of data analysis tools like SnowPark, Azure Data Factory, Azure Data Bricks, AWS Athena, Alteryx, etc. to support case teams with analysis of KPIs
• Solve complex custom visualization and analysis issues, providing thought leadership and business judgment
• Prepare documentation for further reference
• The working style of the team would be to support product development; hence the pipelines and algorithm built should be scalable and automated
• Manage internal and external stakeholders, across instruments and workstreams to provide expertise in data management and tool expertise
• Work under the guidance of a Team Manager / Sr. Team Manager, playing a key role in driving the team’s overall answer and final materials, client communication, work planning, and team management
• May also take responsibility for assigning work streams to Analysts & Associates, monitor and balance workload; Provides tool based technical expertise to the junior team members when required
• May deploy Data engineering solutions using CI/CD pipelines (GitHub, Cloud servers using Snowflake/Azure/AWS)
• Lead client/ case team calls and effectively communicate data, knowledge, insights and actionable next steps to the case team; relay implications to his/her own internal team
• Keep abreast of new and current statistical, database and data warehousing tools & techniques
• Recognize team’s development needs and consistently provide responsible feedback in all interactions via conducting performance discussions, writing reviews for appraisal etc.
• Assist on other team management activities (e.g. recruiting, training, etc.)

About You

• Candidate should be a Graduate/Post-Graduate from top-tier College with strong academic records and with 5-7 years of relevant work experience in areas related to Data Management, Business Intelligence or Business Analytics. Hands-on experience in data handling and ETL workstreams. AI
• Concentration in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics, Business Analytics, or Market Research is strongly preferred
• Minimum 5+ years of experience in Database development on Cloud based platform Snowflake OR Azure
• Experience on ETL processing via either SnowPark and Snowflake or Azure Data Factory and DataBricks is a must
• Proficiency with Python and Advanced SQL queries, Stored procedures, query performance tuning, index maintenance, etc.
• Candidates with advanced certifications in Snowflake and/or Azure will be preferred
• Experience of data modeling, data warehousing principles
• Experience in reading data from different data sources including on premise data servers, cloud services and several file formats
• Hands-on experience with chatbot/AI-enabled solutions with cloud AI services (AWS, GCP, Azure), and understanding of MLOps (CI/CD, model versioning, monitoring) will be preferred
• Proficiency with NLP, conversational design, and dialogue management, knowledge of vector databases and retrieval-augmented generation (RAG) will be a plus
• Should be a motivated and collaborative team player, who is a role-model and at-cause individual within the team and office
• Must be willing to own and maintain high visibility and high impact product
• Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical senior stakeholders
• Must have ability to generate and screen realistic answers based on sound reality checks and recommend actionable solutions
• Ability to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines

Good To Have

• Experience on AWS, GCP
• Experience in building Custom GPTs and AI Agents
• Knowledge of Environment creation and management
• Knowledge of CI/CD pipelines: GitHub, Docker, and containerization is a plus
• Experience in managing productized solutions is a plus

What Makes Us a Great Place To Work

We are proud to be consistently recognized as one of the world's best places to work, a champion of diversity and a model of social responsibility. We are currently ranked the #1 consulting firm on Glassdoor’s Best Places to Work list, and we have maintained a spot in the top four on Glassdoor's list for the last 12 years. We believe that diversity, inclusion and collaboration is key to building extraordinary teams. We hire people with exceptional talents, abilities and potential, then create an environment where you can become the best version of yourself and thrive both professionally and personally. We are publicly recognized by external parties such as Fortune, Vault, Mogul, Working Mother, Glassdoor and the Human Rights Campaign for being a great place to work for diversity and inclusion, women, LGBTQ and parents.