About us
Bain & Company is a global management consulting that helps the world’s most ambitious change makers define the future. Across 65 offices in 40 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 is an integral and largest unit of (ECD) Expert Client Delivery. ECD plays a critical role as it adds value to Bain's case teams globally by supporting them with analytics and research solutioning across all industries, specific domains 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 will work with
This role is based out of the Visualization Centre of Excellence (CoE) at the BCN. Visualization CoE works closely with global Bain case teams, Bain Partners and end-clients providing them data analytics and business intelligence support using advanced data analysis and visualization tools (e.g., SQL, Python, Azure, AWS, Tableau, PowerBI, Alteryx etc.). The CoE is a one-stop shop for all case requests related to converting data into insightful visualizations tools (e.g., survey analytics, leadership KPI dashboards, etc).
What you’ll do
Responsible for end-to-end handling of the entire process, i.e., requirement gathering, data cleaning, processing and automationDesign, build, and maintain infrastructure and systems that enable the Extraction, Transformation, and Storage of large datasets for analysisWork with Bain team or end-clients as an expert on specific platform/tool/language (Azure/AWS/Python/SQL etc.) in individual capacity or lead teams of analysts and associates to design and deliver impactful insightsGather requirements and business process knowledge in order to transform the data in a way that’s geared towards the needs of end usersEnsure that the data architecture is scalable and maintainableInvestigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutionsApply knowledge of data analysis tools like Azure Data Bricks, AWS Athena, Alteryx, etc. to support case teams with analysis of KPIsSolve complex custom visualization and analysis issues, providing thought leadership and business judgmentPrepare 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 automatedManage internal and external stakeholders, across instruments and workstreams to provide expertise in data management and tool expertiseWork 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 managementMay 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 requiredDeploy Data engineering solutions using CI/CD pipelines (GitHub, Cloud servers using 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 teamKeep abreast of new and current statistical, database and data warehousing tools & techniquesRecognize 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 workstreamsConcentration 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 platforms such as AWS/Azure, Environment creation and managementProficiency with Python and Advanced SQL queries, Stored procedures, query performance tuning, index maintenance, etc., Experience on Snowflake is a plusExperience of data modeling, data warehousing principlesExperience on ETL tools in anyone of the tools like Azure Datafactory, Databricks, AWS Glue etc. Experience in reading data from different data sources including on premise data servers, cloud services and several file formats Understanding of database architectureKnowledge of CI/CD pipelines: GitHub, Docker, and containerization is a plusCandidates with advanced certifications in AWS and Azure will be preferredShould be a motivated and collaborative team player, who is a role-model and at-cause individual within the team and officeExcellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical senior stakeholdersAbility to prioritize projects, manage multiple competing priorities and drive projects to completion under tight deadlines
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..