Principal Data Analyst

Apex Systems; Minneapolis (MN); Remote; USD 68,880 - 73,012; Full time

Job summary

A leading tech consulting firm seeks a Principal Data Analyst to serve as a Medicaid Subject Matter Expert for a remote role. This position entails providing strategic guidance for a Medicaid data warehouse project, requiring deep experience in Medicaid programs and data analysis. Candidates should have over 10 years of IT experience with at least 5 years in Medicaid agencies, proficiency in SQL, and strong communication skills. The role offers competitive pay working with healthcare data projects.

Qualifications

• 10+ years of IT experience, including 5+ years with State Medicaid agencies.
• Strong knowledge of Medicaid programs, claims, and eligibility processes.
• Proficiency in SQL and Excel for large dataset analysis.

Responsibilities

• Guide recommendations for Medicaid data warehouse operations.
• Lead stakeholders on claims adjudication and eligibility determinations.
• Support development of dashboards and decision-support tools.

Skills

Medicaid SME experience

SQL and data analysis

CMS reporting knowledge

Tools

Teradata

Job description

Job Title

Principal Data Analyst

Location

IL950 – 100% Remote (Telecommute)

Pay Range

$50.00/hr - $53.00/hr

Role Overview

The Principal Data Analyst will serve as a Medicaid Subject Matter Expert (SME) for the Illinois Enterprise Data Warehouse (EDW) project. This role provides strategic guidance and direction for a large‑scale Medicaid data warehouse implementation and ongoing operations. The ideal candidate will leverage deep expertise in Medicaid programs, claims processing, eligibility, and provider data to support decision‑making and ensure compliance with CMS standards.

Key Responsibilities

• Provide direction and recommendations for Medicaid data warehouse implementation and operations.
• Lead internal and external stakeholders in making determinations on complex processes involving claims adjudication, eligibility, and third‑party liability.
• Identify state Medicaid agency data needs and propose validated solutions with supporting proof of concepts.
• Guide technical and business teams on health‑care data utilization and best practices.
• Recommend enhancements and improvements based on Medicaid standards, policies, and industry best practices.
• Support development of dashboards, data visualizations, and decision‑support tools.
• Partner with stakeholders to gather requirements and deliver critical analytics and reports.
• Manage deliverables and maintain strong communication with executive‑level clients.

Required Qualifications

• 10+ years of experience in Information Technology, including 5+ years working directly with or for State Medicaid agencies.
• Expertise in Medicaid and CHIP programs, including claims, eligibility, and provider enrollment processes.
• Strong knowledge of CMS reporting requirements.
• Proficiency in SQL and Excel for data analysis against large datasets.
• Excellent verbal‑written communication and presentation skills; experience interfacing with executives and directors.
• Ability to travel to Springfield, IL 3–4 times per year.
• Strong alignment with organizational values: Integrity, Compassion, Inclusion, Relationships, Innovation, and Performance.

Preferred Qualifications

• Experience with PERM, T‑MSIS, CMS Federal Reporting, HEDIS, CHIPRA, or similar quality metrics.
• Familiarity with Teradata or equivalent database management systems.
• Prior experience in healthcare analytics and Medicaid enterprise systems.

Project Summary

This role supports the Illinois EDW contract, which includes maintenance and operations, reporting and analytics, and design, development, and implementation of Medicaid data solutions. The SME will collaborate with technical and business teams to ensure compliance, optimize processes, and deliver actionable insights.

Ideal Candidate Profile

• Deep Medicaid expertise with experience in enterprise data warehousing and decision‑support systems.
• Ability to lead and influence stakeholders while providing technical and business guidance.
• Strong analytical skills and experience with large‑scale health‑care data projects.

Top Skills

• Medicaid SME experience (5+ years)
• SQL and data analysis
• CMS reporting knowledge

Additional Details

• Team Structure: 3–4 Project Managers and 20+ Developers.
• Interview Process: 3–4 rounds, video‑based, mix of business and technical questions.
• Contract‑to‑Hire: Open to candidates requiring sponsorship for conversion.

EEO Statement

Apex Systems is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, creed, sex — including pregnancy, childbirth or related conditions — age, sexual orientation, gender identity, nationality, ancestry, citizenship, genetic information, domestic partner status, marital status, disability, veteran status, political affiliation, union membership, or any other characteristic protected by law.