Systems Programmer/Analyst II - The Youth and Family Training Institute (YFTI)

The Youth and Family Training Institute (YFTI) provides comprehensive training, coaching, credentialing, and evaluation of High Fidelity Wraparound programs across the state. The YFTI Evaluation Department also contracts with providers, counties, and states to provide evaluation services to federal and state grants and contracts, specializing in individualized data collection and visualization. This position will be within the Data Management division of the Evaluation Team and will report to the division Manager.

The candidate will assist in the development, creation, implementation, and analysis of various projects. The candidate should be comfortable with the design and development of databases in MS SQL Server, MS Access frontends, and dashboards. Additionally, the candidate should be able to properly document their work and review other team members’ code for auditing purposes.

This position is grant funded.

Purpose:

Under the general direction of the division Manager, the employee will assist with design and development of databases in MS SQL Server, MS Access frontends, and dashboards. Using their programming capabilities, database management knowledge, and statistical knowledge, they will contribute to the implementation of various projects/protocols.

Responsibilities:

• Provides ongoing maintenance and troubleshooting for staff as necessary.
• Develop and disseminate data management and tracking as needed.
• Assists with the creation, institution and enforcement of data collection and management policies and procedures, including the design of standard reports, database documentation, quality control procedures and security standards.
• Assists with the design, implementation, and maintenance of forms and imports for data collection.
• Independently perform statistical analysis and design and produce reports and dashboards as needed by projects.
• Communicate effectively with the research, clinical and administrative staff to maintain efficient communication about data gathering, data entry and statistical analysis.
• Typically has completed a four-year academic degree including courses in computer programming, systems analysis, system development, or systems engineering
  
  

OR

• has acquired Core IT skills and knowledge via practical experience.
• Completes on-going training on-the-job, through courses, self-study, certifications and/or advanced degrees to maintain and enhance technical and business capabilities.
• Demonstrates thorough understanding of the fundamental tools and concepts of one of the information technology professional disciplines (i.e., Applications, Business Analysis, Customer Service, Data, Networking, Operations, Security, Systems Engineering, etc.) and applies that understanding to make independent practical contributions to IT work within a particular UPMC department or function.
• Higher education (Bachelors/Masters) may be required per Grants.
  
  

Licensure, Certifications, and Clearances:

• Act 31 Child Abuse Reporting with renewal
• Act 33 with renewal
• Act 34 with renewal
• Act 73 FBI Clearance with renewal
  
  

UPMC is an Equal Opportunity Employer/Disability/Veteran

Annual