Medicaid Data Analyst - Management Analyst 4

Minnesota Direct Care and Treatment; Saint-Paul; Hybrid; CAD 66,000 - 97,000; Full time

Job summary

The Minnesota Department of Human Services is seeking a Medicaid Data Analyst to perform queries, analyze data, and ensure accurate quarterly Medicaid reporting. The role emphasizes SQL development, Power BI dashboards, and data integrity for federal reporting.

Ideal candidates have a minimum of three years in data analysis and a background in GAAP/SWIFT systems. Telework eligible up to 50% with typical day shift hours, Monday to Friday.

Qualifications

• Three (3) years of experience in data analysis.
• Experience writing SQL queries and developing dashboards using Power BI.
• Experience extracting data from data warehouses using SAS or SQL.
• Knowledge of GAAP and SWIFT or similar electronic accounting system.
• A Bachelor’s degree may substitute for one year of experience.
• A Master’s degree may substitute for two years of experience.

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

SQL

Data analysis

Dashboard creation

Education

Bachelor's degree

Master's degree

Tools

Power BI

SAS/SQL

SWIFT

Job description

• 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: Yes

Working Title: Medicaid Data Analyst

Job Class: Management Analyst 4

Agency: Human Services Dept

• 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: 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 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.

About Human Services Dept

WE MAKE A DIFFERENCE! The Minnesota Department of Human Services impacts the lives of 1.7 million people every year, helping them meet their basic needs so they can achieve their highest potential.

Working together to improve the state we love.

What do Minnesota's State employees have in common?

• A sense of purpose in their work
• Connection with their coworkers and communities
• Opportunities for personal and professional growth

Benefits

As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.

Your Benefits May Include

• 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 to provide support for your family in the event of death
• Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
• Tax-free expense accounts for health, dental, and dependent care
• Resources that provide support and promote physical, emotional, social, and financial well-being

Support To Help You Reach Your Career Goals

• Training, classes, and professional development
• Tuition reimbursement
• Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)

Employee Assistance Program (EAP) For Work/life Support

• A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.

EQUAL OPPORTUNITY EMPLOYERS

Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans.

All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.

Applicants With Disabilities

Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email [e-mail] and let us know the support you need.