Associate, Reporting and Analytics

Bain & Company, Inc.; Haryana; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Bain & Company, a global management consulting firm, is seeking a Reporting & Analytics Associate for its GBS Gurugram office. The role focuses on delivering business intelligence to Bain's global functions.

You will build workflows and dashboards with Alteryx, Python, SQL, Tableau, and Power BI, maintain dashboards, and support leadership analytics while learning Bain processes and agile methods.

Qualifications

• 2-5 years (graduates) or 0-3 years (post-graduates) of relevant experience in data analytics, business intelligence, and reporting solutions.
• Experience with Excel, Alteryx, Tableau and Python is expected.
• Strong problem-solving skills and willingness to learn.
• Ability to work under supervision and in agile environments.
• Basic understanding of data structures and algorithms.
• Good communication and teamwork.
• Exposure to AI model tasks is a plus.

Responsibilities

• Apply data visualization and data analysis tools like Alteryx, Python, SQL, Tableau Prep, or other EDA tools.
• Create new dashboards using Tableau, Power BI or Advanced Excel.
• Refresh and maintain dashboards on Tableau/Power BI and optimize workflows.
• Develop expertise on Bain data sources to deliver outputs.
• Use basic Generative AI to brainstorm and optimize tasks.

Skills

Problem solving

Teamwork

Communication

Learning mindset

Agile mindset

Python basics

SQL basics

Tableau/Power BI basics

Education

First class undergraduate/postgraduate

Quantitative discipline preferred

Tools

Excel

Alteryx

Tableau

Power BI

Python

SQL

Job description

Bain & Company is one of the top management consulting firms in the world that helps the world’s most ambitious changemakers define the future.

Across 65 cities in 40 countries, we work alongside our clients as one team with a shared ambition to achieve extraordinary results, outperforming the competition, and redefining industries. We complement our tailored, integrated expertise with a vibrant ecosystem of digital innovators to deliver better, faster, and more enduring outcomes.

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 functions 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.

WHAT MAKES US 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 #1 ranked consulting firm on Glassdoor's Best Places to Work list and have maintained a spot in the top four on Glassdoor's list since its founding in 2009.

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.

Job Summary

The Reporting & Analytics Associate is a techno functional role based in Bain’s GBS Gurugram office and is part of a team which provides business intelligence services (including insights and analytics) on key metrics to global functions (not external clients) at Bain.

The major responsibilities of the role include supporting recurring and ad-hoc analytics on key metrics as required by Bain's leadership, using automated data processing and visualization tools by:

• Building new workflows using Alteryx/Python/SQL/Tableau Prep (or other EDA tools)
• Building new dashboards using Tableau/Power BI/Advanced Excel (or other visualization tools)
• Refreshing and maintaining dashboards on Tableau/ Power BI, along with optimization of Alteryx /Tableau Prep workflow
• Developing expertise on key Bain data sources to deliver effective output
• Using basic Generative AI to brainstorm and optimize operational tasks

Principal Accountabilities and % of time

Operational Execution

• Applies and builds technical expertise of Data Visualization and Data Analysis (EDA) tools like Alteryx, Python, SQL ,Tableau, Power BI etc.
• Help with the creation of basic reporting solutions using tools like Alteryx and Tableau, focusing on learning, and supporting the team in routine tasks.
• Assist in automating simple, repetitive tasks in reporting processes using Python and SQL. Focus on gaining experience and understanding basic automation techniques
• Take responsibility for completing small, well-defined tasks within projects. Ensure tasks are completed as instructed by more senior team members.

Problem solving

• Assist in collecting and preparing data for analysis and reporting, ensuring data is clean and ready for use in projects.
• Begin learning and applying basic best practices in automation and reporting, focusing on accuracy and consistency in work.
• Participate in team brainstorming sessions and offer ideas for simple improvements or innovations, focusing on learning the creative process.
• Work closely with Senior Associates and Senior Specialists, applying feedback and learning from more experienced team members.
• Build basic understanding of Bain business processes

Team Activities

• Actively participate in team activities, training sessions, and meetings to build knowledge and understand the team’s processes.
• Assist in the smooth operation of the team’s activities by helping with routine tasks and learning about the team’s culture and processes.

Knowledge, Skills, and Abilities

Required:

• Strong problem-solving skills, with a willingness to learn and apply solutions to data and reporting tasks under supervision.
• Ability to contribute to simple tasks within the development of reporting solutions and data analytics projects, with guidance from senior team members.
• Developing communication skills, with a focus on working effectively within a team and understanding basic technical instructions.
• Curiosity and a willingness to learn new skills in data analytics, automation, and AI, with a proactive approach to personal development.
• Understanding of basic data structures and algorithms, with the ability to apply these concepts in simple tasks under supervision.
• Ability to follow instructions and collaborate effectively with team members, contributing to the success of assigned tasks.
• Exposure to working in an agile environment, with a focus on learning how to manage tasks within a fast-paced project setting.

Preferred:

• Basic understanding of SQL, with some experience in data management tasks, query optimization, and supporting schema design.
• Knowledge of Python, with an emphasis on automating basic tasks and a growing understanding of data processing.
• Familiarity with basic features of data visualization tools (e.g., Tableau, Power BI) and analytics frameworks (e.g., Pandas, NumPy), with a focus on learning and development.
• Experience in assisting with simple AI model tasks, such as text classification, with direct supervision.

Experience

Required:

• 2-5 years (graduates) or 0-3 years (post-graduates) of relevant experience in data analytics, business intelligence, and reporting solutions, with exposure to tools like Excel, Alteryx, Tableau and Python
• Basic experience working in a data-focused environment, with an emphasis on supporting routine reporting tasks and learning from more experienced team members.

Preferred:

• Experience in assisting with simple AI model tasks, such as text classification, with direct supervision.

Education OR equivalent combination of education, training, and experience

Required:

First class undergraduate/post graduate from leading and reputed colleges

Preferred:

Concentration in a quantitative discipline such as Statistics, Mathematics, Engineering, Computer Science, Econometrics, Business Administration, Finance, Business Analytics, or Market Research is strongly preferred

Recommended Years of Relevant Experience – 0-2+