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