SQL / ETL Developer

UNC-Chapel Hill • Chapel Hill, NC

3d

About The Position

This temporary position provides short-term support for SQL Server database operations, data integration, and reporting activities within the School of Medicine Information Technology department. The role focuses on operational support of existing systems, including SQL development, SQL Server Agent jobs, SSIS packages, and ETL processes, to ensure continuity of data services.

Responsibilities

• Develop, maintain, and optimize SQL Server queries, views, functions, and stored procedures in support of operational and reporting needs.
• Monitor and support SQL Server Agent jobs, including reviewing job status, troubleshooting failures, and validating scheduled executions.
• Support SQL Server Integration Services ( SSIS ) packages by monitoring data loads, validating data movement, and assisting with issue resolution.
• Perform routine data and database checks to support data quality, integrity, and performance.
• 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.
• Assist with query performance tuning and indexing activities under the guidance of senior technical staff.
• Support operational and ad hoc reporting requests using SQL Server and approved reporting tools.
• Prepare and maintain documentation related to database objects, scheduled jobs, and data processes

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed