Medicaid Data Analyst - Management Analyst 4

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

Job summary

State of Minnesota, Department of Human Services in St. Paul, seeks a Medicaid Data Analyst to perform queries and data analysis to ensure quarterly Medicaid reporting is accurate and timely.

The candidate will develop and maintain BI dashboards, validate data, and support compliance with GAAP and SWIFT standards. Key responsibilities include data preparation, federal reporting, and maintaining data integrity across warehouses.

Qualifications

• Three (3) years of experience in data analysis.
• Writing SQL queries and developing reports and dashboards using Microsoft Power BI.
• Experience collecting, validating, analyzing, and interpreting data to identify trends, resolve data discrepancies, and support business operations and decision-making.
• Experience using 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 in a variety of applications.
• Experience providing data and other information for auditing purposes.
• Creating dashboards, reports, and other methods of synthesizing analytic results.
• Knowledge of GAAP and SWIFT or similar electronic accounting system.

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 through data warehouse queries of post-production funding code and claim changes.

Skills

Data analysis

SQL queries

Power BI

Excel

Reporting and dashboards

Auditing data

Education

Bachelor's degree or higher in a relevant field

Master's degree may substitute for two years of experience

Tools

Power BI

SAS

SQL

SWIFT

Job description

Working Title: Medicaid Data Analyst

Job Class: Management Analyst 4

Agency: Human Services Dept

• Job ID : 98213

• Location : St. Paul

• Telework Eligible : Yes (up to 50% of the time, if eligible)

• Full/Part Time : Full-Time

• Regular/Temporary : Unlimited

• Who May Apply : Open to all qualified job seekers

• Date Posted : 11/04/2026

• Closing Date : 11/17/2026

• Hiring Agency/Seniority Unit : Human Services Dept / MAPE DHS Central Office

• Division/Unit : DHS-Central Office / FOD Social Services

• Work Shift/Work Hours : Day Shift, 8:00am - 4:30pm

• Days of Work : Monday - Friday

• Travel Required : No

• Salary Range: $34.07 - $50.53 / hourly; $71,138 - $105,506 / annually

• Classified Status : Classified

• Bargaining Unit/Union : 214 - MN Assoc of Professional Empl/MAPE

• FLSA Status : Nonexempt

• Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : Yes

The Department of Human Services is unable to provide sponsorship for work visas. Applicants must be eligible to work in the United States at the start of employment. DHS does not participate in E-Verify.

The work you'll do is more than just a job.

At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities.

***This position is eligible for telework (https://mn.gov/mmb-stat/policies/1422-telework.pdf) for applicants who reside in Minnesota or in a bordering state, with supervisory approval and satisfactory performance. If you live in a state bordering Minnesota, you must live within 50 miles or less from the primary work location to be eligible for telework.***

As a Medicaid Data Analyst, the incumbent will perform queries and data analysis to ensure that quarterly Medicaid reporting is completed accurately and timely.

Responsibilities include but may not be limited to:

• 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 through data warehouse queries of post-production funding code and claim changes.

Minimum Qualifications

_To facilitate proper crediting, please ensure that your resume clearly describes your experience in the areas listed and indicates the beginning and ending month, day and year for each job held._

Three (3) years of experience in data analysis.

Experience must also demonstrate:

• Writing SQL queries and developing reports and dashboards using Microsoft Power BI, including:

• Experience developing, maintaining, or supporting reports, data extracts, dashboards, or other business intelligence tools.

• Experience collecting, validating, analyzing, and interpreting data to identify trends, resolve data discrepancies, and support business operations and decision-making.

• Experience using 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 in a variety of applications.

• Experience providing data and other information for auditing purposes.

• Creating dashboards, reports, and other methods of synthesizing analytic results.

• Knowledge of Generally Accepted Accounting Principles (GAAP) and State Wide Integrated Financial Tools (SWIFT) or similar electronic accounting system.

*** A Bachelor’s degree in social science, data science, analytics, research, public administration, accounting, finance or related field may substitute for one (1) year of experience.***

OR

*** A Master’s degree in social science, data science, analytics, research, public administration, accounting, finance or related field may substitute for two (2) years of experience.***

Preferred Qualifications

• Experience extracting data from the DHS Data Warehouse.

• Knowledge of the MMIS/MAXIS/METS/SSIS data system (or similar eligibility system for public assistance and health care), data structure, data relationships, and processes.

• Understanding and experience in federal financial reporting.

• Knowledge and experience in the Minnesota Government Data Practices Act (MGDPA).

• Experience in designing, administering, and troubleshooting data models in a relational database system.

• Knowledge of state and federal assistance programs and resulting data systems especially MMIS.

• Demonstrated understanding of the roles and inter-relationships of local, state, federal, and community agencies in the administration of public programs.

• Variety of experiences working effectively with others from different backgrounds and cultures.

Additional Requirements

REFERENCE/BACKGROUND CHECKS – DHS will conduct reference checks to verify job-related credentials and a criminal background check prior to appointment.

AN EQUAL OPPORTUNITY EMPLOYER

Minnesota State Colleges and Universities is an Equal Opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.

Reasonable accommodations will be made to all qualified applicants with disabilities. If you are an individual with a disability who needs assistance or cannot access the online job application system, please contact the job information line at 651-259-3637 or email [e-mail] . Please indicate what assistance is needed.