WHAT YOU'LL DO
As a Senior Data Analyst, you will play a critical role in PSG by managing complex analytics, supporting compensation and equity programs for MDPs across 50+ countries, and contributing to strategic decision-making for BCG leadership. You will build on existing financial models, create advanced reports, and streamline operational processes using automation and data visualization tools.
Key Responsibilities:
Advanced Analytics: Perform deep-dive analysis on compensation, equity, and financial metrics to identify trends, discrepancies, and areas for improvement, using large datasets and statistical methodologies.
Modeling and Scenario Projections: Lead the generation of MDP financial estimates, including accruals, cash basis reporting, and scenario modeling for various lifecycle events such as office transfers, hires, and departures.
Technical Automation: Enhance operational processes by leveraging automation tools like Alteryx, Python, PowerAutomate, Power BI, and Tableau to streamline recurring tasks, improve controls, and elevate reporting capabilities.
Cross-functional Collaboration: Collaborate closely with PSG and finance teams (Tax, Treasury, Global Accounting) to ensure compensation and equity processes are aligned globally, accounting for geographic and currency variations.
Stakeholder Reporting: Develop and present insightful reports and visualizations to senior management, enabling informed decision-making on compensation, equity, and MDP lifecycle events.
Process Improvement: Lead continuous improvement initiatives, including data cleansing, validation, and transformation projects to enhance overall reporting accuracy.
YOU'RE GOOD AT
You are a detail-oriented professional with strong problem-solving and analytical skills, comfortable managing multiple initiatives in a fast-paced environment.
Skills and Attributes:
Technical Proficiency: High proficiency in Excel (pivot tables, nested functions, mixed references, arrays) and experience with, or willingness to learn, data visualization/ automation tools like Tableau, SQL, and Power BI.
YOU BRING (EXPERIENCE & QUALIFICATIONS)
You have successfully operated in a fast-paced, matrixed environment. We are looking for a well-rounded individual who is comfortable navigating complex problems and can work collaboratively to help bring insights to light for leadership.
Experience & Qualifications:
Bachelor’s degree in Finance, Accounting, Economics, Statistics, Data Science, or related field.
YOU'LL WORK WITH
Partner Services Group (PSG). PSG is an integral part of BCG’s Global Services function. Global Services (GS) consists of a varied range of functions providing corporate support of BCG's business and strategic priorities for example, Finance, Legal, HR, Marketing, IT, Risk, PSG and more. This diverse team of experts, operators, and specialists represent all levels from MDP to entry level staff, operating across the globe in multiple countries.
This role will be part of the PSG Analytics & MDP Support team and will work closely with the Compensation & Equity team and other PSG sub-functions. You will work with Roberto Sestito, Stef Steege, Laura McDonnell, and the broader PSG team. Depending on specific workstream, you will work closely with a subset of the team on a day-to-day basis and with exposure to Amy Glass and Ben Holden, as the MDP Co-Leads of PSG function. You will also team with Agile systems teams and the product owner of Business Insights & Analytics.