Medicaid Program Advisor - HCBS Waiver Programs

Medicaid Program Advisor 1 Location: Albany, NY (50% Onsite / 50% Remote) Position Overview The Medicaid Program Advisor will support the Waiver Program Manager within the Division of Community Integration and Alzheimer’s Disease, part of the Center for Home & Community Based Services (HCBS) at the New York State Department of Health. This role is responsible for data analysis, reporting, and program support related to HCBS waiver programs, helping ensure compliance with federal and state requirements while driving data-informed decision-making. Key Responsibilities Develop, program, and maintain databases to support HCBS waiver program tracking and reporting Compile, analyze, and interpret data using statistical and database tools Produce both automated and ad hoc reports for program monitoring and leadership review Support the development of program policies based on data-driven insights Track participant status, utilization metrics, and program performance Provide technical assistance for reporting systems, data management, and performance measurement processes Respond to ad hoc data requests, including data linking and advanced analysis Coordinate cross-bureau activities and information sharing within the Division Assist in the planning and implementation of programs and project initiatives Collaborate with CMS and other external stakeholders to ensure compliance with federal regulations Participate in presentations, workshops, and stakeholder engagement activities Required Qualifications 8 years of professional experience Minimum 5 years of experience with SAS and/or SQL Strong proficiency in Microsoft Office Suite, with emphasis on Access and Excel Experience in database programming, data analysis, and reporting Ability to manage full-cycle analytical or research projects Preferred Skills & Competencies Strong analytical, problem-solving, and critical-thinking skills High attention to detail with the ability to work independently and strategically Ability to clearly communicate complex quantitative and qualitative findings to diverse audiences Experience with HCBS, Medicaid, or government programs (preferred) Proficiency with additional tools such as Word, PowerPoint, and statistical software Additional Expectations Ability to coordinate activities across multiple teams and stakeholders Comfortable engaging with external partners such as CMS Experience presenting in public forums, workshops, or cross-functional meetings Ability to manage multiple priorities in a fast-paced environment Keywords Medicaid, HCBS, Home and Community Based Services, SAS, SQL, Data Analysis, Data Reporting, Database Management, Microsoft Access, Excel, Public Health, Healthcare Analytics, Policy Analysis, Program Evaluation, CMS, Healthcare Data, Statistical Analysis, Government Programs, Waiver Programs, Data Management, Tableau (optional), PowerPoint, Cross-functional Collaboration