Reporting Analyst

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. Job Title: Management Analyst I Department: Department of Health and Human Services (DHHS) Location: Augusta Opening Date: July 16, 2026 Closing Date: July 29, 2026 Job Class Code: 0392 Grade: 21 (Pro/Tech) Salary: $22.08 - $30.89 per hour (inclusive of a 2.50% recruitment and retention stipend) This position is not eligible for visa sponsorship or STEM OPT extensions. Core Responsibilities Complete at least 90% of urgent ad hoc data requests within 4 business days and non‑urgent requests within 8 business days. Complete Pediatric Rapid Evaluation Program (PREP) reports for the Office of Children and Family Services (OCFS) by pulling and compiling all available claims data for requested children. Do large data pulls for Program Integrity and the Attorney General’s office to assist with identifying fraud. Complete reports for each of the Maine hospitals by pulling and compiling all available claims data for specified time periods. Complete additional recurring requests as assigned. Act as backup for processing and responding to incoming data requests. Contact requestors to clarify requests whenever necessary. Act as backup for entering Change Requests (CRs) in the RQMS tool for DSS/DW data enhancements and reports, T‑MSIS and other extracts. Use SQL to pull data from the Legacy Database (MECMS/legacy claims) and Data Analytics Platform (MIHMS/current system claims) if needed. 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 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. Competencies Proficiency in using Microsoft Excel including pivot tables. Demonstrated ability to learn and use new reporting systems. Basic SQL skills preferred. Attention to detail. Ability to communicate well one on one, in meetings, and in writing. Good organizational skills and the ability to prioritize and switch between multiple tasks. Application Instructions Applicants should include a cover letter that answers the following questions: Describe your familiarity with the Medicaid program and your experience working with Medicaid or other healthcare claims data. What tools have you used to perform analysis and/or reporting needs? Describe your experience with learning a new system and any challenges you experienced. Contact Information For additional information about this position please contact Kristen Cowing at View phone number on click.appcast.io. Benefits Rest is essential. Take time using 13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually. Health Insurance Coverage – The State pays 85–100% of employee‑only premiums ($12,845.82–$15,112.76 annual value) depending on salary. Dental Insurance – The State pays 100% of employee‑only dental premiums ($395.72 annual value). Retirement Plan – The State contributes the equivalent of 14.11% of the employee’s pay towards Maine Public Employees Retirement System (MainePERS). Parental leave – Six weeks of fully paid parental leave for all employees welcoming a child. Other unpaid leave may be available under Family and Medical Leave Act. Equal Opportunity Employer Maine State Government is an equal opportunity employer. We have a culture of respect and awareness and ensure an inclusive environment for 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. Reasonable accommodations are provided to qualified individuals with disabilities upon request. #J-18808-Ljbffr