IT Analyst/Programmer - 2

The Department of Radiology, School of Medicine, University of North Carolina at Chapel Hill is seeking a Research Informatics Specialist who will join highly collaborative team of basic and clinical investigators to support clinical data-driven research in the Department of Radiology through services and tool development., * 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.

Be a Tar Heel!, 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. Required Qualifications, Competencies, and Experience

• 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 Qualifications, Competencies, 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)., + Master's degree or higher and 1-2 years of experience.

• Bachelor's degree and 2-4 years of experience.
• A combination of related education and experience.
• None of the above.

2. • Please describe your experience with data modeling and relational database systems such as Oracle, Microsoft SQL Server, MySQL, etc. (Open Ended Question)
3. • Please describe your experience using programs such as SAS, R, Python, or Java. (Open Ended Question)

A global higher education leader in innovative teaching, research and public service, the University of North Carolina at Chapel Hill consistently ranks as one of the nation's top public universities. Known for its beautiful campus, world-class medical care, commitment to the arts and top athletic programs, Carolina is an ideal place to teach, work and learn. One of the best college towns and best places to live in the United States, Chapel Hill has diverse social, cultural, recreation and professional opportunities that span the campus and community. University employees can choose from a wide range of professional training opportunities for career growth, skill development and lifelong learning and enjoy exclusive perks for numerous retail, restaurant and performing arts discounts, savings on local child care centers and special rates on select campus events. UNC-Chapel Hill offers full-time employees a comprehensive benefits package, paid leave, and a variety of health, life and retirement plans and additional programs that support a healthy work/life balance. Primary Purpose of Organizational Unit Our mission is to improve the health and well-being of North Carolinians and others whom we serve. We accomplish this by providing leadership and excellence in the interrelated areas of patient care, education and research.

Patient care: We promote health and provide superb clinical care while maintaining our strong tradition of reaching underserved populations and reducing health disparities across North Carolina and beyond.

Education: We prepare tomorrow's healthcare professionals and biomedical researchers from all backgrounds by facilitating learning within innovative and integrated curricula and team-oriented interprofessional education to ensure a highly skilled workforce.

Research: We develop and support a rich array of outstanding health sciences research programs, centers and resources. We provide infrastructure and opportunities for collaboration among disciplines throughout and beyond our university to support outstanding research. We foster programs in the areas of basic, translational, mechanistic and population research.