CPH, DK & RemoteCapgemini consultant · open to freelance opportunities

Oscar Dyremyhr

>

I'm a Senior Consultant and Databricks Champion at Capgemini, focused on designing and delivering data platforms that hold up at scale. My recent work spans regulated pharma and financial services programmes, from platform governance to cloud migration and metadata-driven pipelines. I'm open to conversations about future freelance and contract opportunities, primarily in Databricks. Remote or on-site in the Nordics.

DatabricksDelta LakeUnity CatalogApache SparkAzure Data FactoryPythonSQLPySpark
Oscar Dyremyhr, portrait

What I focus on

Databricks Platform & Governance

Solution architecture, catalog structure, compute policies and asset permissions, set up so a platform team can run them as the number of teams grows.

Mainframe & Legacy Migration

Moving data off the mainframe and onto a cloud platform as part of a wider transformation, without losing sight of what the business relies on.

Metadata-Driven Pipelines

Building frameworks where pipelines are defined by metadata, so new data is delivered consistently and at scale instead of hand-built each time.

Bridging Tech and Stakeholders

Turning architecture decisions into something engineers and business stakeholders can both act on, which is where large programmes often stall.

Selected work

All case studies →
Financial services2025 — Present

Mainframe-to-Cloud Migration & Metadata-Driven ETL for a CSD

Data Engineer, Data Services · Central Securities Depository (CSD)

Data Engineer in the Data Services team on an ongoing Nordic transformation for a Central Securities Depository (CSD). The work moves mainframe data to the cloud and builds a metadata-driven ETL framework to deliver migration and data pipelines consistently across a large estate.

Pharma2024 — 2025

Databricks Platform Governance for a Global Pharma Programme

Databricks SME · Global pharmaceutical company

Served as the Databricks subject-matter expert within a large Nordic transformation programme for a global pharmaceutical company. Worked across engineering and stakeholder groups to shape platform architecture and the operating practices needed to govern it at scale.

Engineering & infrastructure2021 — 2023

Databricks Platform for an Engineering & Infrastructure Consultancy

Tech Lead, Capgemini (Oslo) · Large engineering and infrastructure consultancy

Built an Azure Databricks platform for a large engineering and infrastructure consultancy, then connected operational and finance data to reporting used across the business.

Recent writing

All posts →
data-engineering

Spark Partitioning — The Difference Between a 3-Minute and 3-Hour Job

Understanding shuffle partitions, data skew, and when to repartition versus coalesce.

Sep 11, 20244 min read
data-engineering

dbt Testing That Actually Catches Bugs

Moving beyond not_null and unique to tests that reflect your actual data contracts.

Jun 18, 20243 min read
data-engineering, databricks

The Medallion Architecture — Structuring Your Delta Lake for Scale

How to design a bronze, silver, gold lakehouse that stays maintainable as your data and team grow.

Mar 4, 20243 min read