University of Iowa Health Care's Department of Patient Financial Services (PFS) is seeking a Business Intelligence Architect to lead the development of advanced analytics, business intelligence solutions, and data-driven strategies supporting healthcare revenue cycle operations.This position combines advanced technical expertise in data architecture, analytics, and business intelligence with a strong understanding of healthcare revenue cycle operations and financial performance. The Business Intelligence Architect will develop and maintain data solutions, performance dashboards, operational scorecards, and analytical tools that enable leadership to monitor performance, identify trends, evaluate operational effectiveness, and make informed business decisions.Beyond developing reports and analytical solutions, this position serves as a strategic analytical partner to revenue cycle leadership. The individual will interpret complex data, identify performance strengths and weaknesses, evaluate potential operational drivers and competing performance indicators, and communicate meaningful insights that support leadership's evaluation of operational performance and opportunities for improvement.The position will collaborate with revenue cycle leadership, operational teams, and enterprise data and technology partners to ensure analytical solutions align with organizational priorities and support the measurement and evaluation of operational changes.
This position is primarily a combination of remote and onsite (hybrid) work locations. Remote work must be performed at an offsite location within the State of Iowa. Training will be held ONSITE at the HSSB building at a length determined by the supervisor. Remote eligibility will be evaluated upon a satisfactory job training opportunity. Per policy, work arrangements will be reviewed annually, and must comply with the remote work program and related policies and employee travel policy when working at a remote location.
Position Responsibilities:- Business Requirements and Operational Analysis
- Collaborate with Patient Financial Services leadership and operational stakeholders to understand business needs, evaluate operational performance, and translate business requirements into effective analytical solutions.
- Analyze healthcare revenue cycle financial performance, productivity, and operational metrics to identify trends, performance variations, strengths, weaknesses, and areas requiring further investigation.
- Interpret and communicate analytical findings, including potential operational drivers, competing performance indicators, and data limitations, to help leadership understand business performance and evaluate opportunities for operational change.
- Partner with operational leadership to establish meaningful performance measures, monitor operational changes, and evaluate outcomes against established objectives.
- Business Intelligence, Reporting, and Visualization
- Design, develop, and maintain business intelligence solutions, including dashboards, operational scorecards, key performance indicators (KPIs), and financial and productivity reporting tools.
- Develop reporting solutions that communicate complex information clearly, provide meaningful performance comparisons, and support leadership in evaluating operational effectiveness and business outcomes.
- Establish and maintain consistent reporting methodologies, metric definitions, and performance measurement standards to support accurate and reliable decision-making.
- Data Architecture, Engineering, and Integration
- Architect, develop, implement, and maintain complex data models, reporting structures, and integrated datasets supporting healthcare revenue cycle analytics.
- Develop and optimize advanced SQL queries, data transformation processes, and ETL/ELT solutions to extract, integrate, and analyze data from multiple enterprise systems.
- Evaluate data structures, system capabilities, and technical solutions to improve data accessibility, reporting efficiency, scalability, and analytical performance.
- Advanced Analytics and Data Quality
- Apply advanced analytical methods, statistical techniques, and predictive analytics to evaluate operational and financial performance, identify emerging trends, and support forecasting and strategic planning.
- Investigate data anomalies, performance variations, and potential operational issues to distinguish meaningful business trends from data quality concerns or reporting inconsistencies.
- Establish and maintain data validation, integrity, documentation, and governance practices to ensure analytical information is accurate, consistent, reliable, and appropriately secured.
- Technical Leadership and Strategic Collaboration
- Serve as a technical and analytical subject matter expert, providing guidance to revenue cycle leadership on the interpretation, application, and operational significance of business intelligence findings.
- Lead complex analytics initiatives and collaborate with technical and operational stakeholders to develop data solutions aligned with organizational priorities.
Classification Title: Business Intelligence Architect
Pay Grade: 5B
Department: Patient Financial Services (SPARC)
Percent of Time: 100%
Work Arrangement: Hybrid
Location: Hospital Support Services Building (HSSB) in Coralville, IA
This position is primarily a combination of remote and onsite (hybrid) work locations. Remote work must be performed at an offsite location within the State of Iowa. Training will be held ONSITE at the HSSB building at a length determined by the supervisor. Remote eligibility will be evaluated upon a satisfactory job training opportunity. Successful candidates must comply with requirements of the remote work program and related policies.
Equipment:- Onsite - The department will provide a workstation which contains 3 (three) monitors, laptop/power cord, docking station/power cord, keyboard, mouse, headset, and desk supplies can be found in the supply closet.
- Hybrid - while working onsite, the department will provide a workstation which contains 3 (three) monitors, a laptop/power cord, docking station/power cord, keyboard, mouse, headset, and desk supplies. When working offsite, the employee will take their laptop/power cord to carry back and forth, a second docking station/power cord to keep offsite. Prior to working offsite, the employee, at their own expense, will need to supply 2 (two) monitors, in addition to the university-issued laptop, which will serve as a third monitor due to its built-in camera function, a keyboard, and a mouse. Employees will be required to provide a photo of the domicile office setup and perform an internet speed test by visiting https://www.speedtest.net/ with a minimum 30mb download and 10mb upload reflecting a University of Iowa IP address, then providing a screenshot of the speed test to HR. The employee's remote workstation should replicate the onsite setup as if they were working onsite at HSSB.
- Remote - when working offsite, the department will provide the employee a laptop/power cord, docking station/power cord, headset. Prior to working offsite and at their own expense, the employee will be required to obtain or possess 2 (two) monitors, in addition to the university-issued laptop, which will serve as a third monitor due to its built-in camera function, a keyboard, and a mouse. Employees will be required to provide a photo of the domicile office setup and perform an internet speed test by visiting https://www.speedtest.net/ with a minimum 30mb download and 10mb upload reflecting a University of Iowa IP address, then providing a screenshot of the speed test to HR. The employee's remote workstation should replicate the onsite setup as if they were working onsite at HSSB.
Education Requirement:- Bachelor's degree or equivalent amount of education and experience
Required Qualifications: - Professional Experience: Five to seven years of progressively responsible experience in business intelligence, data analytics, data engineering, or data architecture, including experience supporting complex financial and operational analytics.
- Healthcare Revenue Cycle Knowledge: Demonstrated experience with healthcare revenue cycle operations, financial performance analysis, and operational metrics, including the ability to evaluate business processes and understand the operational implications of analytical findings.
- Advanced SQL and Data Architecture: Demonstrated advanced proficiency in SQL and relational database technologies, including designing, developing, optimizing, and troubleshooting complex queries, data models, reporting structures, and integrated datasets from multiple enterprise systems.
- Business Intelligence and Data Visualization: Demonstrated experience developing and maintaining business intelligence solutions, including interactive dashboards, operational scorecards, KPIs, and financial or productivity reporting using Power BI, Tableau, or comparable technologies.
- Operational Analytics and Business Decision Support: Demonstrated ability to critically evaluate healthcare revenue cycle performance data, identify underlying operational drivers, recognize competing performance indicators and potential tradeoffs, and communicate balanced, actionable insights. Ability to collaborate with operational leadership to identify areas requiring further evaluation, establish meaningful performance measures, and assess the impact of operational changes to support informed business decision-making.
- Data Integration and Quality Management: Demonstrated experience integrating and transforming data from multiple sources, including ETL/ELT processes, data validation, and identification and resolution of data quality and integrity issues.
- Advanced Analytical and Problem-Solving Skills: Demonstrated ability to apply analytical and statistical methods to complex business challenges, investigate underlying drivers of performance, and develop effective solutions in ambiguous or evolving operational environments. Familiarity with predictive analytics techniques.
- Business Requirements and Stakeholder Collaboration: Demonstrated ability to work collaboratively with operational leaders, business stakeholders, and technical teams to assess business needs, define analytical requirements, and develop scalable solutions aligned with organizational objectives.
- Technical Leadership and Project Management: Demonstrated ability to independently lead complex analytics initiatives, provide technical guidance and mentorship, manage competing priorities, and deliver high-quality solutions within established timelines.
- Communication and Data Storytelling: Excellent written and verbal communication skills, including demonstrated ability to present complex analytical findings to technical and nontechnical audiences, explain the operational significance of data, highlight risks and opportunities, and support strategic and operational decision-making.
Desirable Qualifications:- Experience working with Epic Clarity, Caboodle, or comparable enterprise healthcare data warehouse and reporting environments.
- Advanced knowledge of healthcare revenue cycle performance indicators, including accounts receivable, cash collections, denials, reimbursement, productivity, and revenue cycle operational efficiency.
- Experience developing predictive models, statistical analyses, forecasting solutions, or advanced analytical automation to support financial and operational planning.
- Experience developing or implementing enterprise data governance frameworks, data architecture strategies, or large-scale data integration initiatives.
- Experience providing technical mentorship, functional supervision, or leadership of business intelligence developers, data analysts, or multidisciplinary analytics teams.
Application Process: In order to be considered for an interview, applicants must upload the following documents and mark them as a "Relevant File" for the submission:
Job openings are posted for a minimum of 7 calendar days and may be removed from posting and filled any time after the original posting period has ended. Applications will be accepted until 11:59 PM on the date of closing.
Successful candidates will be required to self-disclose any conviction history and will be subject to a criminal background check and credenti
