Overview

Bain & Company is a global consultancy that helps the world's most ambitious change makers define the future.

Responsibilities

• 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.)

Qualifications

• Candidate should be a Graduate/Post-Graduate from top-tier College with strong academic records and with 5-7 years of relevant
• 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
• 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
• 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
• Knowledge of Environment creation and management
• Knowledge of CI/CD pipelines: GitHub, Docker, and containerization 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