Data Analyst

## About the Role The Principal Data Analyst will serve as a Medicaid Subject Matter Expert (SME) supporting the Illinois Enterprise Data Warehouse (EDW) project. This role provides strategic guidance for a large-scale Medicaid data warehouse implementation and ongoing operations, leveraging deep expertise in Medicaid programs, claims processing, eligibility, provider data, and CMS reporting requirements. The role works across technical and business teams to support data-driven decision-making, compliance, analytics, reporting, and decision-support solutions. The ideal candidate brings extensive Medicaid experience, strong SQL and data analysis skills, and the ability to guide stakeholders and communicate effectively with executive-level clients. ## Key Responsibilities Provide strategic direction and recommendations for Medicaid data warehouse implementation and ongoing operations. Lead internal and external stakeholders in making determinations on complex processes involving: Claims adjudication Medicaid eligibility Third-party liability Identify state Medicaid agency data needs and recommend validated solutions supported by proof of concepts. Guide technical and business teams on healthcare data utilization and industry best practices. Recommend enhancements and improvements based on Medicaid standards, policies, and established industry practices. Support the development of dashboards, data visualizations, and decision-support tools. Gather requirements from stakeholders and support delivery of critical analytics and reports. Manage project deliverables and maintain strong communication with executive-level clients. Collaborate with technical and business teams supporting Medicaid data solutions. Help ensure compliance with CMS standards and optimize data and reporting processes. ## Required Qualifications 10+ years of Information Technology experience. 5+ years of experience working directly with or for State Medicaid agencies. Deep expertise in Medicaid and CHIP programs. Strong knowledge of: Medicaid claims Eligibility Provider enrollment CMS reporting requirements Proficiency in SQL and Microsoft Excel for analyzing large datasets. Excellent verbal and written communication skills. Strong presentation skills with experience interacting with executives and directors. Ability to travel to Springfield, Illinois, 3–4 times per year. Ability to provide both technical and business guidance to stakeholders. Alignment with the organization's stated values of Integrity, Compassion, Inclusion, Relationships, Innovation, and Performance. ## Preferred Qualifications Experience with PERM. Experience with T-MSIS. Experience with CMS Federal Reporting. Experience with HEDIS. Experience with CHIPRA or similar healthcare quality metrics. Familiarity with Teradata or equivalent database management systems. Prior experience in healthcare analytics. Prior experience with Medicaid enterprise systems. Experience with enterprise data warehousing and decision-support systems. ## Skills & Competencies Medicaid Subject Matter Expertise Medicaid and CHIP Programs Medicaid Claims Processing Medicaid Eligibility Provider Enrollment Third-Party Liability CMS Reporting SQL Microsoft Excel Data Analysis Large-Scale Data Analysis Healthcare Data Analytics Enterprise Data Warehousing Data Visualization Dashboards Decision-Support Systems Analytics and Reporting

Requirements

Gathering Proof of Concepts Stakeholder Management Executive Communication Technical and Business Guidance ## Education & Experience Education The source does not specify a required degree. Experience Minimum 10+ years in Information Technology. Minimum 5+ years working directly with or for State Medicaid agencies. Demonstrated experience with Medicaid programs, claims, eligibility, provider enrollment, and CMS reporting. Experience working with large-scale healthcare and Medicaid data environments. ## Work Arrangement & Schedule 100% Remote / Telecommute Location listed: Minneapolis, MN, US The role is associated with the Illinois Enterprise Data Warehouse (EDW) project. Travel to Springfield, IL, 3–4 times per year is required. The source does not specify regular working hours or a weekly schedule. ## Compensation & Benefits $50.00–$53.00 per hour Contract-to-hire opportunity. The source does not provide additional benefits information. ## Project Overview This position supports the Illinois Enterprise Data Warehouse (EDW) contract, covering: Maintenance and operations Reporting and analytics Design, development, and implementation of Medicaid data solutions Medicaid data compliance and optimization Actionable insights and decision-support capabilities The project team includes 3–4 Project Managers and 20+ Developers. ## Interview & Sponsorship Information Interview process: 3–4 video-based rounds. Interviews include a mix of business and technical questions. The source states that the contract-to-hire opportunity is open to candidates requiring sponsorship for conversion. ## Equal Employment Opportunity Apex Systems states that it is an equal opportunity employer and does not discriminate based on race, color, religion, creed, sex, 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.