Bain & Company Inc

Associate- ETL

Job Location India-Gurgaon
Job ID
Posted Date
Bain Capability Network
Regular Full-Time


Bain & Company is one of the top management consulting firms in the world. In 2004, the firm established its presence in the Indian market by opening the Bain Capability Center in Gurugram, now renamed as Bain Capability Network (BCN). The BCN plays a critical role in supporting Bain's case teams and initiatives globally to help with analytics and research across all industries and capabilities.



Pyxis combines alternative data, AI-driven analytics, and institutional investor-led insights to reveal where, how and why consumers buy, how they pay, how much they spend, how their needs and demands are changing, and much more.


By revealing previously opaque fundamental business trends and their drivers, Pyxis enables investors and business decision makers to efficiently allocate capital and address critical problems.


Pyxis has assembled one of the most comprehensive collections of alternative data covering hundreds of millions of people and tens of billions of transactions across the U.S., Canada, Brazil, UK, France and Japan as well as targeted countries across the EU and APAC. This data provides a longitudinal view of consumer and business transactional behaviors—across nearly all verticals over the last six years—and plays an integral role in answering companies’ and investors’ questions about market share, category size, pricing and promotion effectiveness, assortment optimization, ad targeting, loyalty, switching behavior, disruption, and more.


These state-of-the art capabilities enable Bain to provide its clients with a valuable new dimension in investment analysis and strategy development, complementing Bain’s proven “outside-in” approach with the ability to apply complex data sets to assess company fundamentals.


BCN Pyxis modeler will work closely with the BCN team manager, Pyxis Product Manager, General Manager, Bain Partners, and the Proprietary Data group to build and deliver a commercially successful product that spans core sectors across all regions. 


  • Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities
  • Gather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end users
  • Write SQL queries and stored procedures in Snowflake to manipulate and process data
  • Use AWS data bricks as ETL platform
  • Maintain and improve already existing processes
  • Ensure that the data architecture is scalable and maintainable
  • Work with the business in designing and delivering correct, high quality data
  • Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
  • Prepare documentation for further reference



  • Work experience: 3-5+ years of experience in areas related to Data Management, Business Intelligence or Business Analytics. Hands-on experience in data handling and ETL workstreams
  • Education Required: Incumbent should be a graduate/post graduate from top-tier institute or have pursued a statistical/analytical course from a tier 1 university 
  • Knowledge, Skills and Abilities Required:
  • SQL knowledge (Advanced SQL queries, Stored procedures, query performance tuning, index maintenance, etc.)
  • Understanding of database architecture
  • Knowledge of data modeling and data warehousing principles
  • Experience on ETL tools
  • Experience on Snowflake is a plus
  • Knowledge of AWS Databricks & Python is a plus (not mandatory)
  • Organizational skills: time management and planning
  • High attention to detail
  • Passionate about complex data structures and problem solving


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.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed