Data Engineer

Posting Information

Department

Information Technology-SOM - 420401

Career Area

Information Technology

Posting Open Date

10/07/2026

Application Deadline

10/21/2026

Position Type

Temporary Staff (SHRA)

Position Title

Data Engineer

Position Number

20075448

Vacancy ID

S028125

Full-time/Part-time

Full-Time Temporary

Hours per week

40

Work Schedule

Position Location

North Carolina, US

Hiring Range

$45.00 - $50.00 per hour

Proposed Start Date

Estimated Duration of Appointment

6 months or longer

Position Information

Be a Tar Heel!

A global higher education leader in innovative teaching, research and public service, the University of North Carolina at Chapel Hill consistently ranks as one of the nation’s top public universities. Known for its beautiful campus, world-class medical care, commitment to the arts and top athletic programs, Carolina is an ideal place to teach, work and learn.

One of the best college towns and best places to live in the United States, Chapel Hill has diverse social, cultural, recreation and professional opportunities that span the campus and community.

University employees can choose from a wide range of professional training opportunities for career growth, skill development and lifelong learning and enjoy exclusive perks that include numerous retail and restaurant discounts, savings on local child care centers and special rates for performing arts events.

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

Special Physical/Mental Requirements

Campus Security Authority Responsibilities

Not Applicable.