Business Intelligence Analyst
About the Company:
Avalon Healthcare Solutions, headquartered in Tampa, Florida, is the world’s first and only Lab Insights company, bringing together our proven Lab Benefit Management solutions, lab science expertise, digitized lab values, and proprietary analytics to help healthcare insurers proactively inform appropriate care, reduce costs, and improve clinical outcomes. Working with health plans across the country, the company covers more than 36 million lives and delivers 7-12% outpatient lab benefit savings. Avalon is pioneering a new era of value-driven care with its Lab Insights Platform that captures, digitizes, and analyzes lab results in real time to provide actionable insights for earlier disease detection, ensuring appropriate treatment protocols, and driving down overall cost.
Studies show that 30% of clinical laboratory testing is unnecessary or overused. Inappropriate testing or missing a key screening can lead to complications and expense arising from unwarranted care, or not obtaining proper care when needed, leading to increased health risks and costs. Avalon helps ensure delivery of the right test, at the right time, and in the right setting. We seek to ensure the most effective patient treatment, improve clinical outcomes, and optimize cost and affordability.
Avalon is a portfolio company of Francisco Partners, a global private equity firm that specializes in investments in technology and technology-enabled service companies.
Avalon is a high growth company where every associate has an opportunity to make a difference. You will be part of a team that shapes a new market and business. Most importantly, you will help Avalon to achieve its mission and improve clinical outcomes and health care affordability for the people we serve.
For more information about Avalon, please visit www.avalonhcs.com.
Avalon Healthcare Solutions is proud to be an equal opportunity employer including disability/veteran. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status.
About the Business Intelligence Analyst Position:
The Business Intelligence Analyst will drive data-driven reporting to support Avalon’s client, product, and operational data needs, collect and organize reporting and business requirements, and create dashboards that empower internal and external stakeholders to make actionable, data-driven decisions. This will include mining, cleaning, aggregating, and formatting data for consumption by internal and external stakeholders. Documentation of work and attention to detail are essential components of this position.
Business Intelligence Analyst – Essential Responsibilities:
- Develop SQL queries, views, and stored procedures for ad-hoc reporting needs
- Review and validate client data for integration with Avalon’s systems
- Leverage SQL querying to perform deep dive analytics to identify relationships and driving factors associated with key outcomes
- Collaborate with Data Engineering to define the data model, data aggregation, and performance needs for the underlying data that will be used in the dashboards (PowerBI)
- Create and document dashboards for the Client Management, Product, and other internal teams that allow them to make data-driven decisions and proposals using a common view of the data and clear, consistently defined metrics
- Ensure that Client Management has the metrics, drill-down, and reporting capabilities they need to provide contractual reports and respond to client questions and investigations
- Adhere to company and industry compliance, regulatory, and best practice standards
- Self-starter; identify and leverage relevant data to diagnose situations, identify potential solutions and drive results
- Successfully manage multiple projects at a time
- Act as subject matter expert and create training materials on self-service dashboard
Business Intelligence Analyst – Minimum Qualifications:
- At least 2 years of employment experience in an analytical role
- Bachelor’s degree in data analytics, computer science, management information systems, mathematics, or statistics, or equivalent work experience
- Analytical and interpretation skills, ability to review data and gain insight
- Ability to apply knowledge gained from one project to subsequent projects
- Experience writing SQL queries
- Experience with PowerBI and/or Tableau
- Healthcare industry experience
- Experience with SSRS/PowerBI Report Server
- Experience with Snowflake and/or Databricks