Job Summary:
The University of North Carolina at Chapel Hill is a global leader in higher education known for innovative teaching and research. The IT Analyst/Programmer - 2 will support clinical data-driven research in the Department of Radiology by performing SQL-based programming and developing data integration processes.
Responsibilities:
• 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.
Qualifications:
Required:
• Master’s and 1-2 years’ experience; or Bachelors and 2-4 years’ experience; or will accept a combination of related education and experience in substitution.
• 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.
Preferred:
• 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).
Company:
Carolina’s vibrant people and programs attest to the University’s long-standing place among leaders in higher education since it was chartered in 1789 and opened its doors for students in 1795 as the nation’s first public university. Founded in 1919, the company is headquartered in Chapel Hill, USA, with a team of 10001+ employees. The company is currently Late Stage.