Boston, Massachusetts
Charlottesville, Virginia
Los Angeles, California
Boston, Massachusetts
New York, NY, 10176, USA
Boston, Massachusetts
San Francisco, California
Indianapolis, Indiana,
Berkeley, California
Posted: 23-Dec-22
Location: Ann Arbor, Michigan
Salary: Open
Internal Number: 228500
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.
