Database Analyst/Program Inter

University Of Michigan; Ann Arbor (MI); Hybrid; USD 30,000 - 54,000; Part time

Benefits offered by this job

Excellent medical, dental and vision

2:1 Match on retirement savings

Job summary

The University of Michigan's Michigan Medicine seeks a part-time 0.5 FTE Database Analyst/Programmer Intermediate to design, maintain and utilize database systems supporting MS and Neuroimmunology research.

The role focuses on extraction, integration and management of clinical and research data from EMR and other sources (Oracle, SQL, Redcap, Excel), collaborating with investigators, biostatisticians and clinical teams while ensuring data quality and compliance.

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
• 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
• 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

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

Job description

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,000employees 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 .

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.