Senior Associate PPK Reporting And Analytics CoE

Bain & Company; Gurugram District; On-site; INR 1,000,000 - 1,800,000; Full time

Job summary

Bain & Company seeks a Senior Associate to bolster the PPK Reporting & Analytics CoE. You will support analytics capabilities, develop reporting solutions, and collaborate with a cross‑functional team to drive data‑driven decisions.

The role emphasizes building automated reports, learning AI techniques, and contributing to the team’s delivery standards within a global BI framework. Candidates with strong SQL and Databricks skills are preferred.

Qualifications

• 4–7 years (graduates) or 2–5 years (post‑graduates) in data analytics and BI.
• Degree in a quantitative field is preferred.
• Hands‑on Databricks experience and SQL proficiency required.
• Experience with Tableau/Power BI and analytics frameworks.

Responsibilities

• Develop parts of reporting solutions using Tableau and similar tools.
• Automate routine reporting and support simple AI models with Python and R.
• Handle defined tasks within larger projects with guidance from seniors.
• Gather and prepare data for analytics and reporting, team collaboration.
• Write SQL queries to extract and analyze Databricks data.
• Understand ERDs, data models, and data relationships.
• Apply best practices in automation and reporting with seniors’ guidance.
• Participate in team meetings and contribute to collaboration.
• Provide guidance to Associates and junior team members.
• Assist onboarding of new team members and share processes.
• Contribute ideas in brainstorming sessions for innovation.

Skills

Analytical thinking

Attention to detail

Teamwork

Communication

Education

Quantitative discipline (Statistics/Math/Engineering/CS/Econometrics/Analytics)

Tools

Tableau

Python

SQL

Databricks

Power BI

Pandas

NumPy

Job description

Job Description:

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. We are currently the top ranked consulting firm on Glassdoor’s Best Places to Work list and have earned the #1 overall spot a record seven times.

Extraordinary teams are at the heart of our business strategy, but these don’t happen by chance. They require intentional focus on bringing together a broad set of backgrounds, cultures, experiences, perspectives, and skills in a supportive and inclusive work environment. We hire people with exceptional talent and create an environment in which every individual can thrive professionally and personally.

Company Overview

Bain & Company is a global consultancy that helps the world’s most ambitious change makers define the future. Across 67 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.

We complement our tailored, integrated expertise with a vibrant ecosystem of digital innovators to deliver better, faster, and more enduring outcomes. Our 10-year commitment to invest $2 billion in pro bono services brings our talent, expertise, and insight to organizations tackling today’s urgent challenges. We earned a platinum rating from EcoVadis, placing us in the top 1% of consulting firms globally. Since our founding in 1973, we’ve measured our success by the success of our clients, and we proudly maintain the highest level of client advocacy in the industry.

The firm established several functions in the Indian market early 2000s and its remit across functions has expanded over time. Since 2019, these functions have become part of Global Business Services (GBS). Global Business Services (GBS) is a network of five interconnected business‑function hubs across India, Poland, Malaysia, Mexico and Portugal, serving Bain globally to run our business, support other functions, and help drive innovation internally. We are over 1000 business professionals – serving functions in operations, HR, finance, legal, tech, marketing, research, and data analytics – who support our offices globally.

Our mantra of “shared innovation, seamless execution,” underpinned by a passion for results, teamwork, and creativity, helps Bain stay at the top of our game operationally.

Position Summary

PPK Reporting & Analytics CoE has experienced strong growth as an internal business intelligence and analytics business over the years. Given the expansion of the team, we are looking for a Senior Associate to support the core team and drive the analytical capabilities to its full potential over the next phase.

Specific Responsibilities

• Assist in developing specific parts of reporting solutions using Tableau, and similar tools, working under the guidance of Senior Specialists to ensure outputs meet project needs.
• Help automate routine reporting processes and support the implementation of simple AI models using Python and R. Focus on learning and applying techniques to improve operational tasks.
• Take responsibility for specific, well‑defined tasks within larger projects, ensuring they are completed on time and according to the specified standards. Receive close guidance and feedback from Senior Specialists and Managers.
• Assist in gathering and preparing data for analytics and reporting, contributing to cross‑functional team efforts in data‑driven projects.
• Write efficient SQL queries to extract, join, and analyze data from Databricks‑based schemas.
• Work with normalized data models and develop an understanding of ERDs, table relationships, and data definitions.
• Begin applying best practices in automation and reporting, focusing on consistency and accuracy in deliverables. Work closely with Senior Specialists to understand and follow established standards.
• Participate actively in team meetings and activities, contributing to a collaborative and supportive team environment as guided by Senior Specialists and Managers.
• Offer basic guidance and support to Associates and more junior team members, helping them understand tasks and project goals.
• Assist in the onboarding process of new team members by helping them acclimate to the team’s processes and culture.
• Participate in brainstorming sessions and contribute ideas for innovation initiatives, supporting smaller‑scale tasks within these projects.

Qualifications

• 4-7 years (graduates) or 2-5 years (post‑graduates) of relevant experience in data analytics, business intelligence, and reporting solutions development, with experience using tools like Tableau, Python, and SQL
• Concentration in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics, Business Analytics, or Market Research is strongly preferred.
• Hands‑on experience with Databricks, including Databricks SQL queries
• Proficiency in SQL, with experience in supporting database management tasks, optimizing queries, and assisting in database design efforts.
• Proficiency in using basic features of data visualization tools (e.g., Tableau, Power BI) and analytics frameworks (e.g., Pandas, NumPy), with a focus on learning best practices in reporting.
• Experience using AI tools to support the development of analytics‑based business solutions and improve output quality, effectiveness, and efficiency.
• Preferred: exposure to training and/ or deploying machine learning models for business analytics applications.
• Basic knowledge of Python, particularly in automating simple tasks, and a growing understanding of data processing and AI model implementation.
• Understanding of fundamental data structures and algorithms, with an ability to apply these concepts to simple analytics and reporting tasks.
• High level of documentation discipline, including dashboard documentation, metric descriptions, and assumptions
• Demonstrated problem‑solving abilities, with a focus on tackling data‑related issues and contributing to the successful delivery of analytics and reporting solutions.
• Ability to contribute to the development of reporting solutions and data analytics tasks that support decision‑making within specific projects.
• Experience working as part of a team in an analytics‑based environment, focusing on supporting the delivery of reporting solutions that assist with routine business activities.
• Good communication and teamwork skills, with the ability to collaborate effectively with team members and begin articulating basic technical aspects of data solutions.
• Experience working in an agile environment, with an ability to manage straightforward tasks within a dynamic project setting.
• Ability to collaborate with team members to ensure that assigned tasks align with project needs and contribute to overall project success.
• Strong analytical thinking and attention to detail, with an eagerness to learn modern analytics platforms and best practices.
• Demonstrated willingness to learn and apply new skills in data analytics and AI, with curiosity and a proactive approach to personal development.