Data Analyst

Location: Augusta,Maine,United States

Department of Health and Human Services (DHHS)

Management Analyst I

Opening Date: May 7, 2024 

Closing Date: May 21, 2024

Job Class Code: 0392
Grade:  21
Salary: $20.91- $28.14/hourly

Position Number: 02000-4100

Location: Augusta

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 Analytics team is located within a broader OMS Data Analytics unit. The Analytics team supports OMS and broader DHHS operations, initiatives, and decision-making through the analysis of financial and healthcare data.

Core Responsibilities:

As a member of the Analytics team, the MaineCare Health Data Analyst performs analysis and runs reports vital to the delivery and quality of MaineCare services provided to MaineCare. The reports generated by this position support MaineCare initiatives related to delivery system reform, value-based purchasing, and quality measurement. Additionally, the selected candidate will have the opportunity to further develop and apply SQL and visualization skills to advance their role and impact within the Office of MaineCare Services.  
•    Update and run recurring reports (weekly, monthly, quarterly and annually) to support value-based purchasing initiatives, quality measurement, and provider reimbursement. 
•    Provide quality assurance checks on final deliverables and data sets used to generate reports. 
•    Support other analysts on the team by gathering development requirements for new and existing SQL queries and reports. 
•    Maintain documentation for processes of running and altering existing recurring reports. 
•    Summarize results of analysis in Microsoft Excel and present in a format that clearly communicates results. 
•    Analyze and interpret large datasets related to programs and healthcare claims data.
•    Generate data visualizations to better help our audience understand the story being told through the data. 

Minimum Qualifications:

In order to qualify for this position, you must have 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. A demonstrated ability to use at least one programming and/or querying language.
2. Advanced technical skills in the use of spreadsheets (e.g. pivot tables, functions, etc)
3. A history of working with datasets to generate data reports.
4. Proven ability to document processes used to generate reports/products. 
5. A strong analytical background with ability to digest and interpret large data sets and    effectively communicate results to a non-technical audience. 

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 lived experience and passion set you apart.

Application Information:

 Please submit all documents or files in  PDF format.

For questions, please contact Corey Ballew at 207-624-6941

To request a paper application, please contact Ashley.Smith@Maine.gov .

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, 12 days of sick leave, and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.
• Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($10,523.28-$12,380.40 annual value), depending on salary. Use this chart to find the premium costs for you and your family, including the percentage of dependent coverage paid by the State. 
• Dental Insurance – The State of Maine pays 100% of employee-only dental premiums ($350.40 annual value).
• Retirement Plan – The State contributes the equivalent of 13.41% of the employee's pay towards the Maine Public Employees Retirement System (MainePERS). 

• Parental leave is one of the most important benefits for any working parent. All employees who are welcoming a child—including fathers 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.

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 part-time employment.

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.