Note: The job is a remote job and is open to candidates in USA. The University of Louisville is seeking a Business Intelligence Analyst IV for its Health Sciences Center. The role develops and maintains financial and operational reporting solutions, validates and integrates financial data, and supports decision-making in collaboration with Finance, IT, and other stakeholders.
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
Skills
- Bachelor's degree in a related field and Six (6) years of relevant experience or an equivalent combination of education and experience
- 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
- 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
- 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
Company Overview
Company H1B Sponsorship