Research Informatics Specialist

• 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.
• In collaboration with IDSci team, identify potential enhancements in current workflows and data architecture.
• Implement quality assurance strategies, such as data validation and peer code review.
• Write and maintain up-to-date supporting documentation. Ensure code is well-commented and use GitLab/GitHub to manage code changes and track data lineage.
• Provide technical leadership and direction for assigned projects and/or data requests.

• Expert-level knowledge of SQL programming, data modeling, and relational database systems such as Oracle, Microsoft SQL Server, MySQL, etc.
• Past experience working with health care data in an analytic capacity, particularly electronic health record and/or claims data.
• Demonstrable past experience in scoping technical projects in terms of length of time, competencies and cost. Individual will be expected to manage multiple projects at once while delivering high-quality work on time.
• Excellent written and oral business communication skills. Public speaking at meetings and conferences may be required. The ability to clearly convey technical concepts to non-technical clients is a must.

• 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
• Knowledge of health care vocabularies (ICD, CPT, RxNorm, etc.)
• Experience executing projects in alignment with software development/programming best practice: quality assurance testing, Git, SDLC (software development lifecycle)
• Experience working with non-EHR data sources like wearable device data or claims, etc

Not Applicable.