Senior Data Engineer

The Opportunity

We are supporting a major data platform transformation within a banking environment, moving from a legacy SQL Server and SSIS-based setup to a modern, scalable architecture built on dbt, Dagster, and OpenShift.

This role is not about maintaining existing systems. It is about rebuilding a critical data platform from the ground up, with direct impact on risk, trading PnL, and core financial data flows.

We are looking for a hands-on Senior Data Engineer who can take ownership of complex migration workstreams and deliver reliably in a regulated, high-stakes environment.

What You Will Do

You will play a central role in the end-to-end migration and modernisation of the data platform.

Platform Transformation

Translate legacy ETL logic from SSIS and stored procedures into modern ELT pipelines using dbt

Implement Data Vault 2.0 structures including Raw Vault and Business Vault

Build datamarts and curated datasets for downstream analytics and reporting

Orchestration & Infrastructure

Design and operate workflows using Dagster, including scheduling, dependencies, and recovery mechanisms

Deploy and run data workloads on OpenShift / Kubernetes environments

Event-Driven Data Processing

Enable near real-time data processing using Kafka-triggered pipelines

Integrate with upstream data lake environments and external data providers

Data Quality & Validation

Establish robust data validation and reconciliation processes

Implement automated testing and monitoring using dbt

Operational Ownership

Support production pipelines and resolve incidents when required

Create clear documentation and ensure operational readiness

Continuously improve performance, reliability, and maintainability

What You Will Do

You will play a central role in the end-to-end migration and modernisation of the data platform.

Platform Transformation

Translate legacy ETL logic from SSIS and stored procedures into modern ELT pipelines using dbt

Implement Data Vault 2.0 structures including Raw Vault and Business Vault

Build datamarts and curated datasets for downstream analytics and reporting

Orchestration & Infrastructure

Design and operate workflows using Dagster, including scheduling, dependencies, and recovery mechanisms

Deploy and run data workloads on OpenShift / Kubernetes environments

Event-Driven Data Processing

Enable near real-time data processing using Kafka-triggered pipelines

Integrate with upstream data lake environments and external data providers

Data Quality & Validation

Establish robust data validation and reconciliation processes

Implement automated testing and monitoring using dbt

Operational Ownership

Support production pipelines and resolve incidents when required

Create clear documentation and ensure operational readiness

Continuously improve performance, reliability, and maintainability

Requirements

What You Bring

Technical Expertise

Strong experience with SQL Server and T-SQL, including performance optimisation

Proven hands-on experience with dbt in production environments

Solid experience with workflow orchestration tools, ideally Dagster

Practical knowledge of Data Vault 2.0 modelling concepts

Experience working with container platforms such as OpenShift or Kubernetes

Familiarity with event-driven architectures and Kafka

Domain Experience

Experience working with financial data, ideally in banking or trading environments

Understanding of risk and PnL data structures is a strong advantage

Working Style

Strong ownership mindset with the ability to work independently

Structured, pragmatic, and delivery-focused

Comfortable operating in complex and regulated environments

Clear communicator across both technical and business stakeholders

What Success Looks Like

Within the first months, you will have:

Delivered initial Data Vault structures and migrated datasets into the new platform

Established stable, event-driven pipelines

Ensured data consistency and validation between legacy and new systems

Contributed to a production-ready, scalable data platform