Business Intel Architect - Self-Pay, Analytics & Revenue Cycle Counseling (SPARC) - Patient Financial Services (PFS)

University of Iowa•Iowa City, IA

10d•Hybrid

About The Position

University of Iowa Health Care’s department of Patient Financial Services (PFS) is seeking a Business Intelligence Architect to 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. 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.

Requirements

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

Nice To Haves

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

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.
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.