Compensation Analytics Principal Analyst

Role Summary

The Compensation Analytics Principal Analyst is responsible for compensation surveys, salary benchmarking, and structures for the US Region. The role also develops compensation analytics and digital tools and will support global pay equity analytics. This position is based in the Boston area with hybrid work in Lexington or Cambridge, MA.

Responsibilities

• Compensation Benchmarking Lead for US Region: Primary contact for US market intelligence. Responsible for survey submission, data aggregation and analysis. Provides annual survey benchmarking and salary structures for the US Regular, Premium, MD, Sales, Executive, and Intern structures. Partners with Director Market Insights and US Comp Partners on annual US structure refresh, new salary structure/range builds, and larger projects/initiatives.
• Provides in-depth analysis for use in presentations with respect to market data analysis, data trends, and ad hoc market data analysis/requests
• Participates in spot surveys, salary surveys, data audits, file uploads, as required
• Keeps current and advises HR on US market and industry trends
• Digital Tools, Analytics, and Governance: Builds processes to streamline and transform MarketPay/current excel data loads and audits using digital tools (e.g. using excel macros, dot net tools or other internal digital resources)
• Develops analytics/tools to assist comp team with executive offers and benchmarks and develop process flow automation using new digital applications/AI (Powerautomate)
• Develops/designs innovative compensation analytics in Visier to drive new insights; explores linkages between Visier, Workday and MarketPay
• In partnership with HR Technology and Compensation Operations, evaluates new and existing Workday compensation plans and rules, assessing opportunities to streamline and support job architecture principles
• Pay Equity Support: Supports Takeda's Global Pay Equity program in partnership with the Pay Equity team by performing ETL (Extract, Transform, Load) and working with R-values (statistical measures)
• Audits pay equity source information, including investigating linkages to Workday compensation plans and rules, and supports/troubleshoots R coding and data cleaning as needed during the pay analytics cycle
• Prepares analytics for presentations of results to HR and business
• External Research and Market Intelligence: Leverages AI to organize existing and incoming external market data intelligence into a comprehensive library
• Responsible for year-over-year country salary budgets vs. competitive trends
• Evaluates annual survey job library updates for major changes to jobs/methodology

Qualifications

• Required: Prior compensation survey and benchmarking experience
• Preferred: Experience in MarketPay
• Required: Expert user of Excel; employs data mining techniques to extract valuable insights from large datasets
• Required: Working knowledge of VBA, R programming or Python
• Required: Experience with data visualizations, analytics, and reporting/dashboards in Workday, Visio, PowerBI or similar tools
• Required: Executes complex compensation analyses independently; strong problem definition and problem solving; can advise others and make recommendations
• Required: Analyzes and audits data meticulously; maintains high attention to detail; provides guidance on precision
• Required: Designs and delivers compelling analytics for presentations; can simplify complex datasets and concepts

Skills

• Excel expert; data mining to extract insights
• Programming languages: VBA, R, Python
• Data visualization and analytics/dashboards in Workday, Visio, PowerBI or similar

Education

• Preferred: University degree with at least 3 years of relevant experience

Additional Requirements

• Occasional travel (<10%) to industry/vendor conferences and meetings may be required
• Hybrid to Lexington MA or Cambridge MA; 5 days minimum per month in office