Eligibility and Enrollment 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

If you are a current State of Maine employee, please submit your application through the internal application process using the Find Jobs report in PRISM. Seasonal employees who do not have PRISM access should apply through the State's career page and indicate on the application that they have previously worked for the State.

Department of Health and Human Services (DHHS)

Public Service Coordinator I

Opening Date: September 3, 2026

Closing Date: September 17, 2026

Job Class Code: CA26

Grade: 26 (Confidential)

Salary: $64,916.80 - $91,769.60 per year

Position Number: 20002-5211

Location: Augusta

Currently, this position is not eligible for visa sponsorship or STEM OPT extensions.

Job Description:

The Eligibility and Enrollment Analyst provides key information obtained through data analysis related to eligibility and enrollment trends and associated programmatic impacts. This position will create fiscal impact analyses related to future state and federal legislation impacting MaineCare member enrollment and will assist in creating and applying per member per month (PMPM) cost analysis. This position will research and incorporate the impact of broader economic trends into enrollment forecasting.

As an Eligibility and Enrollment Analyst, you will:

• Create MaineCare member enrollment reports.
• Coordinate with the Office for Family Independence (OFI) to gather and analyze eligibility and enrollment data and share relevant Office of MaineCare Services (OMS) data back to OFI.
• Create analytical datasets by integrating multiple raw data sources from both OMS and OFI using a variety of programming languages and data management tools.
• Validate and maintain data integrity within MaineCare's data warehouses, decision support and claims processing systems.
• Prepare reports, data visualizations, analyses, and forecasts to support clinical, operational, and budgetary initiatives.
• Present analyses and recommendations to the MaineCare senior management team, OFI, or other units within the Department.
• Work individually and as part of multi-disciplinary teams on projects varying in size and scope from short-term ad-hoc requests to long-term strategic initiatives while collaborating with other OMS units and DHHS offices.
• Develop fiscal impact analyses for Legislative bills and for Department budget initiatives.

Minimum Qualifications:

In order to qualify for this position, you must have a six (6) year combination of education and/or experience that includes a bachelor's Degree in Data Analytics, Statistics, Economics, Business Administration, or a closely related field -AND- two (2) years of responsible experience in data analysis, accounting, and/or financial analysis. Directly related professional experience may be substituted for education on a year-for-year basis. Prior experience in analyzing Medicaid program or financial data is preferred.

Preferred experience includes:

• Experience with and knowledge of the Medicaid program and/or other health and human services programs serving low-income populations
• Lived experience with Medicaid and/or other health-related social needs common to individuals and families receiving Medicaid coverage

The background of well-qualified candidates will demonstrate the following competencies:

1. Prior experience in analyzing program details and eligibility/enrollment for Medicaid or other social service programs.
2. The ability to accurately interpret, apply, and communicate the impact of changes to both state and federal regulations.
3. Advanced technical skills in the use of programming tools such as SQL and spreadsheets (e.g., pivot tables, functions, macros/Visual Basic script, etc.), along with database query/reporting methodologies and statistical analysis skill sets.
4. Familiarity with public administration and financial management processes, practices, and techniques.
5. The ability to communicate effectively, whether orally, in writing, or through the use of data visualizations.

Agency information:

The Department of Health and Human Services (DHHS) is dedicated to promoting health, safety, resilience, and opportunity for Maine people. The Department provides health and social services to approximately a third of the State's population, including children, families, older Mainers, and individuals with disabilities, mental illness, and substance use disorders. The Department also promotes public health, operates two state psychiatric hospitals, and provides oversight to health care providers.

The Office of MaineCare Services (OMS) within DHHS administers the state's Medicaid program, which provides free or low-cost health insurance coverage