How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
- 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 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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location