Explore careers with our portfolio companies

Technical Data Analyst

Avalon Healthcare Solutions

Avalon Healthcare Solutions

IT, Data Science
Posted on Friday, February 9, 2024

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.

Avalon Healthcare Solutions provides and maintains a drug-free workplace for its employees.

About the Technical Data Analyst Position:

The Technical Analyst will report to the Team lead/Senior Data Analyst on the team. They will be responsible for managing multiple core data functions in support of the Health Analytics, Financial Planning and Analysis, and Actuarial departments. Will provide data and technical expertise for the development of core models (Underwriting, forecasting, etc.), reports, special projects, and ad-hoc needs.

This position is eligible for remote work, but quarterly travel to the corporate office in Tampa, Florida may be required.

Technical Data Analyst – Essential Responsibilities:

  • Data extract/transform/and load (ETL)
  • Creation and maintenance of SQL scripts and stored procedures used in Underwriting/Pricing analysis and ad-hoc analysis
  • SQL Server database administration/maintenance
  • Automated/scheduled jobs creation and maintenance
  • Data reconciliation activities
  • Population/Maintenance of Tableau dashboards
  • Interfacing with IT on data formats/standards and consistency across departments

Technical Data Analyst – Minimum Qualifications:

  • 2-5 years in data management/technical processes
  • Bachelor’s degree in Management Information Systems or equivalent experience
  • Proficient in writing SQL queries and a good understanding of relational databases like SQLServer
  • Experience with the end-to-end pipeline of data analysis viz. data extraction, pre-processing, Data cleaning, mining, and visualization for deriving required results
  • Good experience with and knowledge of ETL and Data Analysis
  • Good experience with and knowledge of Database normalization and standardization

Technical Data Analyst – Preferred Qualifications:

  • Experience with automated jobs/scripts
  • Experience with Business Intelligence: Tableau, SPSS, Stata, Power BI for Office 365, MSBI (SSRS, SSIS, SSAS)