UTS- Database Data Analyst at UNC Chapel Hill

North Carolina State University

$43.50 / hr

United States, North Carolina, Chapel Hill

1100 Bioinformatics Building (Show on map)

Mar 20, 2025

Position Information

Posting Number	PG195009TM
Position Number	48SM51
Position Type	Temporary
Essential Job Duties	The primary purpose of this position is to work with snapshot and operational data sources to develop and maintain data objects that address key business area questions. The role involves developing and maintaining ETL operations using DI Studio, ensuring smooth data extraction, transformation, and loading processes. This position requires investigating and correcting database object errors or failures to ensure data integrity and reliability. Additionally, the individual will translate UNC-SO SAS code into replicable database objects for further exploration and analysis. The position also involves collaborating with the team to ensure that critical operational University data from sources such as PeopleSoft and Slate are available in the data warehouse for Institutional Research (IR) use. The candidate will need to be in the office 1-2 days/week as needed and may work remotely the other days.
Is Time Limited	Yes
If Yes, Appointment Length	2 months

Department Information

Job City & State	Chapel Hill, NC
Department

System Information

Classification Title	Temporary-Technical/Paraprofessional
Working Title	UTS- Database Data Analyst at UNC Chapel Hill

Requirements and Preferences

Work Schedule	Monday - Friday 9 am - 6 pm (flexible hours)
Other Work/Responsibilities	This position reports to Institutional Research and Assessment (IRA) in support of its data preparation mission. IRA is not an Information Technology shop. Our office does not administer the database software or servers, nor do we manage database security. Instead, we build, debug, edit, and optimize data objects within our Oracle database schema to enhance the office's reporting capabilities. This position *requires* experience and skills with these data preparation activities. -Working with snapshot and operational data sources to develop data objects that address business area questions -Developing and maintaining ETL operations (via DI Studio at the moment) -Investigating and correcting database object errors and/or failures -Translating UNC-SO SAS code into replicable database objects for further exploration. -Work with the ITS to ensure that needed operational University data from various sources, including PeopleSoft and Slate, are available in the warehouse for IR use
Minimum Experience/Education	Minimum Years of Experience: 4
Department Required Skills	Data Analysis Database development Views Tables Materialized views Constraints Indexes Comments Scheduling DI Studio ETL Debug Create SAS
Preferred Years Experience, Skills, Training, Education	Minimum Years of Experience: 4 Work with snapshot and operational data sources to develop data objects that address business area questions. Develop and maintain ETL operations using DI Studio. Investigate and correct database object errors and/or failures to ensure data accuracy and reliability. Translate UNC-SO SAS code into replicable database objects for further exploration and analysis. Collaborate with the department to ensure that necessary operational University data from various sources, including PeopleSoft and Slate, are available in the data warehouse for Institutional Research (IR) use.
Required License or Certification	N/A
Valid NC Driver's License required?	No
Commercial Driver's License Required?	No

Recruitment Details

Anticipated Hiring Range	$43.50/hourly

Recruitment Dates

Job Open Date	03/20/2025

Applicant Information

Quick Link

https://jobs.ncsu.edu/postings/216286

AA/EEO

NC State University is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, gender identity, age, sexual orientation, genetic information, status as an individual with a disability, or status as a protected veteran.

If you have general questions about the application process, you may contact Human Resources at (919) 515-2135 or workatncstate@ncsu.edu. Individuals with disabilities requiring disability-related accommodations in the application and interview process, please call 919-515-3148.

Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks. If highest degree is from an institution outside of the U.S., final candidates are required to have their degree equivalency verified at www.wes.org or equivalent service. Degree(s) must be obtained prior to start date in order to meet qualifications and receive credit.

NC State University participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.