Senior Data Modelling Consultant

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

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

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.

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)

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 life cycles (Agile preferred)

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

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:

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

We're committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just 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 #Be Yourself At Work  culture encourages individuality and collaboration - a mindset that shapes how we work with clients and each other every day.

#LI-DNI

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.