OVERVIEW

Hendall is currently seeking a Data Analyst, with experience processing and analyzing substance abuse treatment services and mental health treatment services data, to join a project team supporting the U.S. Department of Health and Human Service (HHS) Substance Abuse and Mental Health Services (SAMHSA) Center for Behavioral Health Statistics and Quality (CBHSQ).

In December 2016, the 21st Century Cures Act (Cures Act) was signed into law and codified CBHSQ. CBHSQ conducts national surveys tracking population-level behavioral health issues. CBHSQ also provides statistical and analytical expertise; both activities support the Assistant Secretary for Mental Health and Substance Use and the Secretary of HHS. CBHSQ maintains several data collection systems and surveys on key topics in U.S. behavioral health. This position will support the Behavioral Health Services Information System (BHSIS), which collects information on the U.S. behavioral health treatment system and connects people with substance use and mental health treatment through the Behavioral Health Treatment Services Locator.

DUTIES

The Data Analyst will be collaborative and demonstrate focus and attention to detail. He/she receives, analyzes, and processes BHSIS substance abuse treatment services and mental health treatment services data. Specifically:

• Receive data in electronic and hard copy formats and prepare for input and processing
• Analyze data files, produce error reports and work with stakeholders to resolve processing errors
• Create, document, and implement quality control procedures that eliminate data errors
• Prepare and submit monthly status reports documenting the status of data submissions
• Generate tabulations from survey data files
• Conduct routine ad hoc data runs and prepare write-ups in response to data queries
• Develop the structure, specifications, and code for new data elements
• Revise processing operations to incorporate new data elements and data quality control and timeliness procedures related to new elements
• Produce customized reports using SAS PROC TEMPLATE and SSRS
• Produce analytic data file with imputed variables flagged
• Generate analytic data file documentation, in ASCII and SAS format with SAS input statements and programming specifications
• Create 508-compliant, searchable information for posting on public facing websites
• Produce public-use data files and documentation in ASCII and SAS format, with SAS input statements
• Provide QA/QC related to project communications, project schedules, data submission support and monitoring, data quality, stakeholder engagement, and status reporting
• Create and maintain dashboards in Tableau

MINIMUM QUALIFICATIONS

• Bachelor's degree in math, statistics, data science, computer science, or related fields. Strong math and analysis skills are needed
• 5 years of professional experience in receiving, analyzing, processing large datasets (substance abuse and mental health domain knowledge preferred)
• 5 years' experience using SAS (Base SAS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, Macro facility, ODS, DDE)
• Experience using Python
• Experience with creating reports using PROC TEMPATE in SAS
• Experience with creating and maintaining relational databases using SQL
• Strong problem-solving skills
• Strong written and verbal communications skills
• Tableau, SSRS experience preferred
• Familiarity with SPSS, Stata, R a plus

Hendall Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.