Data Engineer - Healthcare Claims & Analytics

Avalon Healthcare Solutions is seeking a Data Engineer II - Analytics to transform raw data into reliable systems for analytics and modeling. The role maintains and builds data pipelines, supports the analytics infrastructure, and ensures accurate, high-quality data is available to internal and external clients.

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)