Hybrid Medicaid Data Analyst | SQL & Power BI

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

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.