Senior Government Healthcare Financial Consultant – Reporting and Monitoring

Company:

Mercer

Description:

Mercer Health & Benefits, LLC is seeking candidates for the following full-time position based in the Salt Lake City, UT office (A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with company policies.):

Senior Government Healthcare Financial Consultant – Reporting and Monitoring

We will count on you to:

Conduct in-depth data analysis and prepare financial reports for organizations within the healthcare sector. Gather and organize financial data from various sources, including claims databases and financial management systems, to facilitate effective reporting and analysis. Utilize advanced Excel functions, statistical analysis software (e.g., R or SAS), and data visualization tools (e.g., Tableau or Power BI) to conduct preliminary data analysis related to key performance metrics and quarterly financial and operational reports. Assist in audits, such as Medical Loss Ratios (MLR) and Rate Development Template (RDT) audits, ensuring that RDTs are accurately reported by Managed Care Organizations. Partner with state governments to examine financial reports in order to understand emerging Medicaid health care experience as well as the financial performance of managed care organizations. Interact with credentialed actuaries and financial executives to ensure Medicaid dollars are being utilized efficiently. Work with client and team project managers to clearly define the scope, timelines and deliverable(s) of projects; ensure development of essential project documents, including budget and work plans. Collaborate with team members to discuss findings and insights, contributing to the overall success of consulting projects while engaging in professional development to enhance analytical skills and knowledge of compliance requirements.

What You Need To Have:

Must have a Bachelor’s degree or foreign equivalent in Public Administration, Finance, Information Systems, or a related field plus three (3) years of experience in the position offered or a related position. Alternatively, employer will accept a Master’s degree or foreign equivalent in Public Administration, Finance, Information Systems, or a related field plus one (1) year of experience in the position offered or a related position. Must have three (3) years (or one [1] year with a Master’s) of experience with all of the following: Performing healthcare financial analysis of Medicaid health plans, including medical loss ratio review and expense variance analysis; Creating financial models for Medicaid health plans using Microsoft Excel advanced formulas including Index Match and vlookup; Applying Medicaid rate setting methodologies and processes; Auditing managed Medicaid financial healthcare data including income statement, balance sheet, claims, and incurred but not reported calculations; Analyzing large Medicaid claims and capitation data sets using advanced programs including SAS, R, and Qlik Sense; Reviewing and analyzing cost report data of Medicaid-specific provider groups.

#Li-Dni

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, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting reasonableaccommodations@mmc.com.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.