Marsh & McLennan Data Management Analyst in Louisville, Kentucky

Data Management Analyst


The Data Management Analyst is responsible for day to day compensation data analysis for Mercer’s survey clients. The incumbent supports with all activities related to survey participation, job matching/benchmarking (explain methodology and assist in matching some positions for the client as examples), data submission, accessing and interpreting our data, and working with the Client Service Representative’s on client participation needs. The Data Management Analyst is responsible for maintaining the integrity of data with a specific set of assigned clients as well as supporting the North American Compensation & Benefits (C&B) Center of Excellence (CoE) on client related activities such as webcast and results meetings.


  • Survey data management – Receive direction from Client Service Reps on client specific needs and targets during the survey cycle. Complete verification and validation of compensation data, submissions, and data validation files. Analysts will receive updated client info from Client Reps regarding compensation data; will assist with job matching and execute all data-related tasks.

  • Analysis - provide advanced / proficient submission support and report on post-submission analysis. Create insightful analytical reports for presentation and communication of the data. Relay the analytics to both the Mercer colleagues and the clients when needed. Provide valued information based on analysis and create communications that provide the analysis to clients in terms they can understand and utilize.

  • Client relationships – Assist Client Reps with increasing the quality of client data submissions, and to increase their clients’ understanding of Mercer survey processes and analysis.

  • Assist the Compensation & Benefits Center of Excellence (CoE) teams in the preparation of client meeting materials, assists in data review and analysis, and with custom surveys as needed.

  • Client documentation and reporting tasks – Contribute to the participation process documentation. Raise process improvement ideas/innovation to management and support the team’s innovation initiatives.


  • Continuously develop new skills and ways of doing things

  • Self-reflect and request feedback after trying out a new skill or way of doing something and refine your technique or process

  • Learn from mistakes and apply what you learned to achieve a better outcome the next time

  • Use the Mercer’s career development process to continually assess your own strengths and development areas, and use Mercer’s learning tools and resources to increase your skills

  • Understand and apply the key technical aspects of your role

  • Demonstrate expertise in one or two specialties within your practice/segment or function (e.g. job definitions, compensation)

  • Perform intermediate project management activities (preparing for, contributing to, and running meetings as appropriate, keeping stakeholders informed, transferring knowledge)

  • Advanced Microsoft Excel.

  • Previous experience in operating systems a desire.

  • Demonstrate basic consulting skills (e.g., goal-oriented problem solving)

  • Ask effective questions when taking on new assignments

  • Understand your own role and how it contributes to overall team objectives

  • Know about Mercer’s products/solutions, business-specific capabilities and sales processes

  • Demonstrate a clear understanding of how your actions can impact the client relationship and satisfaction (client could be direct or indirect).

  • Respond to client requests and issues quickly and efficiently, meet client expectations and raise issues to your team.

  • Understand how Mercer leverages resources, products and processes to meet clients’ business needs.

  • Demonstrate proper workplace etiquette and meets the firm’s standards of moral and ethical integrity.

  • Track customer/industry trends and find linkages with Mercer’s business.

  • Stay current on Mercer’s products/solutions and LOB-specific capabilities in the market.

  • Gain business context beyond the scope of your work (e.g., through connections with professional external organizations).

  • Ask questions to understand the business and market, now and in the future.

  • Prioritize your tasks and complete them independently to meet project objectives, timelines, service level agreements and budgets

  • Quickly identify and communicate issues affecting project deadlines

  • Offer ideas how to create efficiencies and prioritize workflow on a Project

  • Demonstrate curiosity about new approaches to problems or opportunities and challenge the status quo

  • Use data and facts to support proposed ideas and solutions

  • Contribute creative solutions to problems throughout all phases of projects and assignments

  • Share ideas on how to add value by creatively leveraging resources from across Mercer

  • Set personal goals and milestones to reach outcomes on time, on budget and without errors.

  • Prioritize work according to shifting project goals.

  • Understand objectives and seek better ways of delivering results.

  • Consistently and efficiently deliver quality outcomes.

  • Listen and ask questions to understand expectations, guidelines and other peoples’ points of view

  • Explain your point of view by demonstrating its value relative to alternative approaches; accept and support group decisions even when they differ from your own

  • Influence others through persuasion and logic Accurately gauge others’ reactions; adapt your influencing and communication styles as appropriate

  • Understand how individual actions impact the bottom line and take steps to manage costs (e.g. OT)

  • Set individual performance and development goals that align with Mercer’s strategic direction

  • Clearly document and articulate project goals

  • Know your team’s, LOB/function/geography’s and Mercer’s strategic Direction

  • Understand how your own work contributes to profitability and apply that understanding in daily work and decision-making.

  • Understand how individual project decisions and actions can have a financial impact on Mercer and Mercer's clients (e.g., ask “why am I doing this? before conducting analysis).

  • Know Mercer's suite of products and the value they add to clients.

  • Offer ideas in discussions on commercialization strategies.

  • Know Mercer’s competitors and our market position

  • Understand Mercer’s unique value and how our products and solutions distinguish us from our competitors

  • Learn what our competitors are doing to innovate in your area of Expertise

Key Metrics/Success Evaluations:

  • Deliver quality and accuracy

  • Complete to resolution all solicitation, submission assistance (‘problem companies’) and data verification/questions calls according to plan.

  • Respond to client calls and emails within 24 hours

  • Receive high client satisfaction marks (vehicle and ratings to be determined) from assigned set of clients.

  • Demonstrate understanding of Mercer Benchmark Database (MBD) jobs as evidenced by quality of submissions.

At Mercer, we make a difference in the lives of more than 110 million people every day by advancing their health, wealth, and careers. We’re in the business of creating more secure and rewarding futures for our clients and their employees — whether we’re designing affordable health plans, assuring income for retirement or aligning workers with workforce needs. Using analysis and insights as catalysts for change, we anticipate and understand the individual impact of business decisions, now and in the future. We see people’s current and future needs through a lens of innovation, and our holistic view, specialized expertise, and deep analytical rigor underpin each and every idea and solution we offer. For more than 70 years, we’ve turned our insights into actions, enabling people around the globe to live, work, and retire well. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. At Mercer, we say we Make Tomorrow, Today. Visit for more information and follow us on LinkedIn and Twitter @Mercer.

Mercer LLC and its separately incorporated operating entities around the world are part of Marsh & McLennan Companies, a publicly held company (ticker symbol: MMC).

Marsh & McLennan Companies offers competitive salaries and comprehensive benefits. For more information about our company, please visit us at: We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. For more information, please visit us at: .

US ONLY: Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Job Project Management

Primary Location US-KY-Louisville

Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Req ID: LOU001G8