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

Benefits offered by this job

Healthcare benefits

Tuition benefits

Retirement benefits

Job summary

The University of Tennessee System seeks a data systems professional to design, maintain, and optimize data workflows using SQL and Python, and to develop Power BI dashboards and semantic models for leadership. Collaboration with Institutional Research and technology partners will improve reporting processes and decision-support capabilities.

Preferred candidates hold a Bachelor's degree with 4–6 years of programming and database experience; Masters is a plus.

Qualifications

• Bachelor's degree in a related field and four to six years of programming and database experience.
• Advanced knowledge of SQL, SQL Server, and ETL/ELT processes.
• Experience with Power BI, semantic models, and data visualization for leadership.

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 and modify data validation, error-checking, reconciliation, and troubleshooting processes to support reliable reporting.
• Collaborate with Institutional Research and technology partners to define data requirements and deliver effective reporting solutions.

Skills

SQL

Python

Power BI

DAX

Tableau

ETL/ELT

Data modeling

Data governance

Communication

Education

Bachelor's degree

Master's degree

Tools

SSIS

SQL Server

Power BI Desktop

VertiPaq Analyzer

Power Automate

Excel

API integration

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.

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

Responsibilities include but not limited to:

• 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

$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/

About Us

The University of Tennessee System is the state’s oldest higher education institution and preeminent public university. The UT System is comprised of campuses at Knoxville, Chattanooga, Pulaski and Martin; the Health Science Center at Memphis; and the statewide Institute of Agriculture and Institute for Public Service. With a presence in each of Tennessee’s 95 counties and through the combined force of education, research and outreach, the University serves students, business and industry, schools, governments, organizations and residents statewide.