Research Data Engineer II

University of Rochester • City of Rochester, NY

195d • $77,216 - $115,824

About The Position

This position is for a highly skilled professional who is a self-starter and able to work independently with minimum guidance. This role will lead the build and maintenance of the Urology department’s centralized database to add to the knowledge of the scientific community to enhance research and discovery and improve patient care. They are responsible for the design, implementation, and maintenance of analytical and data science-based software and data pipelines to support scientific workflows. This position will be a part of the Urology department, reporting to the Research Operations Manager, but will have support from the Wilmot IT team under Eric Snyder. They will leverage the Hyperion Datawarehouse and pipelines and build a space for Urology that has data relevant to cancer and benign disease on patients seen by Urology providers. The deliverables of this position are creation of a database that pulls from multiple data sources in order to obtain and validate data on Urologic patients for the purpose of research. The data goals are project specific, but the impact of this work is that it allows the physicians and physician scientists of the Urology department to win grants, publish on their findings and conduct research to boost institutional reputation and advance patient care. Clinical data on Urologic patients is essential for not only clinical research but translational research as well. This position will support the research mission on all fronts, working closely with Urology faculty and the Vice Chair of research to accomplish project specific goals. The position primarily focuses on developing and supporting data collection frameworks that integrate structured and unstructured data from multiple sources and systems, to support specific research study teams. Supports the development and maintenance of infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Works in partnership with team members to provide robust, scalable software solutions to the research enterprise.

Requirements

• Bachelor's degree in data science, Biomedical Science, Computer Science, Mathematics, Statistics, or similar discipline.
• At least two years of experience in technology and data intensive roles and environments, or equivalent combination of education and experience.
• Programming experience in SQL and one other applicable language (Java, Python, and/or R).
• Experience with Change Management solutions.
• Experience with Version Control solutions (e.g. Git).
• Experience implementing and supporting data management systems in a scientific, research context (e.g. biospecimen software, electronic laboratory notebooks, REDCap).

Nice To Haves

• Experience with Linux, container, and cloud technologies (e.g. HPC, IaaS and PaaS).
• Familiarity with file formats, metadata, and data exchange and storage standards applicable in management of scientific and clinical research.

Responsibilities

• Leads the effort to build and maintain a centralized database for the Department of Urology to enhance research and discovery and improve patient care.
• Works closely with faculty and leadership to establish data needs and find creative solutions to support the department’s strategic plan and research mission.
• Builds, maintains, and evolves general Extract, Transform and Load (ETL) data pipelines and overall data architecture to accommodate a growing amount of data from various large research data sources.
• Works with research team members and faculty to understand data requirements for the project.
• Writes and optimizes SQL queries to extract and analyze data from databases.
• Extracts, transforms, and delivers accurate and timely data to support research projects and answer research questions.
• Designs and implements custom, research project-specific data workflow solutions for data collection, management, reporting, and analytics.
• Manages request, extracting from data warehouse to report delivery in project specific format.
• Develops, implements, and maintains integrations between project specific databases (like REDCap) and the data warehouse (Hyperion).
• Troubleshoots and resolves issues related to API integrations and data flow.
• Participates in specification, implementation and execution of testing procedures, working with the lead department to validate data.
• Produces and maintains comprehensive technical documentation for all systems under the Engineer's responsibilities.

Benefits

• 401k
• health_insurance
• dental_insurance
• vision_insurance
• life_insurance
• paid_holidays
• tuition_reimbursement
• professional_development

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 1-10 employees