Medicaid Data Analyst

State of Minnesota - Human Services Dept; Saint Paul (MN); Hybrid; USD 47,000 - 70,000; Full time

Benefits offered by this job

Paid vacation and sick leave

12 paid holidays every year

Low-cost medical, dental, vision plans

Pension plan

Job summary

The State of Minnesota - Human Services Department seeks a Medicaid Data Analyst to prepare and analyze data for accurate quarterly reporting, supporting federal Medicaid needs, and validating fiscal data in data warehouse systems.

You will query data, develop dashboards, and ensure data integrity for post-production funding and claim changes, with hybrid telework up to 50% when eligible and approved.

Qualifications

• Three (3) years of experience in data analysis.
• Ability to write SQL queries and develop reports and dashboards using Microsoft Power BI, including experience developing, maintaining, or supporting reports, data extracts, dashboards, or similar business intelligence tools.
• Experience collecting, validating, analyzing, and interpreting data to identify trends, resolve data discrepancies, and support business operations and decision-making.
• Experience with Microsoft Excel and other reporting or data analysis tools to organize, reconcile, maintain, and present data for business users and management.
• Experience extracting data from data warehousing using SAS or SQL across different applications.
• Experience providing data and other information for auditing purposes.
• Ability to create dashboards, reports, and other methods to synthesize analytic results.
• Knowledge of GAAP and SWIFT or a similar electronic accounting system.
• Education substitutions: a Bachelor’s degree may substitute for one (1) year of experience; a Master’s degree may substitute for two (2) years of experience (in relevant fields).

Responsibilities

• Oversee data preparation and information management to support federal Medicaid reporting and project-specific requirements.
• Query and analyze data for federal reporting related to Medicaid claims financing changes.
• Ensure fiscal data integrity using data warehouse queries, focusing on post-production funding code and claim changes.

Skills

SQL queries

Data analysis

Reports & dashboards

Microsoft Power BI

Excel

GAAP

SWIFT

Education

Bachelor's degree

Master's degree

Tools

SAS

Power BI

Microsoft Excel

Job description

Make an impact on accurate Medicaid reporting with the State of Minnesota, Human Services Department. This role supports timely quarterly Medicaid submissions through data queries, analysis, and fiscal data integrity checks, with hybrid telework up to 50% when eligible and approved.

What you’ll do

The Medicaid Data Analyst performs data preparation and analysis to help ensure Medicaid reporting is completed accurately and on time. You will support federal Medicaid reporting needs and project-specific requirements by preparing information, validating fiscal data, and extracting results from data warehouse systems.

• Oversee data preparation and information management to support federal Medicaid reporting and project-specific requirements.
• Query and analyze data for federal reporting related to Medicaid claims financing changes.
• Ensure fiscal data integrity using data warehouse queries, focusing on post-production funding code and claim changes.

Core qualifications

• Three (3) years of experience in data analysis.
• Ability to write SQL queries and develop reports and dashboards using Microsoft Power BI, including experience developing, maintaining, or supporting reports, data extracts, dashboards, or similar business intelligence tools.
• Experience collecting, validating, analyzing, and interpreting data to identify trends, resolve data discrepancies, and support business operations and decision‑making.
• Experience with Microsoft Excel and other reporting or data analysis tools to organize, reconcile, maintain, and present data for business users and management.
• Experience extracting data from data warehousing using SAS or SQL across different applications.
• Experience providing data and other information for auditing purposes.
• Ability to create dashboards, reports, and other methods to synthesize analytic results.
• Knowledge of GAAP and SWIFT or a similar electronic accounting system.
• Education substitutions: a Bachelor’s degree may substitute for one (1) year of experience; a Master’s degree may substitute for two (2) years of experience (in relevant fields).

Tools and systems

You will work with SQL, Microsoft Power BI, Microsoft Excel, SAS, GAAP, and SWIFT.

Work details

• Location: Saint Paul, MN (hybrid)
• Telework eligible: Yes (up to 50% of the time, if eligible)
• Schedule: Day shift, Monday to Friday, 8:00am - 4:30pm
• Full-time, Regular/Temporary: Unlimited
• Class: Management Analyst 4
• Job ID: 98213
• Compensation: $34.07 - $50.53 hourly ($71,138 - $105,506 annually)
• Travel: No
• Classified status: Classified; Union: 214 (MAPE)
• FLSA: Nonexempt
• Connect 700 program (Applicants with Disabilities): Yes

Benefits

• Paid vacation and sick leave; 12 paid holidays each year
• Low-cost medical, dental, vision, and prescription drug plans
• Fertility care including IVF; diabetes care
• Dental and orthodontic care for adults and children
• 6 weeks paid leave for parents of newborn or newly adopted children
• Pension plan that provides income when you retire (after working at least three years)
• Employer paid life insurance
• Short‑term and long‑term disability insurance
• Tax‑free expense accounts for health, dental, and dependent care
• Resources supporting physical, emotional, social, and financial well‑being
• Training, classes, professional development, and tuition reimbursement
• Federal Public Service Loan Forgiveness Program (some positions may qualify)
• Employee Assistance Program (EAP) for work/life support
• Eligibility for programs and benefits varies by employment type, agency, funding availability, union/collective bargaining agreement, location, and length of service

Additional information

This position performs reference checks to verify job‑related credentials and requires a criminal background check prior to appointment.

Telework note: Eligibility requires the applicant to reside in Minnesota or a bordering state, with supervisory approval and satisfactory performance. Applicants living in a bordering state must live within 50 miles or less of the primary work location.

Application

• Select “Apply for Job” at the top of the page.
• For application process details, visit http://www.mn.gov/careers.
• Questions about applying: 651-259-3637 or [e-mail].
• Position questions: Rebecca Path at [e-mail].

For Connect 700 Program applicants, apply online and email the Job ID, Working Title, and valid Proof of Eligibility Certificate by the closing date to Alexander Duren at [e-mail]. ADA accommodation requests for interviews can be directed to the DHS ADA Coordinator at 651-431-4945 or [e-mail].