Senior Data Analyst - Enterprise Data Warehouse (Federal Reporting)

Job title: Senior Data Analyst - Enterprise Data Warehouse (Federal Reporting) Client: Hunter Scouts Location: Springfield, Illinois, United States - Remote (local Springfield candidates strongly preferred; travel up to 15% required) Contract type: CONTRACT Contract duration: 12 months (possible multi-year extension) Salary: $47 - $53 per hour (W2) About the role Hunter Scouts is recruiting on behalf of a confidential large healthcare organization for a Senior Data Analyst to join an Enterprise Data Warehouse (EDW) team focused on CMS federal reporting for Medicaid and CHIP programs. This is a remote, W2 contract role with occasional travel (up to 15%) to Springfield, IL. In this role you'll analyze healthcare data, build and optimize SQL-driven reports and dashboards, ensure data integrity for CMS reporting (e.g., CMS-64/21), and work directly with stakeholders to translate business requirements into technical solutions. You'll also mentor junior analysts and maintain technical documentation. Responsibilities • Analyze healthcare-related data to support CMS federal reporting (including CMS-64/21) and business decision-making • Develop, optimize and maintain SQL-driven reports, dashboards and ETL logic • Perform data profiling, validation and anomaly detection to ensure data accuracy and integrity • Gather requirements from business stakeholders, write technical specs and support user acceptance testing (UAT) • Document data processes, report logic and maintain technical documentation • Present findings and provide regular project updates to clients and senior stakeholders • Mentor and provide technical guidance to junior team members Requirements • Must currently be based within a 50-mile radius of Springfield, Illinois, United States • Must be authorized to work in the U.S. without current or future employer sponsorship and able to work on a W2 basis (no C2C; no sponsorship) • 5+ years of healthcare business analysis experience, including writing business requirements and conducting UAT • 5+ years of SQL development experience including performance tuning; experience working in enterprise data warehouse (EDW) environments and applying data warehousing best practices • 3+ years of experience working with State Medicaid and/or CHIP agencies on CMS federal reporting (CMS-64/21) or demonstrated ability to quickly acquire domain knowledge • Bachelor's degree or higher in IT, Computer Science, Mathematics, Statistics or a related STEM field Preferred Skills • Experience with BI tools such as Tableau or Power BI • Experience developing Adult/Child Core Measures, HEDIS, CHIPRA or similar quality metrics • Experience with healthcare data systems (claims, eligibility, encounters) • Experience working in Agile environments • Strong stakeholder communication and presentation skills