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.
The primary mission of the University of Michigan Medical School Office of Research is to foster an environment of innovation and efficiency that serves the Medical School research community and supports biomedical science from insight to impact. To that end, our team is constantly striving to enhance the research enterprise, including maintaining an investigator-focused infrastructure, facilitating and diversifying investigators' avenues for funding, and streamlining research processes.
The UMMS Office of Research has numerous reporting units and programs such as the Michigan Institute for Clinical & Health Research (MICHR), the Clinical Research Calendar Review & Analysis Office (CRAO), the Fast Forward Medical Innovation, the Biomedical Research Core Facilities (BRCF), the Institutional Review Board (IRBMED), and the Medical School Data Office for Clinical and Translational Research (DOCTR). Together, these teams 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.
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.
The SQL Data Analyst role is both a technical resource, as well as a research data engineer. This dynamic position in DOCTR guides researchers through the process of obtaining clinical, 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, and 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 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 and python. 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.
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
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.
A background in health-related science with a working knowledge of the fields of Information Science, Public Health or Domain Sciences with computer / computational / data specialization or equivalent experience information systems, bioinformatics,
At least 5 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)
?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
BA/BS in Computer Science or equivalent experience with MS degree preferred
5-10 years’ experience directly related to the responsibilities specified
EPIC Training (proficiency)
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, including one booster when eligible, are required for all University of Michigan students, faculty and staff across all campuses, including Michigan Medicine. This includes those working remotely and temporary workers. More information on this new policy is available on the U-M Health Response website or the UM-Dearborn and UM-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.