Database Analyst/Program Inter

Michigan Medicine; Ann Arbor (MI); Hybrid; USD 40,000 - 70,000; Part time

Job summary

Michigan Medicine's MS and Neuroimmunology Division in the Department of Neurology seeks a PART-TIME (0.5 FTE) Database Analyst/Programmer Intermediate to build and maintain data systems supporting a diverse research portfolio. This role focuses on extraction, integration, and management of clinical and research data from EMR and other sources.

The successful candidate will collaborate with investigators, analysts, and clinical teams to ensure data quality, availability, and alignment with study

Qualifications

• Bachelor’s degree with at least some additional post-graduate training in computer science, data science, health informatics, or a related field
• Experience in SQL Server and/or Oracle.
• Experience with Excel and Redcap
• Experience with data integration from multiple sources.
• Experience in database creation and data management
• Excellent organizational, analytical, and communication skills
• Willingness to use PC and Microsoft systems that are maintained by Health Information Technology & Services (HITS) for all work-related tasks

Responsibilities

• Evaluate, update, and design database structures to support research initiatives and projects in the MS and Neuroimmunology Division
• Design and maintain processes for data extraction, transformation, collation, and secure storage across multiple data sources (the EMR, Oracle, SQL, Redcap, Excel)
• Maintain comprehensive documentation including data dictionaries, data flow diagrams, and system specifications
• Prepare clean, analysis-ready datasets for analysis by biostatisticians and investigators
• Assist study teams with set-up of wearable data collection processes for prospective studies that involve smartwatches and fitness trackers in accordance with specific study protocols and workflows, including device setup/activation, integration of device with online storage platforms/dashboards, data monitoring and processing
• Support development of datasets for clinical trials and prospective cohort studies
• Ensure data quality, integrity, and compliance with institutional and regulatory standards
• Clearly communicate findings to clinicians, trainees, and multidisciplinary collaborators

Skills

SQL/Oracle

Excel

Redcap

Data integration

Data management

Analytical skills

Communication

Education

Bachelor's degree in CS/Health Informatics/Data Science

Tools

SQL Server

Oracle

Python

R

SAS

Job description

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.

Job Summary

The Multiple Sclerosis and Neuroimmunology Division in the Department of Neurology seeks a PART-TIME (0.5 FTE) Database Analyst/Programmer Intermediate to create, update, maintain, and utilize database systems that support a diverse and multidisciplinary research portfolio. This role focuses on extraction, integration, and management of clinical and research data from a variety of sources to support ongoing and planned projects led by our MS faculty and trainees.

The individual will work with and update an existing MS/Neuroimmunology Clinic Database that contains data from the EMR, and synthesize datasets that integrate EMR data with other prospectively collected data that may include patient reported outcome data, digital data from wearables (e.g. smartwatches, accelerometers), neuroimaging data, and/or biomarkers. Liaising between investigators and HITS to facilitate EMR workflows that will generate new data for the existing MS database, and integration of data generated from other created databases (e.g., wearable digital data repositories) with existing MS database output is also anticipated. This position partners closely with physician-investigators, analysts, and clinical teams to ensure data integrity, accessibility, and alignment with research and operational objectives. Consistent with U-M intermediate-level classifications, there is potential for some independence.

Responsibilities*

• Evaluate, update, and design database structures to support research initiatives and projects in the MS and Neuroimmunology Division
• Design and maintain processes for data extraction, transformation, collation, and secure storage across multiple data sources (the EMR, Oracle, SQL, Redcap, Excel)
• Maintain comprehensive documentation including data dictionaries, data flow diagrams, and system specifications
• Prepare clean, analysis-ready datasets for analysis by biostatisticians and investigators
• Assist study teams with set-up of wearable data collection processes for prospective studies that involve smartwatches and fitness trackers in accordance with specific study protocols and workflows, including device setup/activation, integration of device with online storage platforms/dashboards, data monitoring and processing
• Support development of datasets for clinical trials and prospective cohort studies
• Ensure data quality, integrity, and compliance with institutional and regulatory standards
• Clearly communicate findings to clinicians, trainees, and multidisciplinary collaborators

Required Qualifications*

• Bachelor?s degree with at least some additional post-graduate training in computer science, data science, health informatics, or a related field
• Experience in SQL Server and/or Oracle.
• Experience with Excel and Redcap
• Experience with data integration from multiple sources.
• Experience in database creation and data management
• Excellent organizational, analytical, and communication skills
• Willingness to use PC and Microsoft systems that are maintained by Health Information Technology & Services (HITS) for all work-related tasks

Desired Qualifications*

• Completed Master?s degree in computer science, data science, health informatics, or a related field
• Experience with Machine Learning/Natural Language Processing applications
• Experience with Python, R, and/or SAS
• Worked with data coming to/from an EMR
• Familiarity with clinical research data structures and workflows
• Experience with dashboarding and data visualization tools

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

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

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.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.