Job Summary
The Michigan Society of Thoracic and Cardiovascular Surgeons Quality Collaborative (MSTCVS-QC) is a Blue Cross Blue Shield of Michigan (BCBSM) and Blue Care Network (BCN) Collaborative Quality Initiative (CQI) dedicated to improving the care of adult cardiac and general thoracic surgery patients in Michigan. The Quality Collaborative is a consortium of hospitals that work together to promote and share optimal processes of care and implement quality improvement initiatives based on regional and national data, clinical research, and evidence-based cardiac and thoracic surgery practices and guidelines.
We are currently seeking a temporary Database Analyst/Programmer to support the development and integration of data systems for a multi-phase project focused on linking patient-reported outcomes (EQ-5D) with clinical registry data and building interactive dashboards for quality improvement. A cover letter is required for consideration and should be attached as the first page of your resume.
The Database Analyst/Programmer will have a primary appointment in the Department of Cardiac Surgery at the University of Michigan and will report directly to the MSTCVS Program Manager.
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.
Responsibilities*
The MSTCVS Database Analyst/Programmer will play a critical role in designing, building, and maintaining data infrastructure to support the integration of Patient Reported Outcomes (PRO) data with MSTCVS registries and the development of interactive dashboards. Responsibilities include, but are not limited to:
- Design, develop, and maintain secure database systems and web-based applications to support project goals.
- Build and validate data pipelines linking PRO data with STS registry and other MSTCVS data sources.
- Develop and implement ETL (Extract, Transform, Load) processes for complex datasets.
- Collaborate with statisticians and analysts to ensure data integrity and usability for analysis and reporting.
- Create interactive dashboards integrating PRO, clinical, and demographic data for pilot sites and statewide use.
- Document database architecture, data flows, and programming logic for internal and external audiences.
- Ensure compliance with HIPAA and institutional security standards.
- Provide technical support and training for pilot sites on dashboard use and interpretation.
Required Qualifications*
Education & Experience:
- Bachelors degree in Computer Science, Data Science, Information Systems, or related field.
- Minimum 2 years of experience in database programming and data integration; healthcare or clinical data experience preferred.
Technical Expertise:
- Proficiency in SQL and database management tools (e.g., Microsoft SQL Server, MySQL).
- Experience with ETL processes and data warehouse development.
- Familiarity with programming languages such as Python (including NumPy, Pandas) and scripting for automation.
- Experience with Power BI as data visualization tools for dashboard development.
- Knowledge of web-based application development and secure data transfer protocols.
- Understanding of relational database design and optimization.
Additional Skills:
- Ability to manage and integrate multiple data sources, including registry and survey data.
- Strong problem-solving skills and attention to detail.
- Excellent documentation practices for code and workflows.
- Effective communication skills for collaborating with multidisciplinary teams and presenting technical concepts to non-technical audiences.
- Ability to work independently and manage multiple priorities in a dynamic environment.
Work Schedule
- Part-time, up to 20 hours/week, Monday-Friday.
- Position is temporary and limited up to two years (24 months).
- Hybrid work environment (onsite and remote) based out of our Ann Arbor, Michigan office.
- Flexible schedule required, with in-office days as needed and availability to attend quarterly Quality Collaborative meetings at various locations across Michigan.
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.
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 Statement
The University of Michigan is an equal employment opportunity employer.