Data Engineer

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.

• 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.