ETL Developer (MUST HAVE "Epic or Mosaic" Exp)
Core
Extracting and loading data from Epic and Mosaic electronic medical record systems into Oracle Enterprise Healthcare Analytics and data lakes to support precision medicine objectives for a network of community hospitals.
Role type
ETL Developer
Builds
Data extracts, ETL pipelines, and integrated data flows for hospital onboarding
Domain
Healthcare / Electronic Medical Records (EMR)
Deliverable
production ML models | product features | dashboards & analysis | research | client delivery | infrastructure | physical/clinical work
Required skills
Epic system experience, Mosaic system experience, Oracle Data Integrator (ODI), Toad, GIT source control, data profiling, data cleansing, data mapping, validation
Preferred skills
Oracle Enterprise Healthcare Analytics experience
Technologies
Epic, Mosaic, Oracle Data Integrator, Toad, GIT, Oracle Enterprise Healthcare Analytics
Responsibilities
Extract data from Epic and Mosaic systems, load extracts into Oracle Enterprise Healthcare Analytics System, develop new ETLs to load partner data into data lake/warehouse/mart, troubleshoot extraction issues, perform data code mapping and validation, ensure compliance with HIPAA/security/privacy policies
Seniority
Mid-level (2-5+ years experience)