SQL Data Analyst

Apply Now

Summary

Under general direction of faculty and senior research personnel, the Data Analyst will be responsible for accessing, acquiring, and organizing medical record data from multiple University data sources to support research and quality improvement programs focused on efforts to assess and improve the equitable care of children. This individual will work with the project team to create analysis-ready data sets sufficient to assess potential inequities in the care of children.

The Data Analyst must be proficient in databases extracts using SQL. They should be familiar with the principles and practices of scientific research as well as pulling data from disparate data sources within the Michigan Medicine research community. Strong technical skills and communication skills are sought after for this position.

Mission Statement

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.

Why Join Michigan Medicine?

Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world's most distinguished academic health systems.  In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.

What Benefits can you Look Forward to?

  • Excellent medical, dental and vision coverage effective on your very first day
  • 2:1 Match on retirement savings

Responsibilities*

  • Access, obtain and organize clinical, socioeconomic, and/or other related data for health research from local sources of clinical data including U-M?s electronic record, MiChart, and the Research Data Warehouse.
  • Clean and manipulate datasets for optimal use by the project team.
  • Work with the project team to plan, create, and test data collection and processing workflows.
  • Evaluate and share results with the project team. Recommend changes in data collection plans and processes.
  • Identify 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.

Required Qualifications*

*      BA or BS in quantitative field with 5+ years of experience

*     Expert in SQL queries

*      Clarity Certified (i.e., completed required coursework to gain Clarity access)

*      Possesses a basic knowledge of common medical patient care domains (labs, diagnosis, medications, etc.)

*      Able to translate basic research questions into database queries resulting in research data sets.

Work Schedule

This position has the possibility of working in a full-time or part-time capacity.

Additional Information

A cover letter is required for consideration for this position and should be attached as page one 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. This position is currently funded for one year with additional years of funding anticipated.

Under FLSA, this is the exempt job classification for this title. Incumbents in this position must meet the full criteria for exempt status: salary level, salary basis, and duties tests.

Background Screening

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.

Application Deadline

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.

U-M EEO/AA Statement

The University of Michigan is an equal opportunity/affirmative action employer.