DISTINGUISHING FEATURES OF THE CLASS: This is a technical professional level position within the Department of Health and Mental Health which involves responsibility for designing, programming and customizing databases and queries for the NYS HEALing Communities Study. An incumbent is also responsible for developing various evaluation tools and methodologies for the purpose of coordinating an ongoing evaluations program for the study consistent with the department’s need for data collection and statistical reporting. The work is performed under the direct supervision of the Project Manager (Health/Mental Health) with additional oversight provided by the Columbia University’s Research Coordinator. Supervision may be exercised over subordinate staff participating in the study.  Does related work as required.

TYPICAL WORK ACTIVITIES: The typical work activities listed below, while providing representative examples of the variety of work assignments in the title does not describe any individual position.  Incumbents in this title may perform some or all of the following, as well as other related activities not described.

Collects and conducts quality control of grant required data related to fatal and non-fatal opioid overdose and access to and utilization of naloxone and medication for opioid use disorder (MOUD) in the county in collaboration with Columbia University’s Research Coordinator;

Works in collaboration with agency-funded programs to maintain surveillance data and ensure complete, quality data are available and accessible to the agency;

Manages surveillance data in multiple systems including MS Excel, Access, and a web-based surveillance system; uses programing languages such as SQL and R to write queries and run reports;

Evaluates program compliance with medical and public health guidelines by analyzing data; compiling, interpreting, and summarizing results;

Develops data management materials and documentation, such as protocols, data dictionaries, and data collection forms;

Programs and customizes various databases and designs queries to meet the needs of the NYS HEALing Communities Study;

Analyzes data pertaining to NYS HEALing Communities Study;

Work with Commissioner of Ulster County Department of Health and Mental Health and Columbia study team to improve surveillance on opioid use related indicators;

Provides technical and database administration support to study team;

Assists with data entry and data cleaning, as needed;

Assists with other data retrieval and analyses, as needed, which may include data to develop evidence-based medical and public health policies and procedures, data to respond to requests for information, and data for financial review or research purposes.

FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS: Good knowledge of database management systems, structures and techniques; good knowledge in one or more of the commonly used database query languages; good knowledge of MS Office (Excel and Access); good knowledge of tools and methods used for collecting and presenting data; good knowledge of spreadsheet and database applications; working knowledge of the New York State HEALing Communities Study; ability to design, program and customize databases to user defined needs; ability to design queries for the purpose of user defined reporting requirements and to generate reports from various databases; ability to prepare complex narrative and statistical reports using computer software; ability to write clear and accurate reports and records; ability to gather and organize pertinent data; initiative; accuracy.

MINIMUM QUALIFICATIONS: Either:

A. Graduation from a regionally accredited or New York State recognized college or university with a Master’s Degree in Computer Science, Information Technology, Management Information Systems or closely related field and two (2) years of experience in program design, development or evaluation; quantitative and qualitative research methods; or data analysis; OR

B. Graduation from a regionally accredited or New York State registered college or university with a Bachelor's Degree in Computer Science, Information Technology, Management Information Systems or closely related field and three (3) years of experience in program design, development or evaluation; quantitative and qualitative research methods; or data analysis.

SPECIAL REQUIREMENT: Possession of a valid New York State driver's license.

Special Requirement for appointment to Ulster County positions: In accordance with Ulster County Legislative Local Law Number 14 of 2007 or by other State and Federal Statutes, candidates for employment to all Ulster County positions must obtain clearance for appointment from the Department of Criminal Justice System or other mandated Federal and State regulatory authority based upon fingerprinting and a criminal history background check.

ULSTER COUNTY IS AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER

All qualified applicants will receive consideration for employment without regard to age, race, color, religion, gender, creed, national origin, physical or mental disability, marital status, veteran status, disabled veteran status, or status as a member of any other protected group or activity.

.