Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and modernise data architectures in the financial services sector.
- Company: Leading financial services firm focused on innovation and technology.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Why this job: Join a dynamic team and shape the future of data in finance.
- Qualifications: Experience with CDC, Db2, z/OS, and strong data modelling skills.
- Other info: Fast-paced environment with potential for significant career advancement.
The predicted salary is between 36000 - 60000 £ per year.
Ideal Background
- Financial services background (banking, payments, capital markets)
- Mix of mainframe and modern technology experience
- Track record of modernizing legacy systems
- Production support and incident management experience
Must-Have
- Change Data Capture: CDC design and operations (IBM, Precisely, or equivalent); subscription management, bookmarks, replay, backfill.
- Db2 & z/OS knowledge: Db2 catalog, z/OS fundamentals, batch windows, performance considerations.
- Integration patterns: Kafka/MSK hands-on, CDC-to-target pipelines, UPSERT/MERGE logic; Python/SQL; strong troubleshooting.
- Data quality mindset: Write validation tests before migration; golden-source reconciliation.
Data Architecture Fundamentals (Must-Have)
- Logical data modeling: Entity-relationship diagrams, normalization (1NF through Boyce-Codd/BCNF), denormalization trade-offs; identify functional dependencies and anomalies.
- Physical data modeling: Table design, partitioning strategies, indexes; SCD types; dimensional vs. transactional schemas; storage patterns for OLTP vs. analytics.
- Normalization & design: Normalize to 3NF/BCNF for transactional systems; understand when to denormalize for queries; trade-offs between 3NF, Data Vault, and star schemas.
- Domain-Driven Design: Bounded contexts and subdomains; aggregates and aggregate roots; entities vs. value objects; repository patterns; ubiquitous language.
- Event-driven architecture: Domain events and contracts; CDC as event streams; idempotency and replay patterns; mapping Db2 transactions to event-driven architectures; saga orchestration.
- CQRS patterns: Command/query separation; event sourcing and state reconstruction; eventual consistency; when CQRS is justified for mainframe migration vs. overkill.
- Database internals: Index structures (B-tree, bitmap, etc.), query planning, partitioning strategies; how Db2 vs. PostgreSQL differ in storage and execution.
- Data quality & validation: Designing test suites for schema conformance; referential integrity checks; sampling and reconciliation strategies.
Nice-to-Have
- None listed.
Data Architect in London employer: Bounteous
Contact Detail:
Bounteous Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect in London
✨Tip Number 1
Network like a pro! Reach out to folks in the financial services sector, especially those who know their way around data architecture. Attend meetups or webinars, and don’t be shy about sliding into DMs on LinkedIn – you never know who might have the inside scoop on job openings.
✨Tip Number 2
Show off your skills! Create a portfolio that highlights your experience with Change Data Capture, Db2, and event-driven architecture. Use real-world examples to demonstrate how you've tackled challenges in modernising legacy systems – this will make you stand out in interviews.
✨Tip Number 3
Practice makes perfect! Prepare for technical interviews by brushing up on your knowledge of integration patterns and data modelling. Consider mock interviews with friends or use online platforms to simulate the experience – it’ll help you feel more confident when it’s showtime.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got some fantastic opportunities waiting for talented Data Architects like you. Keep an eye on our listings and make sure your application shines – we’re excited to see what you bring to the table!
We think you need these skills to ace Data Architect in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the job description. Highlight your experience in financial services and any relevant tech skills, especially around CDC design and Db2. We want to see how your background fits with what we're looking for!
Showcase Your Projects: If you've worked on modernising legacy systems or have hands-on experience with integration patterns like Kafka, make it known! Include specific examples of projects where you’ve applied your data architecture knowledge. This helps us see your practical skills in action.
Be Clear and Concise: When writing your application, keep it straightforward. Use bullet points for key achievements and avoid jargon unless it's relevant. We appreciate clarity, so make it easy for us to see your qualifications at a glance!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy and ensures your application goes straight to the right team. Plus, we love seeing candidates who take that extra step!
How to prepare for a job interview at Bounteous
✨Know Your Tech Inside Out
Make sure you’re well-versed in the technologies mentioned in the job description, especially Change Data Capture and Db2. Brush up on your knowledge of integration patterns like Kafka and how they relate to CDC-to-target pipelines. Being able to discuss these topics confidently will show that you’re the right fit for the role.
✨Showcase Your Problem-Solving Skills
Prepare to discuss specific examples from your past experience where you’ve modernised legacy systems or handled production support. Think about challenges you faced and how you resolved them, particularly in relation to data quality and validation tests. This will demonstrate your practical knowledge and troubleshooting abilities.
✨Master Data Modelling Concepts
Brush up on logical and physical data modelling principles, including normalisation and denormalisation trade-offs. Be ready to explain how you would approach designing a database schema for different scenarios, as this is crucial for a Data Architect role. Use diagrams if possible to illustrate your thought process.
✨Understand Event-Driven Architecture
Familiarise yourself with event-driven architecture concepts, especially how they apply to CDC and Db2 transactions. Be prepared to discuss idempotency, replay patterns, and how you would implement these in a real-world scenario. This knowledge will set you apart as a candidate who truly understands modern data architecture.
