Medicaid Data Analyst - Management Analyst 4
- Saint-Paul, NB, Canada
- St.-Paul, NB, Canada
Salary Range: $34.07 - $50.53 / hourly; $71,138 - $105,506 / annually · Full-time
Applications open in a new tab.
Job details
- Pay
- Salary Range: $34.07 - $50.53 / hourly; $71,138 - $105,506 / annually
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
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: Yes
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.***
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.
- 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.**
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.
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.
REFERENCE/BACKGROUND CHECKS – DHS will conduct reference checks to verify job-related credentials and a criminal background check prior to appointment.
How To Apply
Select “Apply for Job” at the top of this page. If you have questions about applying for jobs, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us. For additional information about the application process, go to http://www.mn.gov/careers.
Contact
If you have questions about this position, contact Rebecca Path at Rebecca.Path@state.mn.us.
To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to Alexander Duren at alexander.duren@state.mn.us.
If you are an individual with a disability and need an ADA accommodation for an interview, you may contact the Department of Human Services’ ADA Coordinator at 651-431-4945 or DHS_ADA@state.mn.us for assistance.
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
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
- 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)
- 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
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 careers@state.mn.us and let us know the support you need.
More about this job
Responsibilities
Prepare and manage data for federal Medicaid reporting and project-specific requirements, including querying and analyzing data related to Medicaid claims financing changes. Maintain fiscal data integrity by querying the data warehouse to verify post-production funding code and claim changes, and ensure quarterly reporting is accurate and timely.
Requirements
Applicants need three years of data analysis experience, including SQL querying, Power BI reporting and dashboards, data extraction and validation, and use of Excel and SAS or SQL with data warehouses. A relevant bachelor's degree may substitute for one year of experience, or a relevant master's degree may substitute for two years; knowledge of GAAP and an electronic accounting system such as SWIFT is also required.
Skills
- Data Analysis
- SQL
- Microsoft Power BI
- Dashboard Development
- Report Development
- Data Extraction
- Data Validation
- Data Interpretation
- Microsoft Excel
- SAS
- Data Warehousing
- Data Integrity
- Financial Reporting
- Auditing
- Generally Accepted Accounting Principles
- Relational Database Modeling
Benefits
- Paid Vacation Leave
- Paid Sick Leave
- Paid Holidays
- Medical Insurance
- Dental Insurance
- Vision Insurance
- Prescription Drug Coverage
- Paid Parental Leave
- Pension Plan
- Life Insurance
- Short-Term Disability Insurance
- Long-Term Disability Insurance
- Tax-Free Expense Accounts
- Professional Development
- Tuition Reimbursement
- Public Service Loan Forgiveness Program
- Employee Assistance Program
Visa sponsorship
Not detected in the job text
Hiring contact
Rebecca Path
Hiring contact email
Rebecca.Path@state.mn.us
Categories
- Data & Analytics
- Government & Public Sector
- Finance & Accounting
- Healthcare
- Social Services
Keywords
- Medicaid
- Federal Reporting
- Medicaid Claims
- Claims Financing
- SQL
- Microsoft Power BI
- Microsoft Excel
- SAS
- Data Warehousing
- Data Analysis
- Data Extraction
- Data Validation
- Data Integrity
- Dashboards
- Business Intelligence
- Financial Reporting
- Auditing
- Generally Accepted Accounting Principles
- SWIFT
- MMIS
- MAXIS
- METS
- SSIS
- Relational Databases
- Data Modeling
- Public Assistance Programs
- Health Care Programs