Cloud Data Engineer - Epic Clarity to BigQuery 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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer (Epic Clarity Migration)
Data Engineer (Epic Clarity 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 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
#138807 - Senior Data Platform Engineer
#138807 - Senior Data Platform Engineer

Lifted, an Upwork Company™ • Jeeta

Remote
EUR 83,000 - 124,000
Cloud Data Engineer — Hybrid & GCP Data Platform
Cloud Data Engineer — Hybrid & GCP Data Platform

SEB • Parainen

Hybrid
EUR 75,000 - 110,000
Hybrid working
Gym access
Restaurant nearby
+2
Senior GCP Cloud Migration Engineer
Senior GCP Cloud Migration Engineer

Hyqoo • Finland

Remote
EUR 90,000 - 120,000
Senior Data Engineer – Hybrid Health Lakehouse
Senior Data Engineer – Hybrid Health Lakehouse

Tieto Corp. • Kuopio

Hybrid
EUR 70,000 - 100,000
Senior Data Specialist / Data Engineer Freelancer
Senior Data Specialist / Data Engineer Freelancer

PRIORITY • Helsinki

On-site
EUR 80,000 - 120,000
Senior Technical Consultant (Freelance)
Senior Technical Consultant (Freelance)

Eurobase People • Finland

On-site
EUR 90,000 - 140,000
Lead Data Infrastructure Engineer - Hybrid/Remote
Lead Data Infrastructure Engineer - Hybrid/Remote

The Extravagant Company Oy Ltd • Helsinki

Hybrid
EUR 90,000 - 130,000
Hybrid work model in Helsinki
Top locations