University of Iowa Health Care’s department of Patient Financial Services (PFS) is seeking a Business Intelligence Architectto support the Patient Financial Services (PFS) Leadership team and department which is comprised of approximately 625+ employees in multiple locations. This role is to lead development and implement tools to support and maintain the business analytics demands of the UI Health Care revenue cycle. Areas of major focus include scorecard/dashboard development, operational and productivity performance analysis, operational and financial benchmarking. Descriptive and predictive analytics will be used to support these areas of focus. This position will collaborate with teams of clinical leaders, administrators, and data warehouse architects to develop, create, and present business analysis related to the UI Healthcare revenue cycle.

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:

• Review data, analytics and modeling requests and requirements.

• Identify existing solutions or design new solutions that satisfy information requests.

• Perform data gap analysis based on institutional data availability and business requirements.

• Analyze data integrity and maintain documentation regarding the validity of data sources.

• Perform advanced data analysis techniques. To identify trends, outliers, and potential issues.

• Design solutions and programs using data analysis tools and platforms.

• Provide complex operational end user support.

• Train technical team members on use of solutions and platforms.

• Design, implement, and provision data solutions via modeling, schema development, ETL and data quality processes.

• Lead Analytic Projects related to UI Health Care’s Revenue Cycle.

• Perform complex queries to extract and consolidate data from various business systems.

• Advanced understanding of statistics and data analytics.

• Evaluate, optimize, and troubleshoot queries and ETL processes for performance and evolving requirements.

• Contribute ideas. Seek ways to improve assigned processes.

• Lead training and share insights with customers on data analytics and reporting.

• May provide functional supervision; provide direction, assignments, feedback, coaching and consulting to assure outcomes are achieved.

• Keep current on industry knowledge, skills, and certifications to serve as a resource to employees and to conduct job duties.

• This position will link numerous sets of data to provide leadership with decision tools to help optimize the delivery of a top tier revenue cycle at University of Iowa Health Care.

Classification Title: Business Intelligence Architect

Department: Patient Financial Services (SPARC)

Pay Grade: 5B

Percent of Time: 100%

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 visitinghttps://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 visitinghttps://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:

• 5-7 years of experience using complex databases, SQL queries, spreadsheet, and data visualization/reporting tools for financial and operational analysis

• Familiarity with predictive analytic techniques

• Demonstrated ability to turn raw data into actionable information via analytic methods

• Proficiency with Microsoft software applications including: Access, Excel, SharePoint, PowerPoint, FrontPage, Visio, Project, and Word.

• Strong time management skills and the ability to multi-task and prioritize multiple projects to meet deadlines in a fast-paced environment.

• Excellent verbal and written communication skills with a demonstrated ability to bring about positive outcomes by collaborating and working in a team environment.

• Experienced in identifying opportunities for operational improvement, using creative efforts to bring about solutions.

• Demonstrated ability to work effectively in ambiguous and complex situations

Desirable Qualifications:

• Advanced SQL reporting skills with the ability to create SQL views and write SQL queries is highly desirable

• Advanced knowledge of relational database query (SQL) skills and large databases

• Advanced knowledge of reporting tools (Tableau, Microsoft Power BI, Qlikview, Alteryx or other similar tools.)

• Previous hands-on experience building Metrics, Balanced Score Cards, Key Performance Indicators, Data Analysis, with dashboard data visualization techniques

• Ability to find crucial data dimensions and data quality issues in a complex data warehouse

• Ability to use creative thinking when working with data

• Advanced proficiency with report development and dashboard design

• Ability to multitask and work in a fast-paced environment

• Demonstrated knowledge of the healthcare revenue cycle and corresponding data and metrics

• Excellent analytical and problem-solving skills are required

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

• (optional) 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:

• Monday 10:00 am - 4:00 pm

• 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