Business Intel Architect - Self-Pay, Analytics & Revenue Cycle Counseling (SPARC) - Patient Financial Services (PFS)
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.
The University of Iowa Health Care — recognized as one of the best hospitals in the United States—is Iowa's only comprehensive academic medical center and a regional referral center. Each day more than 12,000 employees, students, and volunteers work together to provide safe, quality health care and excellent service for our patients. Simply stated, our mission is: Changing Medicine. Changing Lives.®
WE CARE Core Values:
Welcoming - We have an environment where everyone has a voice that is heard; that promotes the dignity of our patients, trainees, and employees; and allows all to thrive in their health, work, research, and education.
Excellence - We achieve and deliver our personal and collective best in the pursuit of quality and accessible health care, education, and research.
Collaboration - We collaborate with health care systems, providers, and communities across Iowa and the region as well as within our UI community. We believe teamwork—guided by compassion—is the best way to work.
Accountability - We behave ethically, act with fairness and integrity, take responsibility for our own actions, and respond when errors in behavior or judgment occur.
Respect - We create an environment where every individual feels safe, valued, and respected, supporting the well-being and success of all members of our community.
Empowerment - We commit to fair access to research, health care, and education for our community and opportunities for personal and professional growth for our staff and learners.
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:
Resume
Cover Letter
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 credential/education verification. Up to 5 professional references will be requested at a later step in the recruitment process.
For additional questions, please contact Veronica Clark at veronica-clark@uiowa.edu.
Applicant Resource Center: Need help submitting an application or accepting an offer? Support is available! Our Applicant Resource Center is now open in the Fountain Lobby at the Main Hospital.
Hours:
Tuesday 10:00 am – 4:00 p.m.
Wednesday 10:00 am – 4:00 p.m.
Thursday 10:00 am – 4:00 p.m.
Friday 10:00 am – 4:00 p.m.
Or by appointment - Contact TAHealthCareSupport@healthcare.uiowa.edu to schedule an appointment or just stop by.
Visit the website for more information: Application Resource Center | University of Iowa Health Care
Equal opportunity employer
The University of Iowa is an equal opportunity employer. All qualified applicants are encouraged to apply and will receive consideration for employment free from discrimination on the basis of race, creed, color, religion, national origin, age, sex, pregnancy (including childbirth and related conditions), disability, genetic information, status as a U.S. veteran, service in the U.S. military, sexual orientation, or associational preferences.
Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, (319) 335-2660 or fsds@uiowa.edu. For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543.
