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

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 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.

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.

Application Process 
For full consideration, applications should be accompanied by a letter of interest, a resume, and three professional references. Review of applications will begin immediately.      

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/