Data Engineer

PeopleAdmin, Inc.; Chapel Hill (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

The University of North Carolina at Chapel Hill, School of Medicine IT, seeks a data engineer to build and support data pipelines, data models, and Power BI assets using SQL Server and Azure platforms. You will ensure data quality and enable reliable reporting across clinical and research domains.

You will collaborate on lakehouse architectures (Bronze/Silver/Gold), implement DAX measures, and optimize queries, with opportunities to grow in a university setting emphasizing health and education

Qualifications

• Bachelor’s degree in computer science, CIS, or closely related field; or a BA with one year of relevant experience.
• Associate’s degree in IT/Networking with two years of experience; journey level requires one additional year; advanced level two more years.

Responsibilities

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures for operations and reporting.
• Perform data validation and quality checks across source, transformation, and curated data layers.
• Assist with ETL processes using Informatica (IICS), SSIS, or comparable tools.
• Support integration of data from multiple sources into SQL Server environments.
• Develop and maintain Power BI reports, dashboards, and semantic models; manage data refresh processes.

Skills

Data engineering

ETL/ELT development

SQL Server

Power BI

Azure Databricks

Informatica IICS

SSIS

Data modeling

DAX measures

Data validation

Education

Bachelor’s degree in Computer Science/related field

One year of operations/systems experience (or related)

Associate’s degree in IT/Networking with two years of experience

Tools

Informatica (IICS)

SSIS

SQL Server

Microsoft Fabric

Azure Databricks

Job description

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.

Position Summary

This temporary position provides short-term support for data engineering, data integration, data modeling, and business intelligence activities within the School of Medicine Information Technology department. The role focuses on developing and supporting reliable data pipelines, curated data layers, and Power BI solutions using SQL Server and Azure-based data platforms such as Microsoft Fabric or Azure Databricks.

Essential Duties and Responsibilities:

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures in support of operational and reporting needs.
• Perform data validation, reconciliation, and quality checks across source, transformation, and curated data layers.
• Assist with data extraction, transformation, and loading ( ETL ) processes using Informatica ( IICS ), SSIS , or comparable ETL tools.
• Support integration of data from multiple source systems into SQL Server environments.
• Optimize SQL queries, transformations, data pipelines, and reporting datasets under the guidance of senior technical staff.
• Develop, maintain, and support Power BI reports, dashboards, semantic models, and data refresh processes using approved reporting and analytics tools.
• Support data ingestion and transformation workflows that prepare curated data for Power BI reporting using Azure-based platforms, including Microsoft Fabric or Azure Databricks.
• Work with lakehouse and medallion architecture patterns, including Bronze, Silver, and Gold data layers, to support reliable and reusable reporting datasets.
• Assist with Power BI data modeling, DAX measures, Power Query transformations, row-level security, refresh troubleshooting, and report performance optimization.
• Prepare and maintain documentation for source-to-target mappings, data pipelines, transformation logic, curated datasets, semantic models, and scheduled processes.

Minimum Education and Experience Requirements

Bachelor’s degree in computer science, Computer Information Systems, computer science engineering or a closely related degree from an appropriately accredited institution; or a Bachelor’s degree from an appropriately accredited institution and one year of experience in operations/systems work or closely related area; or an

• Associate’s degree in Computer Information Technology, Computer Engineering Technology or Networking Technology from an appropriately accredited institution and two years of experience in operations/systems work or closely related area; or an equivalent combination of education and experience.
• Journey level requires an additional one year of education or experience.
• Advanced level requires an additional two years of education or experience

Management Preferences

• Experience in data engineering, ETL / ELT development, data integration, or analytics engineering using SQL Server or cloud-based data platforms
• Experience supporting SQL Server Integration Services ( SSIS ) packages
• Experience with Informatica ( IICS ) or another enterprise ETL platform
• Experience optimizing SQL queries, data pipelines, semantic models, or reporting datasets for performance and reliability
• Familiarity with higher education, healthcare, or enterprise data environments

Equal Opportunity Employer Statement

The University is an equal opportunity employer and welcomes all to apply without regard to age, color, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, or sexual orientation. We encourage all qualified applicants to apply, including protected veterans and individuals with disabilities.

Optional and Required Documents

Required Documents

• Curriculum Vitae / Resume

Optional Documents

Supplemental Questions

Required fields are indicated with an asterisk (*).