Program Manager, Healthcare Data Analyses and Evaluation for Drug Use and Overdose Prevention Responses

Vital Strategies, headquartered in New York City, is an international public health organization. Our programs strengthen public health systems and address the world’s leading causes of illness, injury and death. We currently work in 73 countries, supporting data-driven decision making in government, advancing evidence-based public health policies and mounting strategic communication campaigns. Vital Strategies’ priorities are driven by the greatest potential to improve and save lives. They include non-communicable disease prevention, cardiovascular health promotion, tobacco control, road safety, obesity prevention, epidemic prevention, environmental health, vital statistics systems building and Multi-drug resistant tuberculosis treatment research. Our programs are concentrated in low- and middle-income countries and cities in Africa, Latin America, Asia and the Pacific. Please visit our website at www.vitalstrategies.org to find out more about our work.

We believe our programs are strengthened when they are developed and supported by individuals with diverse life experiences, whose understanding of social and cultural issues can help make our work and workforce more inclusive. We encourage people of all racial, economic, social, cultural, sexual orientation, and gender expressions to apply. As such, our commitment is to promote equal employment opportunities (EEO) for all applicants seeking employment. People of color, women, LGBTQI+ people, people with disabilities, people who use drugs or are in recovery, and formerly incarcerated people are encouraged to apply.

Vital Strategies is committed to helping prevent the spread of COVID-19 and to protecting the safety of our employees. All U.S. employees will be required to be fully vaccinated unless the employee is approved for a reasonable accommodation due to a disability or a religious reason.

Read about Diversity, Equity and Inclusion and Vital Strategies: https://www.vitalstrategies.org/diversity-equity-and-inclusion-at-vital-strategies/

Job Purpose:

Vital Strategies is seeking qualified candidates for the position of Program Manager, Healthcare Data Analyses and Evaluation for Drug Use and Overdose Prevention Responses, seconded to the Behavioral Services Division, New Mexico Human Services Department located in Santa Fe, New Mexico.

New Mexico’s Human Services Department is tasked with working with all partners to design and deliver innovative, high-quality health and human services that improve the security and promote independence for New Mexicans in their communities. As a division in New Mexico’s Human Services Department, the Behavioral Health Services Division (BHSD) is the Mental Health and Substance Abuse Authority for New Mexico. The role of BHSD is to address the need, services, planning, monitoring, and continuous quality systemically across the state.

This is a full-time and remote position based out of the state of New Mexico. We offer highly competitive compensation and comprehensive benefits. The salary range for this position in New Mexico is $68,000 - $75,000 USD. The candidate must have eligibility to work in the U.S. at time of hire.

Duties and Responsibilities:

The Secondee shall conduct work as if the Secondee were a full-time employee of the Behavioral Health Services Division, New Mexico Human Services Department (BHSD). The incumbent shall have the following duties and responsibilities:

1. Support BHSD on substance use disorder (SUD) reporting, analysis, and data modeling based on Medicaid and grant funded billing and consumer data;

2. Collaborate with BHSD Program Managers on report requests pertaining to service utilization based on specific services, diagnostic, and other demographic criteria as requested;

3. Support BHSD and Medical Assistance Divisions (MAD) on the New Mexico Medicaid 1115 Substance Use Disorder Evaluation project. This will include data reporting and modeling to verify the vendor’s finding, assist with construction of measure methodology and identifying similar measures to replace or changing existing measures;

4. Support BHSD and MAD on the New Mexico Medicaid 1115 Substance Use Disorder Monitoring protocol reporting;

5. Collaborate with BHSD, New Mexico Department of Health, and other partner agencies on various projects pertaining to substance use disorder data to include modeling for trends, aligning multiple datasets from various sources and identifying and documenting best practices for this reporting;

6. Develop and maintain complex Structured Query Language (SQL) queries based on report methodology and provided criteria;

7. Compile and analyze reports from Medicaid Managed Care Organizations (MCO) for quality trends as they align to the NM Medicaid contract and quality performance outcomes;

8. Collaborate with the Human Services Department (HSD), Information Technology Division (ITD) and the Administrative Services Organization (ASO) on enhancements to Treatment Episodes Dataset (TEDS) reporting;

9. Develop routine reporting to BHSD, Department of Health, and other partner agencies on SUD trends. Collaborate with other Vital Strategies seconded staff to create interagency partnerships, seed collaboration opportunities, and strengthen the network of staff statewide;

10. Experience writing descriptive analytical reports based on data findings regarding trends, projections, outliers, or other statistical elements;

11. Other duties as assigned. 

Qualifications:

Education and Degree - 

· Bachelor’s degree and/or Master’s degree in Computer Science, Public Health, Health Policy, Economics or related field preferred;

· Approximately 6 years of relevant program work experience in addition to education or 8 years of relevant experience in lieu of a degree is acceptable. If Master’s degree, 3 years’ experience.

Skills and Abilities - 

· Project management expertise, with the ability to exercise independent judgment and maintain appropriate deadlines;

· Excellent oral and written communication skills;

· Strong interpersonal skills, with demonstrated ability to maintain collaborative relationships with internal and external partners;

· Ability to write Structured Query Language (SQL) queries and understand logic behind existing queries;

· Understanding of data warehouse and database components, such as but not limited to tables, columns, data lineage, data variables and characteristics;

· Ability to analyze data and identify trends;

· Knowledge of healthcare evaluations as they pertain to substance use disorders;

· Knowledge of medical claims such CPT, UBREV and HCPC service codes, and ICD10 diagnoses;

· Experience with population health and ROI, risk or claims data;

· Ability to work well with diverse groups of individuals and organizations;

· Excellent organizational skills;

· Self-starter with ability to work independently;

· Experience with Microsoft Office suite;

· Ability to build strong, ongoing, impactful relationships at all organizational levels and across a diverse range of cultural, generational, ethnic, racial, educational, and social backgrounds;

· Demonstrated commitment to valuing diversity and contributing to an inclusive working and learning environment.

Experience:

Required - 

· Six years of professional experience, with a minimum of 4 years of direct experience with data analysis and healthcare program evaluations. Eight years of relevant experience in lieu of a degree is acceptable. Of the required experience, must have a minimum of 2 years of experience with SQL (must have advanced skills with SQL data development and reporting, e.g., can write their own queries and actively practice this skill).

Preferred - 

· Advanced skills with Excel.

· Prior experience analyzing Medicaid data and performing healthcare evaluations.

· Capable of extracting highly complex data sets.

· Experience with behavioral healthcare data and reporting specific to substance use disorder services.

· Experience with healthcare program evaluations and understanding of data modeling associated with evaluation reporting and response.

· Excellent communication and reasoning skills; must be able to think through usability of the tools/reports being created.

Working Conditions and Physical Requirements:

· Ability to travel within New Mexico for up to 30% of time.