CTSI Clinical Research Programmer Analyst

$55,955 - $78,336/Yr

University of Rochester - Rochester, NY

Full-time

Rochester, NY

Educational Services

About the position

The CTSI Clinical Research Programmer Analyst position offers an exciting opportunity to join the growing CTSI Informatics team, which is dedicated to transforming and accelerating clinical research initiatives. This role is pivotal in supporting informatics-related infrastructure programs and involves considerable independent judgment and initiative. The Programmer Analyst will be responsible for the specification, development, and deployment of various research tools and projects, including support for clinical research data warehouses and the Secure Environment for Research Data & Analytics (SERDA) computing platform. Collaboration is key in this role, as the Programmer Analyst will work closely with other members of the CTSI Informatics team, eRecord team members, senior CTSI leadership, and other research informaticians to ensure the success of these initiatives. In this position, the Programmer Analyst will evaluate, adopt, and improve open-source packages and tools to analyze and report on data quality and completeness within research data warehouses. The role requires the development of SQL queries, procedures, and other scripting codes using Python or R to assist in the maintenance and validation of research Common Data Models, including i2b2 and OMOP. Additionally, the Programmer Analyst will support the development and operation of computer programs that facilitate CTSI's informatics activities and research tools, such as clinical data cohort discovery tools, ATLAS, and TriNetx. The design, development, and maintenance of online dashboards to support reporting of CTSI informatics services and the operation of research data warehouses and the SERDA program are also key responsibilities. The Programmer Analyst will work collaboratively with other clinical research informaticians and programmer analysts to drive process improvements and will take on other projects and job duties as assigned.

Responsibilities

• Evaluate, adopt, and improve open-source packages and tools to analyze and report data quality and completeness in research data warehouses.
• Develop SQL queries, procedures, and other scripting codes (Python or R) to assist in the maintenance and validation of the research Common Data Models, including i2b2 and OMOP.
• Support development and operation of computer programs to facilitate the process of CTSI's informatics activities and research tools, including clinical data cohort discovery tools, ATLAS, and TriNetx.
• Design, develop, and maintain online dashboards in support of reporting of CTSI informatics services, and operation of research data warehouses and the SERDA program.
• Work closely with other clinical research informaticians and programmer analysts on process improvement.
• Other projects and job duties as assigned.

Requirements

• Bachelor's degree with major course work in Computer Science, Computer Engineering, Software Engineering, or equivalent.
• Minimum of 2 years of related work experience, or an equivalent combination of education and experience/training.
• A minimum of 2 years of programming experience with SQL in Microsoft SQL Server is required.
• Experience and knowledge with programming languages (Python or R) and BI tools (e.g. Tableau, Microsoft Power BI) are required.
• Familiarity with common data models such as i2b2 or OMOP and medical vocabularies (ICD, CPT4, SNOMED, etc.) are highly valuable.
• Ability to juggle several projects at once.
• Excellent communication and organization skills.