Business Analytics Analyst: Finance & Administration/Budget & Finance - UTK

The Division of Finance & Administration/Office of Budget & Finance at the University of Tennessee, Knoxville (UTK) invites applications for the Business Analytics Analyst. Reporting to the Director, Business Analytics, Modeling & Strategies, the Business Analytics Analyst is responsible for supporting institutional decision-making through business intelligence, analytics, forecasting, planning, and performance measurement. The position develops and maintains dashboards, reports, analytical models, and decision-support tools that provide actionable insights to university leadership and business partners. The Business Analytics Analyst partners with stakeholders across campus to understand operational and financial business needs, translate business questions into analytical solutions, and support data-informed planning, budgeting, forecasting, and resource allocation activities. The position integrates data from enterprise systems and external sources, supports reporting automation and data governance initiatives, and contributes to the continuous improvement of the university's analytics, reporting, and performance management capabilities.

Business Intelligence, Reporting, and Visualization:

Designs, develops, tests, and maintains dashboards, scorecards, reports, and data visualizations using Power BI, SQL, Excel, Power Query, and related analytics technologies.

Develops automated and ad hoc reporting solutions that support operational, financial, and strategic decision-making.

Partners with stakeholders to gather requirements, define key performance indicators (KPIs), and deliver reporting and analytical solutions.

Translates analytical findings into clear, concise, and actionable insights for technical and non-technical audiences.

Maintains reporting documentation, report inventories, data definitions, and standard operating procedures.

Data Analysis, Modeling, and Decision Support:

Develops and maintains analytical models, templates, forecasts, and recurring reporting processes.

Supports budgeting, forecasting, financial planning, resource allocation, and institutional reporting activities through analysis and modeling.

Performs quantitative analysis to identify trends, drivers, risks, opportunities, and process improvement opportunities.

Conducts variance analysis and assists in evaluating the operational and financial impacts of business decisions.

Provides analytical support for planning initiatives, operational assessments, and strategic decision making.

Data Integration, Quality, and Process Improvement:

Develops and maintains SQL queries, data transformations, and data preparation processes using enterprise and external data sources.

Supports ETL activities and reporting automation initiatives that improve efficiency, scalability, and consistency of reporting operations.

Identifies and resolves data discrepancies and supports data validation, governance, and quality assurance activities.

Contributes to reporting standards, documentation, and process improvement initiatives.

Continuously evaluates opportunities to improve analytical processes, reporting usability, and operational effectiveness.

Required

Education : Bachelor's degree in Business Analytics, Finance, Accounting, Information Systems, Data Science, Statistics, Computer Science, or related field.

Experience: Four years of progressively responsible experience in business intelligence, analytics, reporting, financial analysis, forecasting, budgeting, or related analytical functions.

Knowledge, Skills, Abilities:

Demonstrated abilities with querying, ETL, analysis, visualization and reporting tools.

Working knowledge of enterprise systems and relational data environments.

Demonstrated support of budgeting, forecasting, or institutional planning activities.

Ability to collect, transform, analyze, and interpret complex data from multiple sources.

Strong analytical, organizational, communication, and problem-solving skills.

Ability to communicate technical and analytical concepts effectively to diverse stakeholder groups.

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-based visa status.

Preferred

Education: Master’s degree in Business Analytics, Finance, Data Science, Information Systems, Statistics, Accounting, or related field.

Experience:

Experience with Power BI, SQL, EasyMorph, Excel, Power Query, and related analytics and reporting technologies.

Experience with dashboard development, ETL processes, data modeling, and large relational datasets.

Experience in higher education, government, healthcare, or other complex institutional environments.

Experience with ERP systems such as Oracle, Workday, Banner, or similar enterprise platforms.

Work Location

Knoxville, TN - in-person, on-site

Compensation and Benefits

UT market range: MR13

Generous paid leave, accruing up to 24 days of vacation and 12 days of sick leave annually, plus 14 paid holidays and administrative closing days.

Education benefits for employees and their dependents at UT System campuses.

Retirement and deferred compensation plans, including 401(k), 403(b), etc.

Comprehensive medical, dental, and vision insurance plans.

Employee discounts to attractions, services, and goods.

Application Instructions

Interested applicants should submit an application with the following attachments:

Resume

Cover Letter

About The College/Department/Division:

The Office of Budget and Finance provides support to university administrators in developing and implementing short and long-range financial plans for the Knoxville campus. The primary responsibilities include the preparation of the annual budget and the monitoring and tracking of the financial status of the Knoxville campus.