Role: Data Engineer (DBT/Snowflake – Ops Team) Location: 100% Remote (EST Hours Only) Duration: 6+ months (Contract) Need Legacy Operations – Insurance Overall initiative for all four openings: • This is a legacy foundation upgrade and a new build. • Background: Recently migrated data into snowflake that was run on prem and they need to solidify areas focused on core data elements around providers and member population and how that all integrates other systems. • Current flow of the system is sending data into vendors (Milliman Insights) and into their instances of Epic. These two pathways are putting a strain on existing world, in addition to the remaining analytics they are putting on top of this. Thus, showing cracks in the systems. • Solution: rebuild, start with a blank slate in some cases, while also keeping existing systems running. To do this, they have been shuffling some people around to make this work, so there will be backfills, and net new openings. • Some of these roles will be supporting their legacy operations, and some of the roles will be working on the teams doing the net new builds Project Scope (dig into details here): • Will be supporting existing operational work Must-Haves (Concepts & Tools): • DBT • Snowflake (data warehouse) • Data ingestion with Azure Data factory • Data analysis, root cause analysis • Must be able to trouble shoot, identify issue, do the analysis and propose a solution. • See and issue and do validation. • Senior level What Will Win (formerly known as “Nice-to-Haves”): • Payer/ population health- insurance experience (united health, cigna, blue cross) • Operations background Soft Skill Requirements: • Problem Solver