Senior Government Healthcare Financial Consultant – Reporting and Monitoring
Senior Government Healthcare Financial Consultant – Reporting and Monitoring
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Company:
MercerDescription:
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 Bachelors 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 Masters 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 Masters) 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 90000 colleagues Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information visit 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 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.Required Experience:
Senior IC
Employment Type
Full-Time
