W2:Lead Data Engineer, 100% Remote Job at Stellent IT LLC, Remote

eUNVTyttSEF5aFhpSFdibUJxL0dZZEVHMkE9PQ==
  • Stellent IT LLC
  • Remote

Job Description

Lead Data Engineer

100% Remote

Phone+Skype

Long term Contract

JD:

They MUST have EPIC Operational Data experience. Along with Snowflake, DBT, and SQL. We'd also want them to have Azure Devops experience to win.

They need to be able to do the engineering and architecture work.

Qual notes below along with the distinction between Billing and operational data in Epic. Need to focus on candidates that come from a Provider (Hospital) background and NOT from the Payer (insurance) side . Candidates could have both but they need the operational side which is the data related to a patient being admitted to the hospital and any associated data throughout their stay to discharge.

Notes:

In the EPIC EHR system, Operational Data and Billing Data serve different purposes and are used in distinct ways:

Operational Data

  • Purpose : This data is primarily used for the day-to-day operations of healthcare facilities. It includes information that supports clinical workflows, patient care, and administrative processes.
  • Examples : Patient demographics, clinical notes, lab results, medication records, appointment schedules, and other data related to patient care and hospital operations
  • Storage : Typically stored in EPIC's Chronicles database for real-time access and in Clarity for reporting and analytics

Billing Data

  • Purpose : This data is focused on the financial aspects of healthcare services. It is used for generating bills, processing insurance claims, and managing revenue cycles.
  • Examples : Charges for services rendered, insurance information, payment records, coding for procedures and diagnoses (e.g., ICD-10, CPT codes), and other financial transactions
  • Storage : Often integrated with EPIC's Resolute module, which handles billing and claims processing

Qual Template

Project Scope (dig into details here):

  • Looking for someone that understands the patient flows and orders, knows what the data does and the purpose of the data, etc
  • Building on top of EPIC core clarity data warehouse

Why is req open?

  • Backfilling current CE that lacks EPIC Operational Data experience

High-Level Individual Duties:

  • ETL ingestions and integrations
  • Build out the Snowflake Enterprise Data Warehouse and optimize data ecosystem
  • ETL troubleshooting
  • Work with engineers on business requirements and specs

Must-Haves (Concepts & Tools):

  • Epic Operational Data
    • Understanding how EPIC ecosystem fits together with Snowflake
  • Snowflake
  • DBT
  • SQL

What Will Win (formerly known as "Nice-to-Haves"):

  • CI/CD pipeline experience
  • Azure DevOps
  • Data Modeling

Soft Skill Requirements

  • Strong communication and versatility

Job Tags

Long term contract,

Similar Jobs

Community Medical Services

Substance Abuse Counselor Job at Community Medical Services

 ...Description Schedule: Monday - Friday 5:00 AM to 1:00 PM Community Medical Services (CMS) is hiring a Substance Abuse Counselor to assist patients recovering from addictions to opioids and other illicit substances. Whether facilitating individual or group sessions... 

CalOpps

Senior Lifeguard / Pool Manager for Summer 2026 (20695131) Job at CalOpps

 ...please visit:https://www.redcross.org/take-a-class/lifeguardinghttps://www.bappoa.org/trainingshttps://www.happyswimmers.com/red-cross-lifeguard-trainingWhat You Will Do Supervise and ensure patron safety at all times, including clearly and professionally... 

Markel

SIU Investigator Job at Markel

 ...others reach theirs. Join us and play your part in something special! This position will be responsible for the investigation of moderately complex suspect insurance claims and other matters pertaining to fraud, waste, and abuse. The position will require the ability to... 

Uniti Med

Travel Nurse RN - Med Surg - $1,871 per week Job at Uniti Med

 ...Uniti Med is seeking a travel nurse RN Med Surg for a travel nursing job in Montgomery, Alabama. Job Description & Requirements ~...  ...your talents to our open needs to ensure the ultimate travel experience. Tell us where you want to go and let our experienced staff lead... 

Royal Bank of Canada

Wealth Management Banker Job at Royal Bank of Canada

 ...Job Description What is the opportunity? Wealth Management Banker - Support RBC USWM field and management in growing the cash and lending business through serving as the key contact for financial advisors and their clients. The Wealth Management Banker will build...