Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Skills
Milliman
Snowflake
DBT
Job Details
Title: Sr Data Engineer with Milliman
Location: Remote
Job Description:
DBT, Snowflake, Azure Data Factory and Milliman Implementation experience are the biggest needs. Milliman is a hard requirement!
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):
- Working on new operations while supporting some legacy work
- Focus on new vendor, Milliman Insights, bringing back their data model into their environment and figuring out how that fits into the future of this team.
- Milliman Insights takes raw claims data, runs that through their system, gives back a data model with X amount of tables that we can use for analytics. This will be part of MGBs pivot, will focus on using their data as the source of claims foundation as opposed to internal homegrown models.
- Building out solutions
Must-Haves (Concepts & Tools):
- DBT
- Snowflake (data warehouse)
- Data ingestion with Azure Data factory (will have various ingestions requests)
- Architect level
What Will Win (formerly known as Nice-to-Haves ):
- Previous Milliman experience
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.