Redcap Data Analyst Jobs in Detroit, MI (NOW HIRING)

How to Apply
A cover letter is required for consideration for this position and should be attached as the first page 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.
Job Summary
This position will serve as the data analyst and programmer for the Pediatric Cardiac Critical Care Consortium (PC4), a multi-institutional quality improvement collaborative that maintains a registry containing data from more than 70 member sites across North America. PC4 engages stakeholders across pediatric cardiac critical care, cardiac surgery, and cardiology. PC4?s work is grounded in the core principles of collaborative quality improvement: Purposeful collection of clinical data on outcomes and practices, timely performance feedback to clinicians, and continuous improvement through empirical analysis and shared learning. The PC4 registry is housed in a large, complex relational database comprising more than 30 tables related to pediatric cardiac intensive care, including surgery, mechanical ventilation, cardiac catheterization, medications, and patient complications.
This position will be embedded in a University of Michigan pediatric cardiology research core, M-CHORD, which currently consists of 15+ staff, including 4 existing data managers who focus on data management for registries similar to PC4, all of which are part of Cardiac Networks United.
Responsibilities*

• Both independently and as part of a team, provide feedback on the design of, and oversee timely and accurate completion of, research and quality improvement projects utilizing data from PC4, and on occasion, related, similar registries. Projects may be initiated by investigators both internal and external to UM. More specifically, the PC4 data manager constructs targeted datasets for analysis by synthesizing data from multiple one-to-many tables, following written specifications, and using SQL or an equivalent data tool. They also process data fields that run in parallel using loops and arrays. The work involves both understanding and repurposing macro-dependent code written by senior PC4 staff, and writing new code where needed.
• Utilize excellent oral and written communication skills, as well as excellent interpersonal skills, to engage with stakeholders (which include physicians, clinical staff, project managers, statisticians, and other data managers), and on a daily basis. This position requires collaboration with other data managers and analysts for multi-registry efforts, therefore the applicant must be comfortable communicating and programming in a team environment.
• Maintain written documentation of data management decisions made on each project during analysis meetings to keep investigators and leadership up to date. There are typically 2-4 projects in process at one time.
• Serve as member of the PC4 audit committee, tasked with monitoring data quality across 70+ member sites across the US. This role requires basic knowledge of SQL, macro language, and REDcap, and the ability to draft clear written feedback to sites on audit findings.
• Maintain the PC4 Data Definitions Manual, which is updated and distributed to all stakeholders annually. This pdf document is extracted from an Access database, and requires basic knowledge of queries, forms, and reports.
• Attends and actively participate in Zoom meetings 5-15 hours per week, including a weekly meeting with data collectors from the 70+ member sites.
• Interact with principal investigators/executive leaders of individual networks to develop data collection tools, software specifications, and to compose data dictionaries.
• Integrate data from multiple sources and perform complex programming to prepare data for meaningful and appropriate analytics. Able to assess and revise programming by more junior data analysts as necessary.
• Serve as a liaison with software vendors and other third-party collaborators supporting PC4 (or similar) to develop data entry and reporting platform software.
• Design, implement and maintain complex databases including validation checks, monitoring of standards and procedures, and assure protection and security.
• Assist with writing manuscripts, project reports, and grant applications. Provide input to budgets for current and future projects.

Required Qualifications*
Bachelor's degree in Data Science, Computer Science, Epidemiology, Public Health or Related Equivalent Field, or an equivalent combination of education and experience required.
Extensive experience using SAS techniques to match-merge datasets with a one-to-many relationship and macro language or similar statistical programming experience required.
Experience working with specialized clinical health data and/or a strong interest in learning the basic terminology and processes of an Intensive Care Unit (ICU) required.
Experience in database design and development, including normalization and automated data quality assurance required.
Excellent project documentation skills required.
Excellent communication and interpersonal skills required.
Extensive experience in database management with progressive responsibility required.
Skills You Have
Required Technology Skills:

• Ability to set up computers, monitors, and peripheral devices, including keyboards, mice, and webcams.
• Ability to effectively utilize remote support resources.
• Remote computing support is available 24 hours a day, 7 days a week via phone, chat, or ticketing system.
• Employees are expected to communicate effectively and work directly with support resources to resolve most computing issues.

Desired Qualifications*

• Experience in analysis of clinical and/or administrative health data preferred.
• Experience in training and mentorship of junior colleagues preferred.
• Experience using Git-based version control systems preferred.

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 .
Work Locations
This position is eligible for remote work following completion of training and demonstrated achievement of performance expectations.

• High-speed internet service is required and is the responsibility of the employee.
• Occasional onsite attendance may be required for meetings, technology-related needs, or work that cannot be completed remotely.
• This position may require in-person attendance at out-of-state conferences and meetings.
• Workspace will be available at the business location when onsite work is necessary.
• While some flexibility in work hours is available, employees must maintain availability during Eastern Time Zone business hours to support meetings and collaboration, including video conferencing.
• The employer will provide computing resources, including required software applications, VPN access, desktop or laptop computer, monitor, webcam, keyboard, and mouse.
• Employees are not provided with a mobile phone but will have access to computer-based telephone and fax technology.
• Office furniture and equipment, including desks, chairs, and printers, are not provided.
• Basic office supplies, such as paper and pens, are available for pickup at the business location.
• Unless otherwise approved by a manager, additional hardware, software, printing expenses, and employee-preferred office supplies are the responsibility of the employee.

Additional Information
General supervision is received from the Co-Directors of M-CHORD, the Co-Directors of PC4 (currently external to UM), Principal Investigators, the Administrative Manager, and the Lead CNU Data Manager.
Background Screening
The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks. Background checks are performed in compliance with the Fair Credit Reporting Act.
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.
Job Detail
Job Opening ID
281771
Working Title
Senior Pediatric Cardiac Critical Care Consortium (PC4) Data Manager
Job Title
Database Analyst/Programmer Sr
Work Location
Ann Arbor Campus
Ann Arbor, MI
Modes of Work
Mobile/Remote
Full/Part Time
Full-Time
Regular/Temporary
Regular
FLSA Status
Exempt
Organizational Group
Medical School
Department
MM Pediatrics-Cardiology
Posting Begin/End Date
8/17/2026 - 8/31/2026
Career Interest
Information Technology