Senior Data Engineer

Avacone
Basel, Switzerland
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
CHF 208K

Job location

Basel, Switzerland

Tech stack

Airflow
Automation of Tests
Data Validation
ETL
Data Structures
Data Vault Modeling
Microsoft SQL Server
Openshift
Performance Tuning
SQL Stored Procedures
SQL Server Integration Services
T-SQL
Data Processing
Event Driven Architecture
Containerization
Data Lake
Kubernetes
Kafka
Stream Processing
Data Pipelines

Job description

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., * 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

  • 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

Apply for this position