Job Details

IT Analyst III: Office of Innovative Technologies - UTK

Position Number: 6246962
Location: Chattanooga, TN
Position Type: Computing - Database Administration

IT Analyst III: Office of Innovative Technologies - UTK
Knoxville, TN, United States

Job Identification: 3101
Job Category: Info Technology
Posting Date: 05/22/2025
Job Schedule: Full Time
Locations: 2309 Kingston Pike, Knoxville, TN, 37996, US (Hybrid)

Job Description
The University of Tennessee, Office of Information Technology Applications group is seeking to hire an IT Analyst III to support the Information Management and Analytics team.

As an IT Analyst III, you will be a key member in supporting the University's Banner/ODS and IDS (Institutional Data Set) applications. You will work independently and as part of a team on one or more projects, as directed, to achieve the organization's objectives and to provide exceptional support to our customers at the University. You will be expected to contribute technically to the analysis, design, development, testing, integration, and documentation of complex software solutions. As a member of this team, you may also be involved with the administration of some tools/systems. This position will report to the OIT Manager, Information Management and Analytics. This position is currently working on a hybrid work schedule (subject to change).

Responsibilities

Assists and/or leads analysis and helps with problem solving efforts.
Create new and modify existing database objects, analyze queries and perform tuning.
Create packages, stored procedures, tables views, etc. to extract, transfer and load data into the campus data warehouse, SAS, and data marts from Oracle and SQL Server.
Design/Develop new programs/subsystems as directed by management within the parameters of UT standards and OIT group standards. This can include but is not limited to views, tables, programs, systems, data bases, security and complex sql code.
Use PowerBI, Argos, SAS Visual Analytics or other reporting tools to modify existing and create new dashboards and reports.
Assists in setting direction for the growth and maintenance of the campus data warehouse.
Assists with developing procedures for loading data from enterprise systems into the campus data warehouse.
Provide technical guidance and assistance to other staff members in group, department, and campus user community.
Work with relational databases (Microsoft SQL Server and Oracle):
- Write queries and scripts as needed.
- Work with internal partners, providing assistance as needed.
- Participate in upgrade/migration projects as needed.
- Work directly with DBAs as needed to troubleshoot database/script/connectivity issues.
Develop and implement changes and/or maintenance to existing systems/reports supported by my team.

Qualifications
Required Qualifications

Bachelor's Degree in Computer Science or related field or equivalent experience
Three years of application development, SQL, or PL/SQL experience
Significant Relational Database experience
Strong skills in Data Analysis, Database Design, writing complex SQL, and query performance tuning
Proficiency in Power BI Desktop, Power Query, DAX, Tabular Editor, and DAX Studio
Proficiency with the Power BI Service, including workspace management, dataset scheduling, dataflows & datasets, and sharing reports with stakeholders
Ability to work independently, within a team, and/or as an effective team lead to achieve results and meet deadlines
Ability to apply effective oral and written skills to communicate with users and technical audiences

Applicants must be legally authorized to work in the United States on a full-time basis without need now or in the future for sponsorship for employment visa status

Preferred Qualifications

Experience with Oracle 12c or higher
Experience with PL/SQL and/or SQL Developer and/or TOAD
Experience with formal Source control
Experience with Ellucian Banner/ODS
Experience with Evisions Argos report development tool
Experience working in a Higher Education environment

Work Location This position is at the UT Knoxville campus. This is currently a hybrid job with one day a week of working at the office. Fully remote would be considered for the candidate with the most desirable skill set.

Compensation and Benefits

The position is a MR14: $72,390.56 - $101,346.78
Find more information on UT Benefits here

Application Instructions

To express interest, please submit an application with the noted below attachments. To be assured of full consideration, completed applications with all requested materials should be submitted on or before June 3, 2025

Resume
Cover Letter
List of 3 Professional References

About The Department

IM&A manages and maintains the data warehouse - Institutional Data Set (IDS). This includes daily data loads from Banner, Slate, DASH, and other data sources. We create and maintain college-level data marts in SQL Server, 14^th Day and End of Term Data Freezes for IRSA, and we are responsible for "point-in-time" reporting, such as First Day of Classes, 14^th day, Grades, End-of-Term, THEC reporting and staging tables, ad hoc reporting as requested by our campus partners, and dashboards (HR, GR Blueprint, EM). We administer and maintain Evisions software and servers: MAPS/Argos/IntelleCheck/FormFusion and SAS Visual Analytics environment (end user facing) including associated security (in Active Directory). IM&A administers and maintains the Data Cookbook. We also are responsible for several processes and data loads in SQL Server, including the student data load for Gallagher Security.

About Us
The University of Tennessee, Knoxville, has shaped leaders, changemakers, and innovative thinkers since its founding in 1794. The university is home to more than 38,000 students and 10,000 statewide employees-the Volunteers-who uphold the university's tradition of lighting the way for others through leadership and service.

UT Knoxville offers over 900 programs of study across 14 degree-granting colleges and schools. As Tennessee's flagship land-grant university, its footprint spans the entire state. The university holds the highest Carnegie classification for research activity and has deep partnerships with industry leaders and the US Department of Energy's largest multidisciplinary laboratory, Oak Ridge National Laboratory.

The Knoxville campus serves and recruits for UT Knoxville, including the Institute of Agriculture and the Space Institute, as well as the UT Institute of Public Service.

UT Knoxville considers its employees its number one asset. With values that focus on work-life balance, compensation, and innovation leadership, all Vols are supported to advance professionally. Employees have access to career development and coaching, continued education, and an extensive list of development and training possibilities. The Volunteer employee experience implements structures and practices that attract and retain a diverse community and that support a culture where everyone matters and belongs.

The university holds a strong commitment to its land-grant mission of learning and engagement, with a tradition of service and leadership that carries that Volunteer spirit throughout the state and around the world. It has been ranked nationally as "Best Employer for New Graduates," "One of America's Best Large Employers," and "Best Workplace for Women," and has been designated as "Best Place for Working Parents" by Forbes Magazine.

Apply today and join the Tennessee Volunteer community!

To apply, visit https://fa-ewlq-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/3101/?mode=location