Reporting Analyst Job Bangor area,Maine USA,Business

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)
Management Analyst I
Opening Date:
September 1, 2026
Closing Date:
September 15, 2026
Job Class Code: 0392
Grade: 21 (Pro/Tech)
Salary: $22.08 - $30.89 per hour
* * This is inclusive of a 2.50% recruitment and retention stipend
Position Number:

Location:

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

Core Responsibilities:

The person in this position is responsible for tracking and completing data requests for the Office of Maine Care Services and other agencies.

1. Complete at least 90% of urgent ad hoc data requests within 4 business days and non-urgent requests within 8 business days.

2. Complete Pediatric Rapid Evaluation Program (PREP) reports for the Case Workers at the Office of Children and Family Services (OCFS) by pulling and compiling all available claims data for the requested children.

3. Do large data pulls for Program Integrity and the Attorney General's office to assist with identifying fraud.

4. Complete reports for each of the Maine hospitals by pulling and compiling all of the available claims data for specified time periods.

5. Complete additional reoccurring requests as assigned.

6. Act as backup for processing and responding to incoming data requests.

7. Contact requestors to clarify requests whenever necessary.

8. Act as backup for entering Change Requests (CRs) in the RQMS tool for DSS/DW data enhancements and reports, T-MSIS & other extracts.

9. Use SQL to pull data from the Legacy Database (MECMS/legacy claims) and Data Analytics Platform (MIHMS/current system claims) if needed.

10. Follow HIPAA protocols whenever sharing Protected Health Information (PHI).

Minimum Qualifications:

Six (6) years of education, training, and/or experience analyzing, evaluating, and/or developing improvements to organizational and/or managerial systems, programs, and practices.

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. Proficiency in using Microsoft Excel including pivot tables.

2. Demonstrated ability to learn and use new reporting systems. Basic SQL skills preferred.

3. Attention to detail.

4. Ability to communicate well one on one, in meetings and in writing.

5. Good organizational skills and the ability to prioritize and switch between multiple tasks.

Applicants should include a cover letter that answers the following questions:

1. Describe your familiarity with the Medicaid program and your experience working with Medicaid or other healthcare claims data.

2. What tools have you used to perform analysis and/or reporting needs?

3. Describe your experience with learning a new system and any challenges you experienced.

Thinking about applying?

Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If you're currently reading this and hesitating to apply for that reason, we encourage you to go for it! Let us know how your experience and passion set you apart.

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 Maine Care Services (OMS) within DHHS administers the state's Medicaid program, which provides free or low-cost health insurance coverage for low-income Mainers so they can access the health care services they need to work, care for family, go to school, and participate in the community. OMS works collaboratively with other State…