Business Intelligence Analyst IV

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.

The University of Louisville is an Equal Employment Opportunity employer. The University strives to provide equal employment opportunity on the basis of merit and without unlawful discrimination on the basis of race, sex, age, color, national origin, ethnicity, creed, religion, disability, genetic information, sexual orientation, gender, gender identity or expression, veteran status, marital status, or pregnancy. In accordance with the Rehabilitation Act of 1973 and the Vietnam Era Veteran Readjustment Act of 1974, the University prohibits job discrimination of individuals with disabilities, Vietnam era veterans, qualified special disabled veterans, recently separated veterans, and other protected veterans. The University acknowledges its obligations to ensure affirmative steps are taken to ensure equal employment opportunities for all employees and applicants for employment. It is the policy of the University that no employee or applicant for employment be subject to unlawful discrimination in terms of recruitment, hiring, promotion, contract, contract renewal, tenure, compensation, benefits, and/or working conditions. No employee or applicant for employment is required to endorse or condemn a specific ideology, political viewpoint, or social viewpoint to be eligible for hiring, contract renewal, tenure, or promotion.

Consistent with applicable law, demographic information is collected for aggregate reporting requirements. Demographic information provided through this application is not available to hiring managers/committees and is not considered in hiring or employment decisions.

Computers are available for application submission at the Human Resources Department located at 2315 South First Street Walk, Room 02C - Louisville, Kentucky 40292.

If you require assistance or accommodation with our online application process, please contact us by email at employment@louisville.edu or by phone 502-852-6258.