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.
- Other info: Fast-paced environment with potential for significant career advancement.
- 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.
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
At Cartesian, we pride ourselves on fostering a dynamic and inclusive work culture that empowers our employees to thrive. As a Strategy & Analytics Consultant in the UK, you will benefit from extensive professional development opportunities, collaborative teamwork, and the chance to make a tangible impact on client success. Our commitment to innovation and excellence ensures that you will be part of a forward-thinking organisation that values your contributions and supports your career growth.
StudySmarter Expert Advice🤫
We think this is how you could land Data Architect in London
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Bounteous. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Data Architect in London
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Bounteous.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Bounteous's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Bounteous
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Bounteous.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Bounteous will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Bounteous employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.