Revenue Cycle Business Intelligence Analyst

AdventHealth is hiring a Revenue Cycle Business Intelligence Analyst to transform data into actionable insights that support strategic decisions and business value. The role collaborates across Revenue Cycle and with IT to analyze data, develop and maintain reports and dashboards, identify operational improvement opportunities, and communicate findings to leadership.

Responsibilities:

• Designs, develops, and maintains reports, scorecards, and dashboards that effectively tell the story of the data and highlight anomalies in a manner that can be easily understood and acted upon
• Performs data mining, queries, and extractions in collaboration with IT to acquire, aggregate, cleanse, organize, and manage large complex datasets from multiple sources
• Conducts root cause analyses to surface actionable insights that support data-driven decision making and operational improvement across revenue cycle functions
• Flags data or analytics limitations, employs critical thinking and creative problem solving to address barriers, and escalates issues to leadership when appropriate
• Identifies key data needs, defines data sources, creates a data plan, prepares specifications, and documents clearly
• Quantifies financial and non-financial performance impacts, applies independent source validation, and ensures the integrity of information in accordance with quality audit standards
• Collaborates with leadership and Revenue Cycle and System subject matter experts (SMEs) to establish quantifiable goals
• Prepares effective presentations and articulately communicates findings and results
• Monitors dashboards and reports to provide recommendations on best practices to improve reporting
• Maintains accountability for individual task tracking and request fulfillment to ensure department productivity metrics, service levels, and established SLAs are consistently met
• Collaborates with data analytics and IT teams to tailor and optimize Epic foundational reports and dashboards; educates operational teams on usage to promote self-service and informed decision making
• Debugs and maintains existing reports, scorecards, and dashboards on an ongoing basis, supporting adjustments based on Revenue Cycle operational need and impact as prioritized by the Analytics and Revenue Cycle and System SME teams
• Produces materials needed to guide usage of complex analytical deliverables, dashboards, and tools; collaborates with Training and Education coordinators if in-depth or ongoing training is required
• Other duties as assigned

Requirements:

• Fundamental awareness of data querying techniques (i.e., Structured Query Language, Power Query, Power Pivot)
• Proficiency in Microsoft Office products Word, Outlook, PowerPoint
• Advanced knowledge of Excel or other databasing software to organize data, develop data models for analysis, and create visualizations
• Basic knowledge of one or more business intelligence tools (e.g., Power BI, Tableau, Business Objects, QlikView, Oracle Business Intelligence, HPM, Minitab or similar.)
• Proficiency in performance of basic mathematical and statistical concepts (e.g., regression analysis)
• Listens, negotiates and persuades, with use of proper English grammar and spelling, with ability to articulate complex information in understandable terms to audiences at all levels
• Ability to solve complex analytics related problems involving large data by using data collection methods, root cause analysis, establishing facts, exercises experience and objective independent judgment to draw valid conclusions
• Ability to multitask, coordinate multiple priorities, projects, and issues in a fast-paced dynamic environment Ability to work independently while providing on-time concise, high quality deliverables
• Has an aptitude to extract, aggregate, transform, cleanse, compile and manage data, and can do data modelling and visualization to effectively and objectively tell the story of the data
• Strong work ethic with a positive, can-do attitude, ability to be responsive to ever-changing needs in a fast-paced, dynamic environment, meet deadlines and perform
• Bachelor's
• 3+ in Microsoft Excel with strong knowledge of utilizing conditional formatting, PivotTables, PivotCharts, functions, and formulas
• 1+ years of experience with Power BI or similar data visualization tools
• SQL — required: Active, hands-on experience writing SQL queries
• Power BI — required: Hands-on development experience, including DAX formulas, data modeling and structure, and clear storytelling through data and visuals
• Excel: Proficiency with pivot tables, data analysis, trend identification, and charts
• Epic reporting: Experience with SlicerDicer, Reporting Workbench, and Epic data structures, knowledge of or willingness to learn acceptable
• Bachelors degree OR 2+ years of progressive practical related work experience
• Intermediate knowledge of healthcare and Revenue Cycle operations
• Master's
• 2+ years of experience working with Electronic Medical Record (EMR) data, including conducting data table research and validation, and extracting and modeling data using platforms such as Snowflake, dbt, or similar cloud-based data tools
• Snowflake experience preferred
• VBA: Experience with visual basic in excel, knowledge of or willingness to learn acceptable
• Visual Studios: Code and debugging experience, knowledge of or willingness to learn acceptable
• Power Automate or UiPath: Experience preferred, knowledge of or willingness to learn acceptable
• Project Management Professional (PMP)
• Six Sigma
• Change Management Certification (PROSCI)