Remote Medicaid Data Analyst for Public Health Analytics

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

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.