Employment Type: Permanent Staff (EHRA NF)

Vacancy ID: NF0009396

Position Summary/Description:

• Perform SQL-based programming against UNC's clinical data warehouse to identify patient cohorts and develop patient datasets.
• Consult with and collaborate with researchers to ensure programming work aligns with project needs.
• Develop ETL (extract, transform, and load) and data integration processes to support common data models (OMOP, PCORnet) using appropriate technologies (SQL, Python, or R).
• Carefully following UNC's regulatory and governance policy to ensure data integrity and security.
• Working with Radiology faculty to retrieve data from the UNC's clinical data warehouse for IRB approved projects.

Education and Experience:

• Additional programming competencies outside of SQL, such as SAS, R, Python, or Java.
• Demonstrable understanding of regulations around clinical data used for research purposes, particularly HIPAA and Institutional Review Board rules.
• Experience working with faculty in an academic research environment.
• Experience working with Epic Clarity, OMOP, PCORnet Common Data Model, i2b2, or FHIR.
• Experience executing projects in alignment with software development/programming best practice: quality assurance testing, Git, SDLC (software development lifecycle).

Essential Skills:

• Expert-level knowledge of SQL programming, data modeling, and relational database systems such as Oracle, Microsoft SQL Server, MySQL, etc.
• Individual will be expected to manage multiple projects at once while delivering high-quality work on time.
• Excellent written and oral communication skills; the ability to clearly convey technical concepts to non-technical clients is essential.

AA/EEO Statement:

About The University of North Carolina at Chapel Hill

Carolina rates among the nation’s great institutions of higher education, set on an historic and beautiful campus that celebrates all four seasons. Carolina’s students, faculty and staff come here from around the world, bringing varied cultural, racial and ethnic heritages that help make UNC-Chapel Hill a thriving intellectual center. We’re repeatedly ranked the nation’s best value in higher education for students seeking to earn a college degree – the University has garnered the top spot each time since the ranking’s launch in 1998.Whether you’ve just started your career, are new to academia or are a seasoned professional with assorted campus experiences to draw on, we hope you will find a great place at Carolina.

Connections working at The University of North Carolina at Chapel Hill