Oscar Dyremyhr
Databricks Champion · Senior Consultant
Summary
Databricks Champion and data engineer with 6 years of experience, working on large, regulated Nordic programmes in pharma and financial services. Specialised in Databricks solution architecture, platform governance, mainframe-to-cloud migration and metadata-driven pipeline frameworks. Currently available for Databricks contract and consulting engagements, remote or on-site — open to broader data engineering work as well.
Experience
Senior Consultant — Insights & Data · Capgemini, Copenhagen, Denmark · Oslo, Norway
07/2023 — PresentData Engineer — Data Services
Financial services · Central Securities Depository
- Data Services team on a Nordic transformation programme for a Central Securities Depository.
- Migrating 1,000+ mainframe tables to the cloud using a metadata-driven model.
- Building a metadata-driven ETL framework so pipelines are defined by metadata and delivered consistently, at scale.
- Stack: Azure, Databricks, Kafka, Event Hubs, IBM IIDR.
Databricks SME
Pharma · Global pharmaceutical company · Platform & solution architecture
- Bridged the technical team and business stakeholders on solution architecture and platform administration.
- Defined platform best practices: compute policies, catalog structure and asset permissions.
- Part of the Nordic transformation unit behind a programme that delivered multi-million in business value.
Tech Lead — Data Warehouse Migration
Consulting
- Tech Lead for a team of 3 data specialists.
- Led migration of a legacy Data Warehouse from on-premise to Azure and Spark.
- Improved performance of existing ETL processes and SQL queries for daily CRM and ERP summary data.
Consultant — Insights & Data · Capgemini, Oslo, Norway
12/2021 — 07/2023Databricks Platform on Azure
Engineering & infrastructure consultancy · Planning, engineering and execution of large building projects
- Built a Databricks platform on Azure, with orchestration in Azure Data Factory.
- Onboarded 4 Power BI reports for easier HR reporting and finance reporting (ongoing, upcoming, settled and reimbursed projects), plus a company hierarchy.
- Used agile software development processes to make iterative improvements to back-end systems.
- Modeled front-end and back-end data sources to give a more complete picture of user flows and enable powerful data analysis.
- Built data pipelines that clean, transform and aggregate data from disparate sources.
Junior Systems Engineer — Data Warehouse Project · Helthjem Netthandel AS, Oslo, Norway
11/2020 — 07/2021- Built a cloud data warehouse in AWS for better ownership and transparency of data.
- Custom ETL job using AWS Glue, Lambda and Spark.
- Built dashboards in AWS QuickSight for tracking KPIs.
- Reduced average workflow for colleagues by one hour.
Skills
Databricks PlatformUnity Catalog, Compute Policies, Delta Lake, Solution Architecture
Data ProcessingApache Spark, PySpark, SQL, Python, R
Streaming & ReplicationKafka, Azure Event Hubs, IBM IIDR
Cloud & OrchestrationAzure, Azure Data Factory, ADLS, Azure SQL Database, AWS, GCP
DevOps & ToolingGit, DevOps, Atlassian
BI & AnalyticsPower BI, Tableau
Web (side projects)React, Next.js, Node.js, TypeScript
Certifications
- Databricks Champion
- Databricks Certified Data Engineer Professional (06/2023 — 06/2025)
- Databricks Certified Data Engineer Associate (06/2023 — 06/2025)
- Databricks Certified Data Analyst Associate (06/2023 — 06/2025)
Education
MSc in Business Analytics · BI Norwegian Business School
08/2018 — 09/2020BSc in Information Sciences and Technology · The Pennsylvania State University
08/2013 — 08/2018