Business Intelligence Analyst IV

University of Louisville; Louisville (KY); On-site; USD 90,000 - 120,000; Full time

Job summary

University of Louisville Health Sciences Center in Louisville, KY seeks a Business Intelligence Analyst IV to join the BI and Analytics team. The role focuses on developing Power BI dashboards, financial reports, and analyses that support budgeting, payroll, and general accounting processes across UL and UL Physicians.

You will ensure data accuracy and provide insights to enable executive decision-making. The ideal candidate combines strong reporting skills with financial acumen and the ability

Qualifications

• Bachelor's degree in a related field and 6 years of relevant experience or equivalent.
• Strong Power BI reporting and data visualization skills.
• Proficiency in SQL queries for data extraction and analysis.
• Experience with financial reporting, budgeting, and GL concepts.
• Familiarity with ERP systems and financial data mappings.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards, reports, scorecards, and analyses for Finance and Administration.
• Schedule and refresh Power BI datasets, troubleshoot refresh failures, ensure reliability.
• Maintain enterprise financial reporting applications, ensuring data accuracy and performance.
• Collaborate with Finance, IT, HR, Payroll, and other stakeholders to gather requirements.
• Translate accounting and budgeting needs into reporting solutions and validate results.

Skills

Power BI

DAX

SQL Queries

Financial reporting

Budgeting

Education

Bachelor's degree

Tools

Alteryx

Excel

Job description

## Business Intelligence Analyst IVApply: Health Sciences Center: Full time: Posted Today: End Date: November 3, 2026 (13 days left to apply): R109565**Department:**HSC Finance and Admin**Location:**Health Sciences Center**Time Type:**Full time**Worker Type:**Regular**Job Req ID:**R109565**Minimum Requirements:**Bachelor's degree in a related field and Six (6) years of relevant experience or an equivalent combination of education and experience. Grade 9 (Salaried)**Position Description:**We are seeking a motivated Business Intelligence Analyst IV to join our growing Business Intelligence and Analytics team at the University of Louisville Health Science Center (HSC). The ideal candidate combines strong technical reporting skills with financial acumen, understanding how financial transactions, budgeting, payroll, and reporting processes interact across multiple organizations to produce accurate enterprise reporting. The Business Intelligence & Financial Analyst is responsible for supporting the development, maintenance, and enhancement of business intelligence and financial reporting solutions for the University of Louisville Health Sciences Center. This position works closely with HSC Finance, Information Technology, and business stakeholders to ensure the timely delivery of accurate, reliable, and meaningful financial and operational reporting. The successful candidate will possess a strong understanding of financial reporting concepts, general ledger structures, and accounting rules, demonstrating the ability to interpret financial data, validate reporting results, and translate business requirements into analytical solutions. This position maintains Power BI reports, financial mappings, and reporting structures while developing new dashboards and analyses that support operational decision-making. The Business Intelligence & Financial Analyst will develop a comprehensive understanding of the University's financial reporting environment, including the integration of financial information from both the University of Louisville (UL) and University of Louisville Physicians (ULP). The candidate will ensure reporting accurately reflects accounting principles and organizational policies without managing server infrastructure. **Essential Duties and Responsibilities*** Develop, maintain, and enhance Power BI dashboards, financial reports, scorecards, and analytical solutions supporting Finance and Administration.* Perform scheduled and ad hoc refreshes of Power BI datasets, troubleshoot refresh failures, and ensure reporting applications are available according to established schedules.* Maintain and support enterprise financial reporting applications, ensuring data accuracy, report performance, and overall user reliability.* Develop a comprehensive understanding of the University's financial reporting environment, including the integration of financial information from both UL and ULP.* Maintain financial mappings, account hierarchies, organizational structures, spend categories, revenue categories, and other reporting reference tables.* Understand and maintain the business rules, transformations, and reporting logic used to integrate and standardize financial data across multiple systems.* Validate financial data by reconciling reports against source accounting systems and investigating discrepancies to ensure completeness and accuracy.* Develop new dashboards, financial reports, and ad hoc analyses that support budgeting, forecasting, payroll analysis, and executive decision-making.* Assist in developing and maintaining Power BI reports and models utilizing DAX and Power Query (M).* Support desktop-level data preparation and workflow automation using Alteryx, Excel, and related tools.* Collaborate with Finance, Payroll, Human Resources, IT, and other departments to understand business reporting requirements and resolve data-related issues.* Interpret accounting, budgeting, and financial reporting requirements and translate them into reporting solutions that accurately reflect business processes.* Maintain documentation for financial reporting logic, business rules, mappings, and technical processes.* Participate in testing new reports, enhancements, and system implementations prior to deployment.* Provide end-user support by responding to reporting questions, troubleshooting issues, and assisting users with Power BI applications.* Identify opportunities to automate manual reporting processes and improve operational efficiency.* Support monthly, quarterly, fiscal year-end, and budget reporting activities.* Maintain compliance with organizational data governance standards, reporting best practices, and internal controls.* Perform other duties as assigned. **Preferred Qualifications*** Bachelor's degree in Accounting, Finance, Business Analytics, Computer Science, Information Systems, or a related field.* Familiarity with data preparation concepts; experience with Alteryx or similar tools is preferred.* Strong analytical skills, attention to detail, and the ability to communicate effectively with both technical and non-technical stakeholders.* Two (2) or more years of experience in business intelligence, financial reporting, business analytics, accounting, finance, or data analysis.* Knowledge of Workday Financials, Workday Adaptive Planning, Human Capital Management (HCM), or other enterprise ERP systems.* Knowledge of financial dimensions, chart of accounts, organizational hierarchies, and financial reporting structures.* Experience maintaining financial mappings, reference tables, and business rules supporting enterprise reporting.* Experience integrating, reconciling, and validating financial data from multiple separate entities.* Experience working in higher education, healthcare, or another complex financial environment.* Experience writing SQL queries for reporting and financial data analysis.* Experience documenting business processes, reporting logic, and technical procedures.* Experience developing reports using Microsoft Power BI or comparable business intelligence software.* Experience developing reports and dashboards using Microsoft Power BI Desktop and Power BI Service.* Proficiency with DAX and Power Query (M).* Strong proficiency with Microsoft Excel (vlookups, pivot tables, complex formulas).* Demonstrated understanding of accounting principles, budgeting, financial reporting, and general ledger concepts.* Experience working with relational databases and data reconciliation techniques.* Ability to analyze complex financial data and translate business requirements into meaningful reporting solutions.* Strong analytical, organizational, and problem-solving skills.* Excellent written and verbal communication skills.**Competencies****Financial Acumen:** Demonstrates a solid understanding of accounting principles, budgeting, and financial reporting structure to ensure data accuracy.**Business Intelligence & Data Engineering:** Applies advanced technical skills in DAX, SQL, and data modeling to transform complex data into performant reporting solutions.**Problem Solving:** Investigates reporting and data modeling issues, identifies root causes, and implements practical, robust technical solutions.**Attention to Detail:** Maintains a high degree of precision while validating data, writing calculations, and maintaining mappings.**Communication:** Translates technical data models and complex logic into clear concepts for business users and leadership.**Collaboration:** Builds productive working relationships across Finance, Information Technology, HR, and Payroll departments.**Customer Service:** Provides responsive, professional support to business end users while maintaining commitment to service excellence.**Time Management:** Effectively manages multiple analytical priorities and reporting deadlines in a dynamic environment.**Continuous Improvement:** Proactively identifies opportunities to streamline reporting workflows and optimize semantic models.**Integrity:** Maintains confidentiality and exercises sound judgment when handling sensitive financial and personnel information. **Compensation will be commensurate to candidate experience.**