Data Engineer

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

Job summary

University of North Carolina at Chapel Hill seeks a Data Engineer to support data engineering, integration, modeling and BI efforts. The role focuses on pipelines, curated data layers and Power BI across SQL Server and Azure-based platforms.

The temporary position emphasizes building reliable data workflows, documenting data mappings, and collaborating with senior technical staff in a fast-paced, academic environment.

Qualifications

• Bachelor's degree in computer science or related field; or equivalent combination of education and experience.
• Associate's degree in IT/Networking with relevant experience; journey/advanced levels require additional education/experience.

Responsibilities

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures.
• Assist with ETL processes using Informatica (IICS), SSIS, or similar tools.
• Develop and support Power BI reports, dashboards, and data models.

Skills

Data engineering

ETL/ELT development

Data integration

Data modeling

Business intelligence

SQL Server

Power BI

Azure Databricks

Informatica (IICS)

SSIS

Microsoft Fabric

Education

Bachelor's degree in Computer Science

Associate's degree in Computer Information Technology

Tools

Informatica (IICS)

SSIS

Power BI

Microsoft Fabric

Azure Databricks

SQL Server

Job description

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
• Position Location: North Carolina, US
• Hiring Range: $45.00 - $50.00 per hour
• Estimated Duration of Appointment: 6 months or longer

Position Information

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

Campus Security Authority Responsibilities

Not Applicable.

Temporary Employment Policies

Temporary Employment Policies

Posting Contact Information

If you experience any problems accessing the system or have questions about the application process, please contact the Office of Human Resources at [phone] or send an email to [e-mail]

Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status.

Quick Link

https://unc.peopleadmin.com/postings/326577

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.