Business Intelligence Analyst IV

ULSA University of Louisville; United States; On-site; USD 95,000 - 120,000; Full time

Job summary

The University of Louisville Health Sciences Center (HSC) seeks a Business Intelligence Analyst IV to join the BI/Analytics team. You will maintain Power BI dashboards, financial mappings, and reporting structures while developing new analyses to support budgeting, payroll, and executive decision-making.

The role requires strong technical reporting skills and financial acumen, with collaboration across Finance, IT, HR, and Payroll to ensure timely, accurate enterprise reporting across UL and ULP.

Qualifications

• Bachelor's degree and six years of relevant experience or equivalent.
• Experience with Power BI, DAX, SQL, and financial reporting.
• Ability to translate business requirements into reporting solutions.

Responsibilities

• Develop, maintain, and enhance Power BI dashboards and financial reports.
• Refresh datasets, troubleshoot failures, and ensure reliability.
• Collaborate with Finance, IT, HR, and Payroll to meet reporting needs.
• Validate data against source systems and ensure accuracy.
• Support budgeting, forecasting, payroll analysis, and executive decision-making.

Skills

Power BI

DAX

SQL

Excel

Power Query (M)

Data modeling

Financial reporting

Alteryx

Communication

Problem solving

Education

Bachelor's degree in Accounting, Finance, Business Analytics, Computer Science, Information Systems

Tools

Power BI

Alteryx

SQL

Excel

Job description

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.

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.

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

Assistance and Accommodations 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 [e-mail] or by phone [phone]. The University of Louisville is committed to being a great place to work, learn and invest. It is a place where you will thrive in a community of inclusivity, cultivate your innovative power and work where you’ll discover your purpose. Join the Cardinal Family today. Learn more about the University at our About Us page.