Data Engineer

University of North Carolina at Chapel Hill; Chapel Hill (NC); On-site; USD 62,000 - 69,000; Full time

Job summary

University of North Carolina at Chapel Hill is seeking a Data Engineer for a temporary role in the School of Medicine Information Technology department. You will support data integration, data modeling, and business intelligence work, building reliable data pipelines and curated data layers using SQL Server and Azure platforms such as Microsoft Fabric or Azure Databricks.

The role focuses on developing and optimizing queries, validating data quality, and delivering Power BI reports and

Qualifications

• Bachelor's degree in Computer Science or related field or equivalent education and experience.
• Experience building reliable data pipelines and BI solutions.
• Strong SQL Server knowledge including queries, views, functions, and stored procedures.
• ETL development using Informatica IICS, SSIS, or equivalent tools.
• Data quality validation across source, transformation, and curated layers.
• Experience creating Power BI reports, dashboards, and semantic models.

Responsibilities

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures for operational and reporting needs.
• Validate, reconcile, and quality-check data across source, transformation, and curated layers.
• Build ETL processes using Informatica IICS, SSIS, or comparable tools.
• Integrate data from multiple source systems into SQL Server environments.
• Create and support Power BI reports, dashboards, semantic models, and data refresh processes.
• Document source-to-target mappings, pipelines, transformation logic, and semantic models.

Skills

Data integration

Data modeling

Power BI

SQL Server

Informatica IICS

SSIS

Azure Databricks

Lakehouse architecture

DAX

Power Query

Education

Bachelor's degree in CS or related field

Tools

SQL Server

Informatica IICS

SSIS

Power BI

Azure Databricks

Microsoft Fabric

Job description

University of North Carolina at Chapel Hill is hiring a Data Engineer for a temporary role in the School of Medicine Information Technology department. The engineer supports data integration, data modeling, and business intelligence work. The focus is reliable data pipelines, curated data layers, and Power BI solutions built on SQL Server and Azure data platforms such as Microsoft Fabric or Azure Databricks.

Highlights

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures for operational and reporting needs.
• Validate, reconcile, and quality-check data across source, transformation, and curated layers.
• Build ETL processes using Informatica (IICS), SSIS, or comparable tools.
• Integrate data from multiple source systems into SQL Server environments.
• Create and support Power BI reports, dashboards, semantic models, and data refresh processes.
• Work with lakehouse and medallion architecture patterns, with Bronze, Silver, and Gold data layers.
• Assist with Power BI data modeling, DAX measures, Power Query, row-level security, and report performance.
• Document source-to-target mappings, pipelines, transformation logic, and semantic models.
• Bring a bachelor's degree in computer science or a related field, or an equivalent education and experience combination.
• Pay is $45 to $50 per hour in a full-time temporary appointment of 6 months or longer.