Data Analyst

FUNCTIONAL DEFINITION

This Data Analyst position is assigned to the Allegheny County Department of Human Services (DHS), Office of Intellectual Disability (ODS). The Data Analyst will be responsible for ODS data collection, maintenance, and reporting. This individual will design data reports and databases to meet internal management needs and to represent the status of ODS administration of services and supports to external partners and stakeholders.

DUTIES AND RESPONSIBILITIES

A. Reporting and integrating data from multiple systems and sources, including but not limited to program eligibility and consumer demographics, support plans, assessments, service authorizations and utilization, incident management, and waiver capacity management.

B. Maintenance of internal ACCESS databases from HCSIS Extract source.

C. Development of new databases to support and enhance business functions.

D. Tracking and problem-resolution of data integrity issues identified internally and as required by the State Office of Developmental Programs (ODP)

E. Providing relevant, specific, and current data to ODS teams to facilitate administration of services

F. Maintaining and reporting data relevant to performance indicators.

G. Maintaining and reporting data relevant to the ODS Quality Management Plan.

H. Maintaining and reporting data relevant to the State ODP monitoring of the Administrative Entity (QA&I)

I. Maintaining and reporting data relevant to ODS oversight of Supports Coordination and Provider functions.

J. Technical assistance to ODS staff in collection and maintenance of data

K. Data analysis to support system change and quality improvement, including special projects to support ODS collaboration with other PA Counties and with the State ODP.

SKILLS AND KNOWLEDGE

A. Ability to work in a team-oriented atmosphere.

B. Ability to be attentive to detail.

C. Strong organizational skills demonstrated.

D. Strong problem-solving skills

E. Excellent written and verbal communication across all levels

F. Working knowledge of Microsoft Office products including Access, Word, Excel, and PowerPoint. Working knowledge of internet research methods.

G. Ability to work at a high level of independence with minimal supervision.

H. Ability to interact with individuals on all organizational levels.

I. Ability to collaborate with people from a variety of diverse agencies, backgrounds, resources, and communities.

J. Ability to compile reports based on individualized and aggregate data.

K. Ability to adapt to and learn new software products.

ESSENTIAL REQUIREMENTS

A. Possess Acts 33, 34 and FBI clearances.

B. Have a valid Pennsylvania motor vehicle license, access to a personal vehicle, and have maximum auto insurance on an employee driven vehicle.

C. Strong data management and analysis skills

D. Expertise in ACCESS and Excel

E. Ability to work independently.

F. Full-time position requiring 40 hours per week.

EDUCATION AND EXPERIENCE

Bachelor’s degree in math, statistics, computer science, or related subject and one year of experience in data collection, reporting and analysis or three years of experience in data collection, reporting and analysis. Preferred experience in project management and performance measurement.