Data Engineer - Healthcare Claims & Analytics

Avalon Healthcare Solutions is a healthcare analytics company focused on transforming diagnostic testing through data-driven solutions. The Data Engineer II will transform raw data into reliable systems, maintain and improve data pipelines, support analytics infrastructure, and ensure data quality for internal and external consumers.

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

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)
• 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)