About the position 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.

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

Requirements

• 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

Nice-to-haves

• 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
• Proficiency with additional tools such as Word, PowerPoint, and statistical software
• 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

Benefits

• A range of benefits for this role