Reporting Analyst

Department of Health and Human Services • Augusta, GA

21h • Onsite

About The Position

This position is responsible for tracking and completing data requests for the Office of MaineCare Services and other agencies. Duties include completing urgent and non-urgent ad hoc data requests, generating reports for various programs and entities, performing large data pulls for fraud identification, and acting as backup for processing data requests and entering Change Requests (CRs) in the RQMS tool. The role requires using SQL to pull data from databases and adhering to HIPAA protocols when handling Protected Health Information (PHI).

Requirements

• Six (6) years of education, training, and/or experience analyzing, evaluating, and/or developing improvements to organizational and/or managerial systems, programs, and practices.
• Proficiency in using Microsoft Excel including pivot tables.
• Demonstrated ability to learn and use new reporting systems.
• 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.

Nice To Haves

• 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
• Basic SQL skills

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 Case Workers at the Office of Children and Family Services (OCFS) by pulling and compiling all available claims data for the requested children.
• Perform 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 of the available claims data for specified time periods.
• Complete additional reoccurring 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 & 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).

Benefits

• 13 paid holidays
• 12 days of sick leave
• 3+ weeks of vacation leave annually
• Health Insurance Coverage (State pays 85%-100% of employee-only premiums)
• Health Insurance Premium Credit (Participation decreases employee-only premiums by 5%)
• Dental Insurance (State pays 100% of employee-only dental premiums)
• Retirement Plan (State contributes 14.11% of employee's pay towards MainePERS)
• Six weeks of fully paid parental leave for all employees welcoming a child
• Additional, unpaid leave may also be available under the Family and Medical Leave Act.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED