Business Intelligence Specialist

adventhealth; Orlando (FL); On-site; USD 61,000 - 113,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

Paid Time Off

403(b) Retirement Plan

Parental Leave

Career Development

Well-being Resources

Mental Health Resources

Pet benefits

Job summary

AdventHealth is seeking a data analytics professional to design and maintain reports and dashboards that reveal insights for revenue cycle operations. You will mine data, validate sources, and collaborate with IT and SMEs to drive actionable improvements.

The role requires strong Excel, SQL, and BI skills, plus experience with EMR data tools and healthcare operations. This on-site position in Florida offers comprehensive benefits and career growth.

Qualifications

• Fundamental data querying skills (SQL, Power Query, Power Pivot) required.
• Proficiency in Microsoft Word, Outlook, and PowerPoint required.
• Advanced knowledge of Excel and data modeling for analysis required.
• Basic knowledge of BI tools (Power BI, Tableau, Oracle BI, QlikView, etc.) required.
• Proficiency in basic mathematical and statistical concepts (e.g., regression analysis) required.
• Strong communication in English; ability to explain complex information to diverse audiences required.
• Ability to solve complex analytics problems with large data sets using systematic methods required.
• Ability to multitask in a fast-paced environment and deliver on time required.
• Aptitude to extract, transform, cleanse, and model data for storytelling and visualization required.
• Strong work ethic and responsiveness to changing business needs required.
• Intermediate knowledge of healthcare and Revenue Cycle operations preferred.

Responsibilities

• Designs, develops, and maintains reports, scorecards, and dashboards to tell the data story and highlight anomalies.
• Performs data mining, queries, and extractions with IT to aggregate and cleanse large datasets from multiple sources.
• Conducts root cause analyses to surface actionable insights for revenue cycle improvements.
• Prepare specifications and document data sources, plans, and data definitions.
• Collaborates with leadership and SMEs to set quantifiable goals and communicate findings.
• Maintain dashboards and reports, monitor performance, and recommend best practices.
• Educate operational teams on self-service tools and optimizations in Epic dashboards.
• Debugs and maintains existing reports and dashboards and supports changes as needed.
• Produce materials to guide usage of analytics deliverables; assist with training.

Skills

SQL

Power Query

Power Pivot

Excel advanced

Power BI

Data visualization

Education

Bachelor's degree

Master's degree

Tools

Snowflake

dbt

EMR data tools

ETL tools

Job description

Our promise to you:

Joining AdventHealth is about being part of something bigger. It’s about belonging to a community that believes in the wholeness of each person, and serves to uplift others in body, mind and spirit. AdventHealth is a place where you can thrive professionally, and grow spiritually, by Extending the Healing Ministry of Christ. Where you will be valued for who you are and the unique experiences you bring to our purpose-minded team. All while understanding that together we are even better.

All the benefits and perks you need for you and your family:

• Benefits from Day One: Medical, Dental, Vision Insurance, Life Insurance, Disability Insurance

• Paid Time Off from Day One

• 403-B Retirement Plan

• 4 Weeks 100% Paid Parental Leave

• Career Development

• Whole Person Well-being Resources

• Mental Health Resources and Support

• Pet Benefits

Schedule: Full time

Shift: Day (United States of America)

Address: 900 HOPE WAY

City: ALTAMONTE SPRINGS

State: Florida

Postal Code: 32714

Job Description:

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.

Knowledge, Skills, and Abilities:

• Fundamental awareness of data querying techniques (i.e., Structured Query Language, Power Query, Power Pivot) [Required]
• Proficiency in Microsoft Office products Word, Outlook, PowerPoint [Required]
• Advanced knowledge of Excel or other databasing software to organize data, develop data models for analysis, and create visualizations [Required]
• Basic knowledge of one or more business intelligence tools (e.g., Power BI, Tableau, Business Objects, QlikView, Oracle Business Intelligence, HPM, Minitab or similar.) [Required]
• Proficiency in performance of basic mathematical and statistical concepts (e.g., regression analysis) [Required]
• 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 [Required]
• 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 [Required]
• 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 [Required]
• 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 [Required]
• 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 [Required]
• Intermediate knowledge of healthcare and Revenue Cycle operations [Preferred]

Education:

• Bachelor's [Required]
• Master's [Preferred]

Field of Study:

• in Computer Science, Business Intelligence, Data Analytics, Industrial Engineering, Finance or related field

Work Experience:

• 3+ in Microsoft Excel with strong knowledge of utilizing conditional formatting, PivotTables, PivotCharts, functions, and formulas [Required]
• 1+ years of experience with Power BI or similar data visualization tools [Required]
• 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 [Preferred]

Additional Information:

• An equivalent combination of education and relevant work experience may be considered in lieu of the stated degree requirement:- Bachelors degree OR-2+ years of progressive practical related work experience

Licenses and Certifications:

• Project Management Professional (PMP) [Preferred]
• Six Sigma [Preferred]
• Change Management Certification (PROSCI) [Preferred]

Physical Requirements: (Please click the link below to view work requirements)

Physical Requirements - https://tinyurl.com/23km2677

Pay Range: $60,756.80 - $113,006.40

Background Screening Requirement (Florida Law)

Certain positions are subject to Florida Level 2 background screening, including fingerprinting, as required by state law.

Applicants may review general information about Florida’s background screening requirements at the Florida Care Provider Background Screening Clearinghouse: https://info.flclearinghouse.com/

This facility is an equal opportunity employer and complies with federal, state and local anti-discrimination laws, regulations and ordinances.