Clinical Data Analyst

Responsibilities

• Perform deep-dive clinical data abstraction from the Epic EMR for neonatal patients, interpreting clinical notes, lab results, imaging, and flowsheets.
• Leverage Epic tools, including Smart Data Elements and SmartForms, to extract targeted clinical variables.
• Translate complex NICU clinical scenarios into standardized data points aligned with Vermont Oxford Network (VON) definitions.
• Collaborate with the Clinical Data Navigator to design workflows for data extraction from Epic to REDCap.
• Assist in the structural mapping and design of the REDCap database to ensure correct field mapping.
• Perform routine data quality checks and cleaning within the REDCap environment to ensure accuracy for VON reporting.
• Maintain strict adherence to HIPAA guidelines and institutional data security protocols.

Requirements

• Bachelor's degree or equivalent in education and experience.
• At least three years of related professional experience.
• High-level proficiency navigating the Epic EMR, specifically with Smart Data Elements and clinical flowsheets.
• Demonstrated proficiency in writing, optimizing, and troubleshooting SQL queries in a relational database environment.
• Strong attention to detail and the ability to independently interpret complex medical documentation.

Preferred Qualifications

• RN, NNP, or equivalent clinical degree with recent direct clinical experience in a Level III or Level IV NICU.
• Prior experience working with the Vermont Oxford Network (VON) database and data definitions.
• Experience building, managing, or entering data into REDCap databases.
• Background or certification in Nursing Informatics or Clinical Informatics.
• Experience with other scripting languages for data analysis.

Benefits

• Comprehensive Health and Welfare programs.
• Employee Assistance programs.
• Tuition assistance programs.
• Retirement benefits.
• Flexible and hybrid work arrangements may be supported subject to business needs.

About the Company

Columbia University Medical Center is a leader in teaching, research, and patient care. We are committed to fostering an inclusive, thriving community and providing exceptional service and support to our employees and the community we serve.