Data Engineer & Analytics Specialist

unc.edu

Chapel Hill (NC)

On-site

USD 92,000 - 95,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

University of North Carolina at Chapel Hill in Chapel Hill, NC, seeks a Data Engineer & Analytics Specialist to design, develop, and optimize data integration processes and database solutions that support public health research needs.

The role manages ETL workflows, builds database objects for web applications, and prepares analytical datasets for decision-making, partnering with researchers to advance data strategy and health initiatives.

Qualifications

  • Five years with SQL Server including views, stored procedures, and indexes.
  • Three years with secondary health data for public health surveillance (NEMSIS 3.3.4/3.5).
  • Three years with a public health syndromic surveillance system, and with ICD/XML/HL7.
  • Three years with PowerShell and ETL tooling.

Responsibilities

  • Design, develop, maintain, and optimize data integration processes and database solutions.
  • Manage ETL processes and data extraction, transformation, and loading.
  • Develop database objects for web applications.
  • Oversee data linkage initiatives.
  • Provide analytical datasets supporting public health research and decision-making.

Skills

SQL Server
NEMSIS 3.3.4
NEMSIS 3.5
Public health data
Syndromic surveillance
ICD
XML 1.0/1.1
HL7
PowerShell
SSIS
Data linkage methods
Interpersonal skills

Education

Master's or Bachelor's
0–2 years experience

Tools

SSIS
ETL tools

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Public Health Data Engineer & Analytics (Onsite)
Public Health Data Engineer & Analytics (Onsite)

unc.edu • Chapel Hill (NC)

On-site
USD 92,000 - 95,000
Public Health Data Engineer & Analytics Lead
Public Health Data Engineer & Analytics Lead

UNC-Chapel Hill • North Carolina

On-site
USD 90,000 - 130,000
Data Engineer & Analytics Specialist
Data Engineer & Analytics Specialist

UNC-Chapel Hill • North Carolina

On-site
USD 90,000 - 130,000
Senior Data Analyst
Senior Data Analyst

Dell Medical School • Austin (TX)

On-site
USD 81,000 - 99,000
Data Engineer II
Data Engineer II

Nicklaus Children's • Miami (FL)

On-site
USD 110,000 - 140,000
Developer ETL - Cloud Data Engineer - Level 2
Developer ETL - Cloud Data Engineer - Level 2

Duke Careers • Durham (NC)

On-site
USD 85,000 - 120,000
Senior Data Engineer
Senior Data Engineer

CHG Healthcare • Salt Lake City (UT)

On-site
USD 117,000 - 225,000
401(k) retirement plan
Medical and dental coverage
Onsite health centers
+1
Data Engineer
Data Engineer

Shirley Ryan AbilityLab • Chicago (IL)

On-site
USD 71,000 - 125,000
Benefits package
Senior Data Engineer
Senior Data Engineer

Moffitt Cancer Center • Tampa (FL)

On-site
USD 108,000 - 165,000
Research Project Manager
Research Project Manager

The University of North Carolina at Chapel Hill • North Carolina

On-site
USD 85,000 - 115,000