Data Engineer – Healthcare Claims, Analytics

Avalon Healthcare Solutions; Tampa (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor in Tampa, FL seeks a data engineer to monitor, maintain, and improve production data pipelines, build scalable ETL processes, and support analytics teams with data warehousing solutions. You will automate pipelines, participate in code reviews, and collaborate with stakeholders on multiple projects.

The ideal candidate has advanced SQL skills with MS SQL Server, experience in data warehousing, and familiarity with cloud services (Snowflake, AWS).

Qualifications

• Advanced SQL skills with MS SQL Server (T-SQL, SSIS/SSAS/SSRS)
• Experience with data warehousing and ETL pipelines
• Relational database design knowledge
• SQL performance tuning and access control
• Experience with version control (Git)
• Agile software development practices
• Excellent communication, problem solving, and organization
• Experience with data visualization tools (Tableau/PowerBI)
• Cloud-based solutions (Snowflake, AWS) preferred
• Healthcare data experience (claims data) preferred
• Proficiency in Python and healthcare data standards (HL7/EDI/FHIR) preferred
• Experience with event-driven streaming (Kafka) preferred

Responsibilities

• Monitor, maintain, and improve production data pipelines and processes
• Build scalable ETL processes extracting data from multiple sources
• Support analytical teams and tools using data warehouse products
• Automate data pipelines, monitoring, and maintenance
• Participate in code reviews, debugging, and version control
• Partner with stakeholders to understand data needs and deliver quality data products
• Collaborate with team on multiple projects
• Curate data for advanced analytics and data science
• Ensure data accuracy, quality, security, integrity, and reliability
• Maintain documentation of data, ETLs, processes, repositories, and issues
• Assess and report on data quality and align data systems with business goals
• Prepare raw data for modeling and assist in maintaining analytics infrastructure

Skills

SQL

ETL pipelines

Data warehousing

Git

Agile

Communication

Tableau

PowerBI

Snowflake

AWS

Python

HL7/EDI/FHIR

Kafka

Healthcare data

Tools

Microsoft SQL Server (T-SQL, SSIS, SSAS, SSRS)

Git

Tableau

PowerBI

Snowflake

AWS Cloud Services

Job description

• 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, debugging, and version control of code changes
• Partner with stakeholders to understand data needs and deliver quality data products
• Collaborate with team members on several projects at once
• Curate data for advanced analytics and data science
• Ensure data accuracy, quality, security, integrity, and reliability
• Maintain documentation of data, ETLs, processes, repositories, and issues
• Assess and report on data quality and align data systems with business goals
• Prepare raw data for modeling and assist in maintaining analytics infrastructure

Requirements

• 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)
• Experience with cloud-based solutions (Snowflake, AWS cloud services) preferred
• Experience with healthcare claims data preferred
• Proficiency in object-oriented programming skills (e.g. Python) preferred
• Knowledge of Healthcare data standards (e.g. HL7, EDI, FHIR) preferred
• Experience with event-driven data streaming platforms (e.g. Kafka) preferred

Core Competencies

Demonstrates expertise in building and maintaining ETL processes, ensuring data quality and integrity, and supporting analytical teams with data warehousing solutions. Proficient in SQL, data visualization tools, and cloud-based technologies, with a strong focus on collaboration and communication.

Tools & Technologies

• Microsoft SQL Server (T-SQL, SSIS, SSAS, SSRS)
• Tableau
• PowerBI
• Snowflake
• AWS Cloud Services