Medicaid Eligibility & Enrollment Analytics Analyst

maine; Augusta (ME); On-site; USD 65,000 - 92,000; Full time

Job summary

The Department of Health and Human Services (DHHS) in Maine seeks a Public Service Coordinator I in Augusta to analyze eligibility and enrollment trends for MaineCare, forecast impacts of legislation, and support budgeting with PMPM analyses.

Responsibilities include building enrollment reports, collaborating with OFI, combining data sources in SQL and spreadsheets, presenting findings to senior management, and contributing to short- and long-term strategic initiatives.

Qualifications

• Bachelor's degree in data analytics, statistics, economics, business administration, or closely related field and two years of responsible data analysis or financial analysis experience.
• Directly related professional experience may substitute education on a year-for-year basis.
• Prior experience analyzing Medicaid or health program data is preferred.

Responsibilities

• Create MaineCare member enrollment reports and forecasts.
• Coordinate with OFI to gather and analyze eligibility data and share OMS data back to OFI.
• Build analytical datasets by integrating data sources from OMS and OFI using SQL and spreadsheets.
• Validate and maintain data integrity within MaineCare data warehouses and reporting systems.
• Prepare reports, visualizations, analyses, and forecasts for clinical, operations, and budget initiatives.
• Present analyses and recommendations to MaineCare senior management and other units.

Skills

Data analysis

SQL

Excel

Reporting

Education

Bachelor's degree in Data Analytics, Statistics, Economics, Business Administration, or related field

Tools

SQL

Job description

The Department of Health and Human Services (DHHS) in Maine seeks a Public Service Coordinator I in Augusta to analyze eligibility and enrollment trends for MaineCare, forecast impacts of legislation, and support budgeting with PMPM analyses.

Responsibilities include building enrollment reports, collaborating with OFI, combining data sources in SQL and spreadsheets, presenting findings to senior management, and contributing to short- and long-term strategic initiatives.