Senior Specialist, PPK Reporting & Analytics CoE

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. **Department Overview**   The global PPK group is a key function, which helps to identify, create, and leverage “best of Bain” content, expertise, and helps Bain practice areas develop commercial strategies.    **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.    The Senior Specialist – Reporting & Analytics serves as a technical and analytical catalyst within the team. The role combines strong data management/ engineering capabilities, advanced analytics and BI expertise, and deep business understanding to modernize data consumption patterns, develop scalable BI and analytics solutions, and elevate analytical maturity across teams. The Senior Specialist also plays a key role in enabling change, mentoring team members, and partnering closely with stakeholders across Bain.    **Specific Responsibilities**   - Support the development and delivery of scalable analytics and reporting solutions using Databricks, Tableau, and related data and BI tools, ensuring outputs generate actionable insights and meet the needs of Bain leadership. - Contribute to the automation and optimization of data pipelines, reporting processes, and analytical workflows, leveraging SQL and Python to improve data quality, efficiency, and reliability of analytics solutions. - Own defined workstreams or components of larger analytics and data engineering initiatives, ensuring timely delivery, adherence to quality standards, and alignment with established data and reporting frameworks, under guidance from Managers and Senior Managers. - Collaborate within cross-functional teams to support data ingestion, preparation, modeling, and analysis, contributing analytical inputs that help shape robust, scalable technical solutions. - Implement and promote best practices in data management, semantic layer usage, and business intelligence reporting, ensuring consistency, performance optimization, and usability across analytics deliverables. - Actively contribute to a collaborative and high-performance team environment, supporting team initiatives and reinforcing shared standards, values, and ways of working. - Provide day-to-day guidance and informal mentorship to junior team members, supporting skill development in SQL, data modeling, Tableau, and analytics best practices, and ensuring alignment with project objectives. - Support talent and team development activities, such as onboarding of new team members, to enable rapid integration and effectiveness. - Contribute to continuous improvement and innovation efforts by identifying enhancement opportunities in data platforms, analytics tools, and reporting approaches, and assisting in the execution of small- to mid-scale initiatives aligned with business priorities.   **Qualifications**   - 8-10 years (graduates) or 6-8 years (MBAs) of relevant experience in data analytics, business intelligence, and data engineering or data management roles, with demonstrated depth in enterprise-scale analytics and reporting solutions. - Strong hands-on experience with Databricks, including advanced SQL development, data modeling, and performance optimization for analytics and BI consumption. - Advanced SQL proficiency, including sophisticated queries, window functions, query optimization, and working with large, normalized datasets in enterprise data w