Business Intelligence Analyst IV

University of Louisville•Aurora, CO

About The Position

The University of Louisville Health Sciences Center is seeking a Business Intelligence Analyst IV for its Business Intelligence and Analytics team. The role supports the development, maintenance, and enhancement of business intelligence and financial reporting solutions, working closely with HSC Finance, Information Technology, and business stakeholders to deliver accurate, reliable, and useful financial and operational reporting. The analyst applies knowledge of financial reporting, general ledger structures, and accounting rules to interpret financial data, validate reporting results, and translate business requirements into analytical solutions. The role maintains Power BI reports, financial mappings, and reporting structures, and develops dashboards and analyses that support operational decision-making. It also requires understanding how financial information from the University of Louisville and University of Louisville Physicians is integrated. The position supports reporting and data workflows but does not manage server infrastructure.

Requirements

Bachelor's degree in a related field and six years of relevant experience, or an equivalent combination of education and experience.
Strong understanding of financial reporting concepts, general ledger structures, and accounting rules.
Ability to interpret financial data, validate reporting results, and translate business requirements into analytical solutions.
Strong analytical skills, attention to detail, and effective communication with technical and non-technical stakeholders.
Demonstrated understanding of accounting principles, budgeting, financial reporting, and general ledger concepts.
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.

Nice To Haves

Bachelor's degree in Accounting, Finance, Business Analytics, Computer Science, Information Systems, or a related field.
Familiarity with data preparation concepts and experience with Alteryx or similar tools.
Two 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 for enterprise reporting.
Experience integrating, reconciling, and validating financial data from multiple separate entities.
Experience 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, including VLOOKUPs, pivot tables, and complex formulas.
Experience with relational databases and data reconciliation techniques.

Responsibilities

Develop, maintain, and enhance Power BI dashboards, financial reports, scorecards, and analytical solutions for Finance and Administration.
Perform scheduled and ad hoc Power BI dataset refreshes, troubleshoot failures, and ensure reporting applications are available according to established schedules.
Maintain enterprise financial reporting applications, ensuring data accuracy, report performance, and user reliability.
Understand the University's financial reporting environment, including integration of financial information from UL and ULP.
Maintain financial mappings, account hierarchies, organizational structures, spend and revenue categories, and other reporting reference tables.
Maintain business rules, transformations, and reporting logic used to integrate and standardize financial data across systems.
Reconcile reports against source accounting systems, investigate discrepancies, and validate completeness and accuracy of financial data.
Develop dashboards, financial reports, and ad hoc analyses supporting budgeting, forecasting, payroll analysis, and executive decision-making.
Assist in developing and maintaining Power BI reports and models using DAX and Power Query (M).
Support desktop-level data preparation and workflow automation using Alteryx, Excel, and related tools.
Work with Finance, Payroll, Human Resources, IT, and other departments to understand reporting requirements and resolve data issues.
Interpret accounting, budgeting, and financial reporting requirements and translate them into reporting solutions that reflect business processes.
Document financial reporting logic, business rules, mappings, and technical processes.
Participate in testing reports, enhancements, and system implementations before deployment.
Respond to reporting questions, troubleshoot issues, and assist end 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.