Data Engineer & Analytics Specialist
Job Description
The University of North Carolina at Chapel Hill is seeking a Data Engineer & Analytics Specialist in Chapel Hill, NC. This onsite role focuses on designing, developing, and optimizing data integration processes and database solutions that support organizational and public health research needs.
Role Overview
This position manages ETL workflows, builds database objects used by web applications, and supports data linkage initiatives. The specialist also prepares analytical datasets for public health research and operational decision-making, partnering with internal stakeholders and researchers to advance the organization’s data strategy and public health initiatives.
Key Responsibilities
- Design, develop, maintain, and optimize data integration processes and database solutions to meet organizational data needs.
- Manage data extraction, transformation, and loading (ETL) processes.
- Develop database objects for web applications.
- Oversee data linkage initiatives.
- Provide analytical datasets supporting public health research and operational decision-making.
- Collaborate with internal stakeholders and researchers to support data strategy and 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 emergency medical services data.
- 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 using 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.
Minimum Education and Experience
- Master’s or Bachelor’s and 0–2 years’ experience; the role also accepts a combination of related education and experience in substitution.
Preferred Qualifications
- Experience with Python, R, C#, and/or SAS.
Technologies
- 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 and Compensation
- Location: Chapel Hill, NC, US (onsite)
- Salary: USD 91,500 - 95,000 per year
Campus Security Authority
Not applicable.
Similar Jobs
U