Senior Data Engineer

Job summary

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.

Qualifications

• 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

Responsibilities

• 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

Degrees

Industry

Contract length