Database Analyst/Programmer Sr
University of Michigan
Ann Arbor, MI
Job posting number: #7252644
Posted: June 5, 2024
Application Deadline: Open Until Filled
Job Description
SummaryThe SQL Data Analyst role is both a technical resource, as well as a research data engineer. This dynamic position in the Data Office for Clinical and Translational Research (DOCTR) guides researchers through the process of obtaining clinical (EPIC) electronic health record, socioeconomic, biosensor, genetic and/or other related data for health research. Data resources will include any available source of health information from institutional, state and national sources. Local sources of clinical data include U-M's electronic record, MiChart, the Research Data Warehouse. The Data Analyst will play a key role in the development and refinement of data practices which will constitute an integral part of the Office of Research's critical mission. The Data Analyst position is a service-based role that includes monitoring the progress of research projects and identifying challenges to data access and data quality with the overarching goal of increasing the efficiency of data extraction process and producing data in a timely manner. The Data Analyst will be the in-house expert on our research data management systems and will work closely with our research scientists to obtain and organize research data according to emerging standards. As studies are conceived, the Data Analyst will work with scientists to plan, create, and test data collection and processing workflows. In addition, the Data Analyst will work among a team of data analysts and other research facilitators in DOCTR to advance the infrastructure supporting cutting-edge research at U-M.
The Data Analyst must be proficient in databases extracts using SQL. He/She should be familiar with the principles and practices of scientific research and project management as well as pulling data from disparate data sources, cleaning and manipulating datasets for optimal use by the Michigan Medicine research community. Strong technical skills and communication skills are sought after for this position.
DOCTR is firmly committed to advancing inclusion, diversity, equity, accessibility, and belonging, which are core to the culture and values of the Medical School Office of Research. Our community supports recruiting and cultivating a diverse workforce as a reflection of our commitment to serve the diverse people of Michigan and the world. We strive to create a work culture where each team member feels respected, valued, and safe.
Mission Statement
The primary goal of the Michigan Medicine Office of Research is pursuing innovative science to improve the lives of patients and their families. The various units within the OoR, including the Data Office for Clinical and Translational Research (DOCTR) strive to: 1) create and maintain strategic data resources to enhance investigators' competitiveness; 2) streamline research processes to increase research team satisfaction; and 3) build a coordinated, data-driven infrastructure to support high-quality research.
Responsibilities*
Meet with researchers to understand the study aims, the data requirements, and analyses plan in order to develop technical specifications for a robust dataset.
Design and development of complex database queries for researchers from any medical specialty
Join data from various systems, disparate databases into a cohesive set for analytics
Uphold ethical and privacy principles when handling sensitive patient data
Maintain documentation of decisions made during the build of SQL queries
Adhere to data quality processes to ensure product is valid and reproducible
Work with a team of diverse, motivated individuals toward a shared mission
Interface with genetic data specialists, programmers and other experts to facilitate assembling multifaceted data sets (examples might include addition of socioeconomic, epidemiology, or GIS data)
Guide and support efforts to organize, format, and upload research data to repositories
Specific Duties
Work with the investigators to ensure that projects progress efficiently from approved protocols through to the completion of data or sample access requirements
Collaborate with other SQL Analysts to share code and best practices
Develop re-usable datasets that investigators can more readily acquire and analyze
Interface with regulatory and quality assurance team members to make improvements to data prior to delivering to researcher.
Required Qualifications*
A Bachelor?s degree in with working knowledge of the fields of Information Science, Public Health or Domain Sciences with computer / computational / data specialization or equivalent experience information systems.
At least 2 years post degree with experience in:
Organizing and processing large datasets with multiple types of data, human subjects research data preferred
Human subject research processes (e.g. study planning, data collection, processing, analysis; IRB, HIPAA-policies, federal agency requirements)
Strong analytical, time-management, problem-solving and decision making abilities
Experience with translating information requirements into SQL code
Ability to work successfully in programs that span U-M with an understanding unique processes at a school/college level
Excellent communication and problem-solving skills; ability to interact with diverse individuals including PIs, research staff and management.
The skills needed to manage ongoing research processes, interface successfully with multiple partners and enhance these processes over time
Ability to manage multiple competing priorities with competing data needs
Candidate must be committed to data security and the protection of sensitive information with demonstrated knowledge of applicable data use/sharing safeguards
Proactive and creative techniques in solving researchers? problems
Positive attitude, ability to work well with others and independently