Data Developer II - Academic Affairs, Research and Student Success, UT System Administration

University of Tennessee System

Knoxville (TN)

On-site

USD 75,000 - 85,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Healthcare benefits
Tuition assistance
Professional development opportunities
Retirement benefits

Job summary

The University of Tennessee System is seeking a data and analytics professional to design, maintain, and optimize data systems, processes, and BI solutions across multiple SQL Server environments.

The role focuses on refining SQL and Python workflows, building reliable data assets for reporting, and expanding Power BI dashboards and semantic models to deliver clear insights to leadership and campus stakeholders.

Qualifications

  • Bachelor's degree and 4–6 years of programming and database experience.
  • Strong knowledge of SQL, Python, and data warehousing concepts.
  • Experience building Power BI reports, semantic models, and DAX measures.

Responsibilities

  • Develop, maintain, and optimize SQL queries, stored procedures, tables, views, and data pipelines supporting institutional reporting and analytics.
  • Develop, maintain, and enhance Power BI dashboards, reports, datasets, and semantic models for leadership and campus stakeholders.
  • Implement data validation, error-checking, reconciliation, and troubleshooting processes; develop Python scripts for ETL/ELT workflows.

Skills

SQL
Python
Power BI
Data analytics
ETL/ELT
DAX
Tableau

Education

Bachelor's degree in related field
Master's degree (preferred)

Tools

SSIS
Tableau
Power BI

Job description

Job Description

Supports the UT System by designing, maintaining, and optimizing data systems, processes, and business intelligence solutions. This position develops and refines SQL and Python based data workflows; maintains data quality, consistency, and performance across multiple SQL Server environments; and produces reliable data assets for institutional reporting and analysis. The role also develops, enhances, and updates Power BI dashboards, semantic models, and visualizations that provide leadership and campus stakeholders with clear, actionable insights. The position collaborates closely with Institutional Research departments and technology partners to improve reporting processes, troubleshoot existing tools, and support evolving data and decision-support needs.

Responsibilities
  • Develop, maintain, and optimize SQL queries, stored procedures, tables, views, and data pipelines supporting institutional reporting and analytics. Maintain data and schema consistency across SQL Server environments. Refactor complex scripts and processes to improve performance, reliability, and processing time. Develop ad hoc queries and reusable data assets to meet operational and reporting needs.
  • Develop, maintain, and enhance Power BI dashboards, reports, datasets, and semantic models. Translate institutional data into clear, accurate, and polished visualization tools for leadership and campus stakeholders. Improve report usability, performance, accessibility, consistency, and documentation. Support analysis and reporting using Power BI, Tableau, and related tools as needed.
  • Implement and modify systematic data validation, error-checking, reconciliation, and troubleshooting processes to support reliable reporting. Develop and maintain Python scripts and automated workflows used in data extraction, transformation, loading, and reporting processes. Maintain and enhance existing web-based applications, scripts, and legacy platforms that support institutional data and reporting functions.
  • Collaborate with System staff, campus partners, and technology teams to define data requirements and deliver effective reporting solutions. Document data sources, business rules, workflows, and technical processes. Identify opportunities to improve data governance, reporting processes, system integration, and the overall reliability and efficiency of analytics operations.
  • Other duties as required.
Qualifications

SPONSORSHIP IS NOT AVAILABLE AT THIS TIME

Successful candidate will hold a Bachelor's degree in a related field and four to six years of programming and database experience.

Additional requirements include:
  • Knowledge of data management, analytics, business intelligence, visualization, relational data modeling, and dimensional data modeling principles.
  • Advanced knowledge of SQL query development, stored procedures, performance optimization, and ETL/ELT processes using SQL Server data-integration tools, including SSIS.
  • Skill in developing and maintaining automated data processes using Python.
  • Skill in developing Power BI reports, semantic models, DAX measures, and visualizations that translate reporting needs into effective technical data solutions.
  • Skill in analyzing data, validating results, resolving discrepancies, and applying data-quality, security, privacy, and appropriate institutional data-use practices.
  • Ability to manage analytics work from requirements gathering through implementation, documentation, user support, and continuous improvement.
  • Ability to collaborate with stakeholders, technical teams, and institutional partners and communicate data concepts and findings to technical and nontechnical audiences.
Preferred qualifications:
  • Masters degree in a related field or equivalent related experience.
  • One to three or more years of higher education experience.
  • Knowledge of higher education data, reporting requirements, business processes, and institutional systems sufficient to support effective analytics and decision-making.
  • Knowledge of Oracle, Banner, or comparable enterprise data systems.
  • Knowledge of Microsoft Fabric, cloud analytics platforms, or modern data architecture.
  • Embedded analytics and integration: Embedding Power BI reports in web applications or portals and integrating with APIs, Power Automate, Excel, Teams, and SharePoint.
  • Experience with business intelligence performance optimization such as Power BI Performance Analyzer, DAX Studio, or VertiPaq Analyzer to optimize models, measures, visuals, refreshes, and query performance.
Benefits and Compensation

Compensation for the position is budgeted for $75,000 - $85,000.

The University offers a comprehensive benefits package that includes excellent healthcare and tuition benefits for employees and their families, generous retirement benefits, a wide variety of professional development opportunities, supportive work and family benefits and much more. Additionally, Tennessee residents do not pay a state income tax. For more information on the University of Tennessee’s benefits, visit https://hr.tennessee.edu/benefits/

EEO/AA STATEMENT / NON-DISCRIMINATION STATEMENT

The University of Tennessee is an EEO/AA/Title VI/Title IX/Section 504/ADA/ADEA institution in the provision of its education and employment programs and services. All qualified applicants will receive equal consideration for employment without regard to, and will not be discriminated against on the basis of, race, color, national origin, religion, sex, pregnancy, marital status, sexual orientation, gender identity, age, physical or mental disability, or covered veteran status.

Inquiries and charges of violation of Title VI (race, color, national origin), Title IX (sex), Section 504 (disability), ADA (disability), ADEA (age), sexual orientation, or veteran status should be directed to the (EEO). Requests for accommodation of a disability should be directed to the ADA Coordinator at the EEO office.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

LDA Support Operations and Site Reliability Professional (Level 1-4), Department of Technology Solutions - UT System Administration
LDA Support Operations and Site Reliability Professional (Level 1-4), Department of Technology Solutions - UT System Administration

University of Tennessee System • Knoxville (TN)

On-site
USD 65,000 - 115,000
IT Data Technologist - Facilities Services - UTK
IT Data Technologist - Facilities Services - UTK

University of Tennessee, Knoxville • Knoxville (TN)

On-site
USD 70,000 - 95,000
Assistant Director, Degree Audit & Planner Systems
Assistant Director, Degree Audit & Planner Systems

University of Tennessee, Knoxville • Knoxville (TN)

On-site
USD 79,000 - 97,000
Hybrid schedule
Education benefits
Retirement plans
+1
Data Analytics Engineer, College of Natural Sciences
Data Analytics Engineer, College of Natural Sciences

University of Texas • United States

Hybrid
USD 72,000 - 88,000
Data Science Analyst II
Data Science Analyst II

University of Texas • Jackson (TN)

On-site
USD 80,000 - 100,000
Associate Director Systems - Office of Financial Aid and Scholarships
Associate Director Systems - Office of Financial Aid and Scholarships

University of Tennessee, Knoxville • Knoxville (TN)

On-site
USD 95,000 - 135,000
Hybrid schedule
Education benefits
Retirement plans
+2
Data Analytics Engineer, College of Natural Sciences
Data Analytics Engineer, College of Natural Sciences

University of Texas • Austin (TX)

On-site
USD 72,000 - 88,000
Benefits package
Data Developer II: Academic Analytics & BI Insights
Data Developer II: Academic Analytics & BI Insights

University of Tennessee System • Knoxville (TN)

On-site
USD 75,000 - 85,000
Healthcare benefits
Tuition assistance
Professional development opportunities
+1
Data Science Analyst II
Data Science Analyst II

The University of Texas at Austin • Austin (TX)

On-site
USD 72,000 - 88,000
Data Science Analyst II
Data Science Analyst II

University of Texas • United States

On-site
USD 72,000 - 88,000