Data Engineer - DBT/Snowflake - Milliman Build - W2 (NO C2C, NO 1099) - Remote EST - Posted by Tauqeer

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)
No Travel Required

Skills

Snowflake
Azure Data factory
Data Warehouse
Milliman
healthcare
insurance
Medicaid
DBT
Health Insurance

Job Details

Required Skills in order: DBT, Snowflake, Data ingestion with Azure Data factory (will have various ingestions requests), Data Modeling, Medinsight from Milliman - looking for someone who has experience with Milliman tool Medinsight - trying to find someone with this experience to start, may have flex after a few days for someone with strong provider healthcare insurance data/Medicare and Medicaid data but for now looking for this specific tool.
Additional Skills :
specific experience implementing Medinsight into a new environment
additional experience on implementation projects around Medicare and Medicaid data
Job Description :

1X Engineer, New Build Milliman

Qual Template

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
  • What is the problem we are trying to solve, and how do we solve it

    Why is req open?

  • New development

    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

    Soft Skill Requirements

  • Solution oriented
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.