Marsh & McLennan Senior H&B Consulting Analyst in Chicago, Illinois

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. 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 www.mercer.com for more information and follow us on LinkedIn and Twitter @Mercer Marsh & McLennan Companies offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: http://www.mmc.com/. 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: www.mmc.com/diversity . 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 and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. R040395-en R040395