Senior Data Modelling Consultant

Capco; City Of London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

A leading consulting firm is looking for a Senior Data Modelling Consultant in London to work with top-tier financial services clients. In this hybrid role, you will design enterprise-grade data models, conduct business analysis, and drive data governance. Ideal candidates have strong data modelling expertise and experience in financial services. The firm offers a competitive benefits package and a collaborative work culture.

Benefits

Discretionary bonus

Health insurance

Competitive pension

Paid parental leave

Continuous learning opportunities

Gym membership

Travel insurance

Qualifications

• Proven experience in financial services data modelling.
• Strong grasp of data modelling layers and standards.
• Familiarity with financial reference models.

Responsibilities

• Conduct business analysis to define data requirements.
• Design and deliver conceptual, logical, and physical data models.
• Identify data entities and relationships.

Skills

Data modelling expertise

Analytical mindset

Business analysis

Stakeholder engagement

Tools

Erwin

Sparx

Power Designer

Python

SQL

Job description

Overview

Location: London (Hybrid) | Practice Area: Data & Analytics | Type: Permanent

Transform data structure. Model business value. Build data-driven futures.

The Role

Capco is hiring a Senior Data Modelling Consultant to help shape and implement enterprise-grade data models for top-tier financial services clients. In this role, you'll use your analytical mindset and modelling expertise to drive business understanding, support large-scale data migrations, and deliver best-practice modelling solutions aligned to industry standards.

What You’ll Do

• Conduct business analysis to define data requirements and support metadata management
• Design and deliver conceptual, logical, and physical data models for complex data programmes
• Identify data entities and relationships and map source-to-target transformations
• Support data governance activities including standards enforcement and review forums
• Use modelling tools (e.g. Sparx, Erwin, Power Designer) to develop, curate and refine models

What We’re Looking For

• Proven experience in financial services data modelling within data migration or architecture programmes
• Strong grasp of data modelling layers and standards (conceptual, logical, physical)
• Familiarity with financial reference models such as fpML, FIX, or FIBO
• Skilled in data model documentation, stakeholder engagement, and metadata practices
• Understanding of RDBMS, UML, JSON/XML schemas, and project lifecycles (Agile preferred)

Bonus Points For

• Hands-on experience with data modelling tools such as Erwin, Sparx, Visual Paradigm
• Experience working with ontologies and knowledge of RDF/OWL/TTL
• Exposure to Python or SQL scripting in support of data model design
• Knowledge of data governance and enterprise metadata integration strategies
• Background in working on regulatory or compliance-related data transformation initiatives

Why Join Capco

• Deliver high-impact technology solutions for Tier 1 financial institutions
• Work in a collaborative, flat, and entrepreneurial consulting culture
• Access continuous learning, training, and industry certifications
• Be part of a team shaping the future of digital financial services
• Help shape the future of digital transformation across FS & Energy

We offer a competitive, people-first benefits package designed to support every aspect of your life:

• Core Benefits: Discretionary bonus, competitive pension, health insurance, life insurance and critical illness cover.
• Mental Health: Easy access to CareFirst, Unmind, Aviva consultations, and in-house first aiders.
• Family-Friendly: Maternity, adoption, shared parental leave, plus paid leave for sickness, pregnancy loss, fertility treatment, menopause, and bereavement.
• Family Care: 8 complimentary backup care sessions for emergency childcare or elder care.
• Holiday Flexibility: 5 weeks of annual leave with the option to buy or sell holiday days based on your needs.
• Continuous Learning: Minimum 40 Hours of Training Annually: take workshops, certifications, e-learning—your growth, your way. Also, a Business Coach assigned from Day One for guidance to fast-track goals.
• Healthcare Access: Convenient online GP services.
• Extra Perks: Gympass (Wellhub), travel insurance, Tastecard, season ticket loans, Cycle to Work, and dental insurance.

Inclusion at Capco

We’re committed to making our recruitment process accessible and straightforward for everyone. If you need adjustments at any stage, let us know—we’ll be happy to help. We value each person’s unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration — a mindset that shapes how we work with clients and each other every day.

We have been informed of several recruitment scams targeting the public. We strongly advise you to verify identities before engaging in recruitment related communication. All official Capco communication will be conducted via a Capco recruiter.

EEO Notice

Capco does not and shall not discriminate on the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status, in any of its activities or operations. In order to track the effectiveness of our recruiting efforts, please consider participating in the optional questionnaire.

Select... I identify my ethnicity group as * Select... I identify my ethnicity sub group as * Select...

By checking this box, I consent to Capco collecting, storing, and processing my responses to the demographic data surveys above. *