Department Name: 7H0CR: Clinical Research Support Office
The Clinical Research Support Office (CRSO) is currently seeking a Senior Research Systems Business Analyst. This position functions as data management support for the clinical trial management system (CTMS) for the enterprise through the CRSO. This position will report directly to the CRSOCTMS Administrator and will have frequent contact with faculty and staff engaged in the operational support of clinical trials at the University of Kentucky. This role will help aggregate and visualize research data into usable spreadsheets and custom reports. The individual in this role must be able to write complex SQL queries to the Oracle database that houses the clinical trials management system. Experience with Forte's OnCore CTMS is preferred (alternatively, demonstrated experience with another commercial CTMS is valuable).
Additionally, the preferred candidate will:
Possess the ability to interpret research and business data needs and convey information through custom reports that are comprehensible to research professionals with various technical skill levels.
Conduct statistical analysis and verify the validity of exported data.
Customize existing and create new custom reports to import and use within the CTMS.
Create visualizations that may include graphical representations and heat charts.
Have a basic understanding of Application Programming Interface (API) and communication between integrated software.
Assist CTMS Administrator as a backend database expert through troubleshooting, creation of database triggered reports, and help maintain the integrity of collected research data.
Work well within teams and as an individual.
SQL queries within Oracle Database
Tableau type Business Intelligence Tools
Strong communication skills (verbal and written)
Position Time Status: Full-Time
Required Related Experience:
Required License/Registration/Certification :
SQL and Oracle database management/queries
Strong understanding of relational database
Knowledge/Experience handling heath care data
Basic statistical skills
Health Level-7 (HL7) International Standards
University Community of Inclusion:
The University of Kentucky is committed to a diverse and inclusive workforce by ensuring all our students, faculty, and staff work in an environment of openness and acceptance. We strive to foster a community where people of all backgrounds, identities, and perspectives can feel secure and welcome. We also value the well-being of each of our employees and are dedicated to creating a healthy place to work, learn and live. In the interest of maintaining a safe and healthy environment for our students, employees, patients and visitors the University of Kentucky is a Tobacco & Drug Free campus.
As an Equal Opportunity Employer, we strongly encourage veterans, individuals with disabilities, women, and all minorities to consider our employment opportunities.
Any candidate offered a position may be required to pass pre-employment screenings as mandated by University of Kentucky Human Resources. These screenings may include a national background check and/or drug screen.
Adjacent to downtown Lexington, UK is nestled in the scenic heart of the beautiful Bluegrass Region of Kentucky. UK's campus covers more than 814 acres, with more than 30,700 students and 13,500 full-time employees, including nearly 2,400 full-time faculty and librarians.