University of North Carolina at Chapel Hill logo

University of North Carolina at Chapel Hill

IT Analyst/Programmer - 2

🇺🇸 Chapel Hill, NC 🕑 Full-Time 💰 TBD 💻 Information Technology 🗓️ June 22nd, 2026
ETL IRB MySQL

Edtech.com's Summary

University of North Carolina at Chapel Hill is hiring an IT Analyst/Programmer - 2 to support clinical data-driven research in the Department of Radiology. The role requires performing SQL programming, developing ETL and data integration processes, collaborating with researchers, and ensuring compliance with data governance policies.

Highlights
  • Perform SQL-based programming on UNC's clinical data warehouse to identify patient cohorts and build datasets.
  • Consult and collaborate with researchers to align programming with project requirements.
  • Develop ETL and data integration processes supporting common data models such as OMOP and PCORnet using SQL, Python, or R.
  • Ensure data integrity and security by following UNC's regulatory and governance policies.
  • Retrieve clinical data for IRB-approved projects in coordination with Radiology faculty.
  • Expert knowledge of SQL programming and relational database systems like Oracle, Microsoft SQL Server, and MySQL is required.
  • Preferred skills include programming in SAS, R, Python, or Java, experience with Epic Clarity, OMOP, PCORnet, i2b2, or FHIR, and understanding of HIPAA and IRB regulations.
  • Must have excellent communication skills to explain technical concepts to non-technical clients.
  • Minimum qualification is a Master's degree with 1-2 years of experience or Bachelor's degree with 2-4 years of experience, or an equivalent combination of education and experience.
  • Position is full-time permanent staff in the Department of Radiology, School of Medicine.