Data Engineer & Analytics Specialist
Job Description
The University of North Carolina at Chapel Hill is seeking a Data Engineer & Analytics Specialist to design, develop, maintain, and optimize data integration processes and database solutions that support organizational data needs. This onsite role in Chapel Hill focuses on ETL management, building database objects for web applications, supporting data linkage initiatives, and delivering analytical datasets for public health research and operational decision-making.
Reporting to internal stakeholders and working alongside researchers, you will help advance the organization’s data strategy by turning complex health data and standards into reliable datasets that can be used for public health initiatives.
Key Responsibilities
- Design, develop, maintain, and optimize data integration processes and database solutions to support organizational data needs.
- Manage data extraction, transformation, and loading (ETL) processes.
- Develop database objects for web applications.
- Oversee data linkage initiatives.
- Provide analytical datasets that support public health research and operational decision-making.
- Collaborate with internal stakeholders and researchers to advance the organization’s data strategy and support key public health initiatives.
Required Qualifications
- At least five years of experience with SQL Server, including development of views, stored procedures, tables, full-text indexes, and other database objects.
- At least three years of experience working with secondary health data for public health surveillance, including NEMSIS 3.3.4 and/or NEMSIS 3.5.
- At least three years of experience working with a public health syndromic surveillance system.
- At least three years of experience with other data and messaging standards such as ICD, XML 1.0/1.1, and/or HL7.
- At least three years of experience with PowerShell.
- At least two years of experience working with ETL tools such as SSIS.
- At least two years of experience developing source-specific data linkage methods.
- Strong interpersonal skills and experience working with public health data users.
Preferred Qualifications
- Experience with Python, R, C#, and/or SAS.
Education and Experience
- Master’s or Bachelor’s and 0-2 years’ experience; or the university will accept a combination of related education and experience in substitution.
Technology Stack
- SQL Server, NEMSIS 3.3.4, NEMSIS 3.5, ICD, XML 1.0, XML 1.1, HL7, PowerShell, ETL, SSIS, Python, R, C#, SAS
Location: Chapel Hill, NC, US (onsite). Compensation: USD 91,500 - 95,000 per year. Experience Level: 5+ years.