Research Data Engineer II

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share : equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address) :

601 Elmwood Ave, Rochester, New York, United States of America, 14642

Opening : Worker Subtype :

Regular

Time Type : Full time

Scheduled Weekly Hours :

40

Department : 400151 Urology M&D

Work Shift :

UR - Day (United States of America)

Range : UR URG 113

Compensation Range :

$77,216.00 - $115,824.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries / hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities : GENERAL PURPOSE

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.

ESSENTIAL FUNCTIONS

Leads the effort to build and maintain a centralized database for the Department of Urology to add to the knowledge of the scientific community to enhance research and discovery and improve patient care as it relates to clinical research.

Works closely with faculty and leadership to establish data needs and find creative solutions in order 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 a variety of large research data sources that will support clinical and translational research on Urologic patients.

These data sources include the Electronic Medical Record looking at procedures, medications, lab values, clinical notes, etc.

Cancer Registries and Other Specialty databases might also be utilized.

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, ensuring completeness and accuracy, quality of deliverables, system and data workflow reliability.

Adheres to defined application software development life-cycle practices.

Produces and maintains comprehensive technical documentation for all systems under the Engineer's responsibilities.

Keeps abreast of current application developments through continuing education, professional reading, online forums, conferences, workshops, and professional groups.

Other duties as assigned

MINIMUM EDUCATION & EXPERIENCE

Bachelor's degree in data science, Biomedical Science, Computer Science, Mathematics, Statistics, or similar discipline Required

At least two years of experience in technology and data intensive roles and environments, or equivalent combination of education and experience Required

Programming experience in SQL and one other applicable language (Java, Python, and / or R). Required

Experience with Change Management solutions Required

Experience with Version Control solutions (e.g. Git) Required

Experience implementing and supporting data management systems in a scientific, research context (e.g. biospecimen software, electronic laboratory notebooks, REDCap) Preferred

Experience with Linux, container, and cloud technologies (e.g. HPC, IaaS and PaaS) Preferred

Familiarity with file formats, metadata, and data exchange and storage standards applicable in management of scientific and clinical research. Preferred

KNOWLEDGE, SKILLS AND ABILITIES

Understanding of data analytics and statistical methods Required

Expertise of software engineering best practices such as version control and software release management Required

Strong analytical and problem-solving skills Required

Strong organizational skills Required

Ability to work with others in a matrix management environment. Required

Excellent communication skills for describing progress and challenges to stakeholders Required

Attention to detail, patience, and a positive, customer-centric attitude Required

Strong technical presentation skills Required

Demonstrated ability to develop proficiency with unfamiliar toolsets Required

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University's Mission to Learn, Discover, Heal, Create - and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military / veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.

Notice : If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward.

Learn. Discover. Heal. Create.

Located in western New York, Rochester is our namesake and our home. One of the world's leading research universities, Rochester has a long tradition of breaking boundaries-always pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better.

If you're looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals

At the University of Rochester, we are committed to fostering, cultivating, and preserving an inclusive and welcoming culture and are united by a strong commitment to be ever better-Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.