Data Engineer

UNC; Chapel Hill (NC); On-site; USD 60,000 - 90,000; Part time

Job summary

Talentify is seeking a temporary data engineering professional in Chapel Hill to support data integration, modeling, and BI initiatives. The role emphasizes building reliable data pipelines and Power BI solutions on SQL Server and Azure-based platforms such as Microsoft Fabric or Azure Databricks.

The candidate will develop and optimize SQL queries, validate data quality, and assist with ETL processes across multiple source systems, contributing to curated data layers and semantic models for

Qualifications

• Experience building and optimizing SQL Server queries, views, and procedures.
• Experience with data validation and quality checks across data layers.
• Experience with ETL tools (Informatica IICS or SSIS).

Responsibilities

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures.
• Perform data validation, reconciliation, 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, maintain, and support Power BI reports, dashboards, and data models.
• Work with lakehouse architecture patterns to support reporting datasets.
• Prepare and maintain documentation for data pipelines and mappings.

Skills

SQL Server

Power BI

Data modeling

ETL development

Azure Databricks

Microsoft Fabric

DAX/Power Query

Tools

Informatica IICS

SSIS

Azure data platforms

Job description

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.