Marsh & McLennan Mercer Marketplace - Health & Benefits Consulting Analyst in Dallas, Texas
The Senior Health and Benefits (H&B) Consulting Analyst will support consultants in managing client accounts by researching, analyzing, and evaluating medical, dental, life and disability benefits plans and programs for employers with more than 5,000 employees. The Senior H&B Analyst will exercise independent thinking and be able to complete projects with little guidance from consultants. To fulfill this role, the Senior H&B Consulting Analyst will:
Assist the consulting team in gathering, organizing entering and analyzing data into Excel spreadsheets to be used for various client projects.
Analyze the results and manage portions of projects, including reviewing the work of lower level analysts.
Gather benchmarking, utilization or rate data from the vendors via a Request for Proposal (RFP) and interpret the meaning of the data and summarize the responses from the RFP in Excel or PowerPoint format for presentation to the client .
Gather and analyze data from the client and vendors to populate Excel spreadsheets used for developing cost projections and evaluation of vendor renewal workups. Results are used as part of client renewal and budget meetings.
Gather data from client and vendors and check for reasonableness using independent judgment; analyze actual versus expected healthcare costs using an Excel template; results are typically sent to clients on a monthly or quarterly basis .
Gather data from the client and current vendors needed for analyzing the impact of a client's consolidation of its healthcare plans; typically involves organizing and summarizing plan design details and costs in Excel for further analysis by the team .
Check data for reasonableness and follow-up with vendors regarding missing or inaccurate data.
Understand vendor/carrier markets, more advanced underwriting and financial skills, Health & Benefit products, services and technical tools by participating in training courses, online learning, or through learning from more experienced colleagues.
Understand and demonstrate project management and consulting skills such to include: managing the quality and timeliness of client deliverables, helping to develop budgets and billing reports, participating in client calls and meetings as appropriate, delegating to and reviewing project work of more junior colleagues and assisting with the preparation and delivery of clear and concise client-friendly communications.
Develop and present benchmarking reports by gathering and analyzing health benefits data from a national survey administered and published by Mercer, input it into a standardized template and compare a client's medical and dental plan information (such as the benefits they offer, rates, contributions) to other companies by industry or geography and present the final report to the client. The analyst will meet with a consultant up front to determine what revisions of the report to make.
Qualifications BA/BS preferred One to three years of industry experience required Knowledge of MS Office Tools (Excel, PowerPoint) Excellent interpersonal skills; strong oral and written communication skills Ability to prioritize and handle multiple tasks in a demanding work environment Ability to work independently and on a team Required to obtain and maintain appropriate licenses as required by state regulations and Mercer policies. Mercer delivers advice and technology-driven solutions that help organizations meet the health, wealth and career needs of a changing workforce. Mercer’s more than 22,000 employees are based in 43 countries and the firm operates in over 130 countries. Mercer is a wholly owned subsidiary of Marsh & McLennan Companies (NYSE: MMC), the leading global professional services firm in the areas of risk, strategy and people.With more than 60,000 colleagues and annual revenue over $13 billion, Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment.Marsh & McLennan Companies is also the parent company of Marsh ,which advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions ; Guy Carpenter , which develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities ; and Oliver Wyman , which serves as a critical strategic, economic and brand advisor to private sector and governmental clients . For more information, visit www.mercer.com . Follow Mercer on 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: 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 . US ONLY: Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.