Job Description

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