SQL / ETL Developer

Monday - Friday (8:00 AM - 5:00 PM)

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.

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.

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.

Essential Duties and 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

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

* Experience working with SQL Server in a database development, DBA support, or ETL-focused role.
* Experience supporting SQL Server Integration Services ( SSIS) packages.
* Experience with Informatica ( IICS) or another enterprise ETL platform.
* Experience with SQL Server performance tuning and troubleshooting.
* Familiarity with higher education, healthcare, or enterprise data environments.

If you experience any problems accessing the system or have questions about the application process, please contact the Office of Human Resources at (919) 843-2300 or send an email to employment@unc.edu

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

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.