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

The University of Iowa Health Care is a comprehensive academic medical center and regional referral center seeking a Business Intelligence Architect for its Patient Financial Services department. The role leads the development and implementation of analytics tools supporting revenue cycle scorecards, dashboards, operational performance analysis, financial benchmarking, and predictive analytics. It collaborates with clinical leaders, administrators, and data warehouse architects to develop and present business analysis and data solutions.

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

Requirements:

• • Bachelor's degree or equivalent amount of education and experience
• • 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
• • 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