Writes and structures client presentations/reports which typically require a high level of customization. Perform data analysis using advanced dynamic Excel modelling. Draws conclusions from the data for project managers’ and senior consultants’ review. Review and/or develop exhibits based on collected and calculated data. Works closely with project managers and senior consultants on the project to determine the exhibits to be included in the final client presentations. Understand project components and processes to make sure analyses are correct. Accountable for delivery of high quality work on time and on budget.
Applies computer and research skills to understand financial performance, talent management trends, and pay practices and policies for a particular client and within the broader marketplace.
Reviews Excel exhibits in PowerPoint presentations and initial conclusions prepared by analysts. Review financial and compensation data analyses prepared by analysts, ensuring it is accurately calculating desired information. Oversee the development of methodology by analysts and manage small to medium engagements.
Provides guidance to project team analysts and ensures timely delivery of work and achievement of project objectives.
Typically manages smaller projects and workstreams of larger client projects. May lead additional internal projects as needed and participates in business development by supporting project plan development and pricing.
Serve as a day-to-day client contact for project areas including methodology, data requests and data management.
Act as a liaison between the Mercer project team and the client secondary contact (i.e., compensation analyst). Participate in meetings with clients, including fact-finding interviews and presentations.
Uses Mercer’s proprietary tools (e.g., Global Disclosure Database which houses info compiled from public filings from many organizations across multiple industries; PayMonitor which is the delivery tool for Mercer surveys globally, including both compensation and total reward surveys, used to query, view and export survey statistics for actual and regressed market data, and to generate custom survey reports) and public filings to gather pay practices and policies. May also research other sources to solicit industry knowledge, company news, competitor reports on high level/ industry trends, etc.
Develops and reviews peer groups – lists of organizations against which the client organization is compared (e.g., based on revenue, brand, industry, etc.) and/or are the client’s direct competitors.