Data Engineer - Healthcare Claims & Analytics

About Avalon Healthcare Solutions:

Avalon Healthcare Solutions is the nation's leader in diagnostic intelligence, uniquely focused on transforming the role of diagnostic testing across the healthcare ecosystem. Our proprietary Diagnostic Insights Platform delivers evidence-based policies, curated lab networks, and real-time analytics that simplify complex diagnostics, accelerate innovation adoption, and optimize diagnostic investments.

Supporting over 30 health plans and 100 million members nationwide, Avalon partners with payers and providers to ensure diagnostic testing is performed appropriately, efficiently, and at the right time. Our flexible solutions span routine and genetic testing management, automated adherence, and end-to-end diagnostics support-driving measurable value, reduced waste, and improved clinical outcomes.

With unmatched scientific rigor, deep clinical expertise, and a performance-based model, Avalon is redefining how diagnostics power personalized care and healthcare value. 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 an Equal Opportunity Employer - Vet/Disability.

This position description is subject to change at any time. As determined by the company based upon business needs, an employee in this position may be required to perform duties and take responsibility for work other than as described in this document.

About the Data Engineer II - Analytics Position:

Within the analytics department, the Data Engineer will aid teammates by using various methods to transform raw data into useful data systems, preparing data for modeling, and assisting in maintaining the infrastructure used for analytics. The Data Engineer will also be responsible for assessing and reporting on data quality and striving for efficiencies by aligning data systems with business goals. This position entails ensuring the Business Intelligence team and the business owners have valid and reliable data available for consumption by internal and external clients.

This position is eligible for remote work, but quarterly travel will be required to Avalon's corporate office located in Tampa, Florida.

Data Engineer II - Analytics - Essential Functions and Responsibilities:

• Monitor, maintain, and improve existing production data pipelines and processes
• Build new reliable, scalable, efficient ETL processes extracting data from multiple sources
• Support analytical teams, tools, and programs using Data Warehouse products
• Automate data pipelines, monitoring, and maintenance
• Participate in code review, working to identify, debug, and version control code changes
• Partner with stakeholders to understand their data needs and deliver quality data products
• Collaborate with team members on several projects at once
• Employ strong analytical and organizational skills and attention to detail
• Curate data for advanced analytics and data science
• Ensure data accuracy, quality, security, integrity, and reliability
• Maintain documentation of data, ETLs, processes, repositories, issues, etc.

Data Engineer II - Analytics - Minimum Qualifications:

• Advanced SQL skills and knowledge of Microsoft SQL Server (T-SQL, SSIS, SSAS, SSRS)
• Experience with data warehousing and pipelines (ETLs, job scheduling, maintenance, monitoring, etc.)
• Knowledge of relational database design
• Experience with SQL performance tuning, role-based access, indexing
• Experience using git version control
• Agile software development best practices
• Excellent communication, problem solving, and organization skills
• Experience supporting data visualization tools (e.g. Tableau, PowerBI)

Data Engineer II - Analytics - Preferred Qualifications:

• Experience with cloud-based solutions (Snowflake, AWS cloud services)
• Experience with healthcare claims data
• Proficiency in object-oriented programming skills (e.g. Python)
• Knowledge of Healthcare data standards (e.g. HL7, EDI, FHIR)
• Event-driven data streaming platforms (e.g. Kafka)