Reporting Analyst

State of Maine; Maine; On-site; USD 46,000 - 64,000; Full time

Benefits offered by this job

Health Insurance

Paid holidays

Vacation leave

Job summary

The State of Maine is seeking a Management Analyst I in Augusta to track and complete data requests for the Office of MaineCare Services and other agencies. The role requires attention to detail, basic SQL, and strong organizational skills.

Responsibilities include producing PREP reports, large data pulls for program integrity and legal offices, and backing up data request processing. This position emphasizes HIPAA compliance and efficient reporting.

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.

Responsibilities

• Track and complete data requests for the Office of MaineCare Services and other agencies.
• Pull and compile claims data for PREP reports for OCFS.
• Perform large data pulls for Program Integrity and Attorney General's office to identify fraud.
• Prepare reports for Maine hospitals by compiling claims data for specified periods.
• Back up for processing and responding to incoming data requests.
• Back up for entering Change Requests (CRs) in RQMS and related extracts.

Skills

Excel pivot tables

SQL basics

Attention to detail

Communication skills

Organization & prioritization

Education

Six years of education/experience

Tools

SQL

Legacy MECMS

MIHMS Data Analytics Platform

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)
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: 02000-2659
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 MaineCare Services and other agencies.

1. 1. Complete at least 90% of urgent ad hoc data requests within 4 business days and non-urgent requests within 8 business days.
2. 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. 3. Do large data pulls for Program Integrity and the Attorney General's office to assist with identifying fraud.
4. 4. Complete reports for each of the Maine hospitals by pulling and compiling all of the available claims data for specified time periods.
5. 5. Complete additional reoccurring requests as assigned.
6. 6. Act as backup for processing and responding to incoming data requests.
7. 7. Contact requestors to clarify requests whenever necessary.
8. 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. 9. Use SQL to pull data from the Legacy Database (MECMS/legacy claims) and Data Analytics Platform (MIHMS/current system claims) if needed.
10. 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. 1. Proficiency in using Microsoft Excel including pivot tables.
2. 2. Demonstrated ability to learn and use new reporting systems. Basic SQL skills preferred.
3. 3. Attention to detail.
4. 4. Ability to communicate well one on one, in meetings and in writing.
5. 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. 1. Describe your familiarity with the Medicaid program and your experience working with Medicaid or other healthcare claims data.
2. 2. What tools have you used to perform analysis and/or reporting needs?
3. 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 MaineCare 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 agencies, the Legislature, the Office of the Governor, MaineCare members, health care providers, and other health care purchasers on statewide healthcare improvement initiatives. OMS is committed to advancing health equity efforts to improve access to care and positive health outcomes for all low-income Mainers. OMS provides benefit coverage and support services in alignment with Department goals, federal requirements, and State statutes. OMS also provides oversight necessary to ensure accountability and efficient and effective administration of the state's Medicaid program.

The Reporting and Data Management Unit is located within the Data Analytics Division. This team is responsible for oversight of the Decision Support System (DSS) reporting tool, tracking and producing reports and extracts used by others at OMS as well as other offices within DHHS, Centers for Medicare and Medicaid Services and external partners.

Application Information:

For additional information about this position please contact Kristen Cowing at 207-624-4033.

Please submit all documents or files in PDF or Word format.

To request a paper application, please contact [e-mail]

Benefits of working for the State of Maine:

No matter where you work across Maine state government, you find employees who embody our state motto-"Dirigo" or "I lead"-as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including:

• Work-Life Fit - Rest is essential. Take time for yourself using 13 paid holidays and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave. When you or immediate members of your family are ill, utilize 12 days of sick leave per year.
• Health Insurance Coverage - The State of Maine pays 85%-95% of employee-only premiums ($12,213.60 - $13,650.48 annual value), depending on salary. Use this chart to find the premium costsfor you and your family, including the percentage of dependent coverage paid by the State.
• Health Insurance Premium Credit - Participation decreases employee-only premiums by 5%. Visit the Office of Employee Health and Wellness for more information about program requirements.
• Dental Insurance - The State of Maine pays 100% of employee-only dental premiums ($365.28 annual value).
• Retirement Plan - The State contributes the equivalent of 14.06% of the employee's pay towards the Maine Public Employees Retirement System (MainePERS), on behalf of the employee.
• Gym Membership Reimbursement - Improve overall health with regular exercise and receive up to $40 per month to offset this expense.
• Health and Dependent Care Flexible Spending Accounts - Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
• Public Service Student Loan Forgiveness - The State of Maine is a qualified employer for this federal program. For more information, visit the Federal Student Aid office.
• Living Resources Program - Navigate challenging work and life situations with our employee assistance program.
• Parental leave is one of the most important benefits for any working parent. All employees who are welcoming a child-including non-birthing and adoptive parents-receive six weeks of fully paid parental leave. Additional, unpaid leave may also be available, under the Family and Medical Leave Act.
• Voluntary Deferred Compensation - Save additional pre-tax funds for retirement in a MaineSaves 457(b) account through payroll deductions.

State employees are eligible for an extensive and highly competitive benefits package, covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness.

Note: Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for anything less than full-time.

There's a job and then there's purposeful, transformative work. Our aim is to create a workplace where you can learn, grow, and continuously refine your skills. Applicants demonstrate job requirements in differing ways, and we appreciate that many skills and backgrounds can make people successful in this role.

As an Equal Opportunity employer, Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members, and our process ensures an inclusive environment to applicants of all backgrounds including diverse race, color, sex, sexual orientation or gender identity, physical or mental disability, religion, age, ancestry, national origin, familial status or genetics.

If you're looking for a great next step, and want to feel good about what you do, we'd love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.

If you are unable to complete the online application, please contact the Human Resources representative listed on the job opening you are interested in applying for. They will work with you for an alternative method of submitting.