Medicaid Program Advisor - HCBS Waiver Programs

Staffing Solutions Organization LLC (SSO), an affiliate of Public Consulting Group LLC (PCG), is focused on delighting clients with world-class managed staffing and talent consulting services. SSO is committed to a diverse workforce, which is a reflection of our clients and the people they serve.

Medicaid Program Advisor 1 - HCBS Waiver Programs

Location: Albany, NY

• This role will be fully onsite during the first six months to support onboarding and team integration.
• After that period, employees may transition to a hybrid schedule (50% onsite / 50% remote) with manager approval.

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

Compensation for roles at Staffing Solutions Organization LLC (SSO) varies depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, SSO provides a reasonable range of compensation for this role. In addition, SSO provides a range of benefits for this role.

Applicants must be authorized to work in the U.S. This position is not eligible for work authorization sponsorship (including H-1B sponsorship) by SSO and under the federal laws relating to the F-1 STEM EAD program, this position is not eligible to support a STEM EAD extension application.


All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, marital status, age, national origin, protected veteran status, or disability. Staffing Solutions Organization LLC is an E-Verify participant.