Data Engineer (Epic Clarity Migration)

Zencore

Jyväskylä

On-site

EUR 78,120 - 122,760

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Zencore is seeking a Data Engineer to lead a high‑volume healthcare data migration from Oracle Clarity to Google BigQuery. You will bridge legacy on‑prem infrastructure with modern cloud architecture and own complex data type conversions.

You will design migration processes, develop automated SQL scripts, validate replication at scale, troubleshoot pipeline issues, and document data lineage for clinical reporting purposes.

Qualifications

  • Deep understanding of Clarity data model, ETL Console, and Oracle structures.
  • Advanced PL/SQL scripting and performance tuning.
  • Experience moving on-prem data warehouses to the cloud (ETL/ELT).
  • Proficiency in SQL; Python or Shell scripting for automation preferred.

Responsibilities

  • Design and execute migration from Oracle (Clarity) to Google BigQuery.
  • Handle schema mappings and data type conversions (timestamps, numerics, char sets).
  • Troubleshoot pipeline failures due to hardware latency and legacy constraints.
  • Develop automated SQL scripts and testing frameworks for data validation at scale.
  • Perform root cause analysis on data inconsistencies and document conversion logic.
  • Optimize SQL queries in BigQuery to manage costs and latency.
  • Collaborate with Data Analysts to verify business logic and clinical reporting.

Skills

Clarity data model
PL/SQL scripting
Cloud data migration
SQL proficiency
Python scripting
Shell scripting

Tools

Google BigQuery
Oracle
ETL/ELT

Job description

As a member of our Data Engineering team, you’ll be working to drive a high-volume healthcare data migration project. The core mission is moving a massive legacy Epic Clarity (Oracle) dataset to Google BigQuery. They will look at you as their trusted advisor, someone they can rely on and who will be there to help them along their journey on Google Cloud.

You will be the bridge between legacy on‑prem infrastructure and modern cloud architecture. This role requires deep technical knowledge of the internal workings of Epic Clarity schemas and the ability to solve complex data type conversion challenges when moving from Oracle to BigQuery.

Full Time Contract Role for approximately 6 months with an opportunity of extension

Responsibilities
  • Design and execute technical processes to migrate data from Oracle (Clarity) to Google BigQuery.
  • Handle complex schema mappings, specifically resolving incompatibilities between Oracle data types and BigQuery (e.g., handling timestamps, numerics, and character sets).
  • Troubleshoot pipeline failures related to hardware latency and legacy infrastructure constraints.
  • Develop automated SQL scripts and testing frameworks to validate data replication accuracy at scale.
  • Perform deep‑dive root cause analysis on data inconsistencies, distinguishing between genuine data errors and artifacts of the conversion process.
  • Create technical documentation for data lineage and conversion logic.
  • Optimize SQL queries for performance within the BigQuery environment to manage costs and reduce latency.
  • Collaborate with Data Analysts to verify business logic and ensure the migrated data meets clinical reporting standards.
Required Skills & Qualifications
  • Deep understanding of the Clarity data model, ETL Console, and underlying Oracle structures.
  • Advanced PL/SQL scripting, performance tuning, and understanding of Oracle legacy hardware constraints.
  • Proven track record of moving on‑premise data warehouses to the cloud (ETL/ELT).
  • Proficiency in SQL is mandatory. Experience with Python or Shell scripting for automation is highly valued.
Preferred Qualifications
  • Experience with BigQuery architecture, partition/clustering strategies, and Google Standard SQL.
  • Experience with HL7 and FHIR data standards.
  • Familiarity with data validation frameworks (e.g., Great Expectations, dbt tests).
  • Experience troubleshooting replication tools (e.g., GoldenGate, Dataflow, or similar CDC tools).
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Cloud Data Engineer - Epic Clarity to BigQuery Migration
Cloud Data Engineer - Epic Clarity to BigQuery Migration

Zencore • Jyväskylä

On-site
EUR 78,120 - 122,760
Cloud Architect
Cloud Architect

Hyqoo • Finland

Remote
EUR 120,000 - 160,000
Remote work
Senior Technical Consultant (Freelance)
Senior Technical Consultant (Freelance)

Eurobase People • Finland

On-site
EUR 90,000 - 140,000
Senior GCP Cloud Migration Engineer
Senior GCP Cloud Migration Engineer

Hyqoo • Finland

Remote
EUR 90,000 - 120,000
Senior Data Platform Engineer | Hybrid + Equity Options
Senior Data Platform Engineer | Hybrid + Equity Options

Smartly.io • Helsinki

Hybrid
EUR 90,000 - 130,000
Inclusive global culture
Global impact through technology
Wellbeing support
+2
Senior Data Specialist / Data Engineer Freelancer
Senior Data Specialist / Data Engineer Freelancer

PRIORITY • Helsinki

On-site
EUR 80,000 - 120,000
#138807 - Senior Data Platform Engineer
#138807 - Senior Data Platform Engineer

Lifted, an Upwork Company™ • Jeeta

Remote
EUR 83,000 - 124,000
Data Engineer
Data Engineer

Symple Lending, Inc. • Kirkkonummi

Hybrid
EUR 80,000 - 125,000
Competitive salary
Health insurance
Mentorship from Senior Data Engineer
+4
DBA & Bulk Data Management Engineer
DBA & Bulk Data Management Engineer

Webbing • Finland

Remote
EUR 60,000 - 90,000
Fully remote work
Skill and knowledge development opportunities
Professional development in an international environment
Senior Data Platform Engineer
Senior Data Platform Engineer

Smartly.io • Helsinki

Hybrid
EUR 110,000 - 140,000
Career development programs
Bonus programs and equity options
Generous healthcare packages
Top locations