IT Analyst/Programmer - 2

🇺🇸 Chapel Hill, NC

🕑 Full-Time

💰 TBD

💻 Information Technology

🗓️ November 19th, 2025

ETL IRB MySQL

Edtech.com's Summary

University of North Carolina at Chapel Hill is hiring an IT Analyst/Programmer - 2. The role involves performing SQL programming on UNC's clinical data warehouse to identify patient cohorts and develop datasets, collaborating with researchers to ensure programming aligns with project needs, and developing ETL and data integration processes using SQL, Python, or R while adhering to regulatory policies.

Highlights

Perform SQL-based programming to query clinical data warehouse and develop patient datasets.
Consult and collaborate with researchers to align programming with project requirements.
Develop ETL and data integration pipelines supporting common data models such as OMOP and PCORnet.
Ensure data integrity and security by following UNC's regulatory and governance policies.
Work with Radiology faculty on data retrieval for IRB-approved projects.
Expertise in SQL programming and knowledge of relational database systems like Oracle, Microsoft SQL Server, and MySQL required.
Preferred skills include SAS, R, Python, or Java, and familiarity with Epic Clarity, OMOP, PCORnet, i2b2, or FHIR.
Experience with software development lifecycle best practices such as quality assurance testing, Git, and SDLC is favored.
Minimum qualifications: Master's degree with 1-2 years' experience or Bachelor's with 2-4 years of related experience.
Position is full-time, permanent staff in the Department of Radiology, School of Medicine.