Assists the consulting team in gathering, organizing, entering and analyzing data using Excel spreadsheets to be used for various client projects.Involves increased focus on analysis of results and managing portions of projects; reviews the work of lower level anaysts.

Gathers utilization or rate data from the vendors via a Request for Proposal (RFP); interpret the meaning of the data and summarize the responses from the RFP in Excel or PowerPoint format for presentation to the client.

Develops cost projections and evaluation of vendor renewal workups; results are used as part of client meetings.

Demonstrates project management and consulting skills such as managing the quality and timeliness of client deliverables; helps to develop budget and billing reports; participates in calls and meetings as appropriate; assists with the preparation and delivery of clear and concise communications and resolves most claim issues but can escalate more complex issues to senior consultants as needed.

Gathers design data from the client and current vendors needed for analyzing the impact of a client's consolidation and/or marketing of its healthcare plans; typically involves organizing plan design details and costs in Excel for further analysis by the team; responsibilities also include checking data for reasonableness and follow-up with vendors regarding missing or inaccurate data.

Learns the basics of products, services and tools - gain an understanding of vendor/carrier markets, basic underwriting and financial skills, products, services and technical tools, and intranet resources and participates in training courses, online learning, or through learning from more experienced colleagues.

Mercer, a business of Marsh McLennan (NYSE: MMC), is a global leader in helping clients realize their investment objectives, shape the future of work and enhance health and retirement outcomes for their people. Marsh McLennan is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses: Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit mercer.com, or follow on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. In the recruitment process, Marsh McLennan does not restrict a position to a particular gender, does not inquire or investigate the marital or maternal status of female candidates, does not impose any limitations on marriage or childbirth, does not use marital or maternal status of a condition for hiring, and does not raise the qualification standard for female candidates. When you apply for a position with us, we must obtain Personal Data, which is any data that can directly or indirectly lead to the identification of a specific individual, such as your name, contact information, employment history, education information, work skills, and licensure and certifications (if applicable). We also collect any other information you have provided in your CV, covering letter, application form, or during an interview (if applicable). Marsh McLennan limits the Personal Data that it collects to that which is relevant and proportionate for the intended purpose. Where necessary and permitted or required by law, we may collect Personal Data deemed sensitive under applicable law (for example, ethnicity, fitness to work or criminal convictions information). Marsh McLennan collects Personal Data directly from you and, depending on the circumstances and the type of role applied for, recruitment agencies, background check providers, your named referees and occupational health providers. Marsh McLennan retains Personal Data consistent with applicable local law and business practices Please make sure you read through and fully understand our “Job Applicant Data Privacy Statement” before you submit your application.

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.