Senior Associate, Org Coe (data Engineer) (New Delhi)

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 ABOUT US Ba