A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.
Precision Health (PH) at the University of Michigan is a presidential initiative that engages researchers across the entire campus in precision health discovery, translation, implementation, and policy research. The Data Analytics & IT (DA&IT) workgroup within PH focuses on creating a flexible, secure and robust research analytics platform (comprising infrastructure, tools, data, and analytics and facilitation services) that can adapt with the growing interdisciplinary field of precision health.
The PH SQL Data Analyst role is both a technical resource as well as a health research data engineer in the cross functional DA&IT team. This dynamic position guides researchers through the process of obtaining clinical, socioeconomic, biosensor, genetic and/or other related data for precision health research. Data resources will include any available source of health information from institutional, state and national sources. Some key local sources of clinical data include U-M’s electronic record, MiChart, and the Research Data Warehouse.
The Data Analyst position is a service-based role that includes monitoring the progress of PH research projects and identifying challenges to data access and data quality with the overarching goal of increasing the efficiency of the data extraction process and producing data in a timely manner. The successful candidate will be the PH in-house expert on relevant research data management systems and will work closely with University of Michigan scientists to obtain and organize research data according to emerging standards.
As PH 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 the Data Office for Clinical and Translational Research (DOCTR) to advance the infrastructure supporting cutting-edge research at U-M.
The selected individual will also produce standard and ad hoc statistical visualizations of stratified patient populations/cohorts to aid researchers in the early stages of their projects; join consultations with the PH research facilitators and/or other technical team members and assist with validation of de-identified/coded data and cohorts and computed phenotypes.
The Data Analyst must be proficient in database extracts using SQL and in statistical software and/or programming languages (e.g., SAS, Stata, R). 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 and cleaning and manipulating datasets for optimal use by the University of Michigan research community. Strong technical skills and communication skills are sought after for this position.
Meet with researchers to understand the study aims, the data requirements, and analysis plan in order to develop technical specifications for a robust dataset
Work with the investigators to ensure that PH projects progress efficiently from approved protocols through to the completion of data or sample access requirements
Design and development of complex database queries for PH researchers from across the University
Join data from various systems and disparate databases into a cohesive set for analytics
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)
Develop statistical visualizations of patient populations/cohorts
Assist with validation of cohorts/starting populations and QC/QI of de-identified/coded data
Maintain documentation of decisions made during the build of SQL queries
Adhere to data quality processes to ensure product is valid and reproducible
Collaborate with other SQL analysts in DOCTR and across the University to share code and best practices
Guide and support efforts to organize, format, and upload research data to repositories
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 researchers
Work with a team of diverse, motivated individuals toward a shared mission
A BA/BS in health-related science with a working knowledge of the fields of Information Science, Public Health or Domain Sciences with computer/computational/data science specialization or equivalent experience with information systems
At least 2 years post bachelor’s or master's degree 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)
Experience with translating information requirements into SQL code
Familiarity with statistical tools and practices
Strong analytical, time-management, problem-solving and decision making abilities
Ability to work successfully in programs that span U-M with an understanding unique processes at a school/college level
Excellent communication 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 as well as independently
BA/BS in Computer Science or equivalent experience with MS degree preferred
2-5 years’ experience directly related to the responsibilities specified
Experience with project management practices
Familiarity using high-throughput computing systems
Enthusiasm for scientific research
Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
The University of Michigan is an equal opportunity/affirmative action employer.
U-M COVID-19 Vaccination Policy
COVID-19 vaccinations are now required for all University of Michigan students, faculty and staff across all three campuses, including Michigan Medicine. This includes those working or learning remotely. More information on this policy is available on the Campus Blueprint website or the U-M Dearborn and U-M Flint websites.
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.