Full Time 40 hours Grade 053 Pathology & Lab Medicine Schedule 8 AM-4:30 PM Responsibilities Position Summary: Under general direction from the Clinical Trials Manager for Information Systems and Data Management, and with considerable latitude for independent judgment develops data management plans and custom query programming to format data to meet client requirements. Validates system data extracts and reports; participates in system development and validation activities. Performs test and report set up activities as needed to support the Manager for Information Systems and Data Management. Responsibilities Develop programs and queries to manage data from clinical trials and research studies Develop queries, programs, and reports to extract and format data from Relational and Hierarchical Databases. Develop data flow diagrams and data dictionaries to document data origins, transformations, and outputs. Perform complex data manipulation using multiple file and data sources. Evaluate and ensure data quality Review, analyze, and validate data to ensure consistency, integrity and accuracy based on project specific guidelines Execute data quality checks and query data inconsistencies in compliance with standard operating procedures, client guidelines and regulatory agency guidelines. Develop and implementstrategies for data cleaning Design and program clinical databases as needed. Provide data transfers and reports per client specifications Communicate with internal and external customers to obtain data or information reporting requirements to provide data based solutions to business needs. Create Data Transfer Agreements with external customers to record data and service requirements. Design and produce properly formatted data output or reports to customers on a timely basis. Set up and manage secure data transfer mechanisms, such as FTP sites or portals. Support the management of clinical trials information systems Back up/ assist the Information Systems Manager in test set up, user security, and user training activities Trouble shoot system problems for users Prepare necessary materials and documentation for projects Develop Standard Operating Procedures for managing data Complete risk assessments in support of validation plans. Maintain system documentation in an audit-ready state. Other duties and projects as assigned. Requirements Bachelor's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering, with 2-3 years of experience in clinical or medical data management or an equivalent combination of education and experience. Experience with MS Access, SQL Server or MySQL, Oracle, SAS, and Crystal Reports desired. Medical Laboratory terminology preferred. Ability to maintain a friendly and courteous professional manner at all times. Ability to interact effectively and professionally with co-workers, customers, and vendors. Excellent computer and organizational skills; programming skills including SQL and commercial reporting and data mining tools. Strong technical communication and documentation kills. Ability to adjust work schedule if needed to meet project timelines.
About University of Rochester
The University of Rochester is one of the country's top-tier research universities. Our 158 buildings house more than 200 academic majors, more than 2,000 faculty and instructional staff, and some 11,100 students.
Learning at the University of Rochester is also on a very personal scale. Rochester remains one of the smallest and most collegiate among top research universities, with smaller classes, a low 10:1 student to teacher ratio, and increased interactions with faculty.