Senior Data Modelling Consultant
Senior Data Modelling Consultant
Location: London (Hybrid) | Practice Area: Data & Analytics | Type: Permanent
Shape Enterprise Data Models. Drive Data Transformation. Turn Complex Data into Business Value.
The Role
We're looking for an experienced Senior Data Modelling Consultant to join Capco's Data & Analytics practice, delivering complex data modelling and transformation initiatives for leading financial institutions. You'll combine technical expertise with strong analytical skills to design enterprise-grade data models that support business needs, data migrations and modern data architectures.
You'll take ownership of modelling decisions, challenge assumptions and help clients improve data quality, consistency and governance. Working closely with business and technical stakeholders, you'll translate complex requirements into scalable, well-structured models that deliver lasting business value.
Alongside client delivery, you'll contribute to strengthening Capco's data modelling capabilities, promoting best practices and supporting efficient, AI-enabled ways of working.
What You'll Do
-
Lead data modelling activities, translating business requirements into clear, scalable data structures.
-
Design conceptual, logical and physical data models to support complex transformation programmes.
-
Define data entities, relationships and source-to-target mappings, ensuring accuracy and consistency.
-
Support data governance, metadata management and modelling standards across client engagements.
-
Use modelling tools and approved AI-assisted workflows to improve documentation and analysis, with human validation and appropriate data safeguards.
What We're Looking For
-
Proven experience delivering complex data modelling initiatives within Financial Services environments.
-
Strong analytical judgement, with the ability to challenge requirements and resolve modelling challenges.
-
Experience translating business needs into accurate, maintainable data models and documentation.
-
Ability to collaborate with technical and business teams, ensuring modelling quality and consistency.
-
Excellent communication and stakeholder management skills, with a focus on delivering measurable client value.
-
Experience delivering data modelling within Financial Services, including data migration or architecture programmes.
-
Strong knowledge of conceptual, logical and physical modelling, including entities, relationships and source-to-target mapping.
-
Familiarity with financial industry reference models, including FpML, FIX or FIBO.
-
Experience with data model documentation, metadata management, stakeholder engagement and data governance standards.
-
Understanding of RDBMS, UML, JSON/XML schemas and project delivery lifecycles, with Agile experience preferred. Experience using data modelling tools, with no specific product required.
Bonus Points For
-
Hands-on experience with data modelling tools such as Erwin, Sparx or Visual Paradigm.
-
Experience with ontologies and semantic technologies, including RDF, OWL or TTL.
-
Exposure to Python or SQL scripting to support data modelling.
-
Knowledge of data governance and enterprise metadata integration strategies.
-
Experience supporting 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.
Benefits
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 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.
-
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 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 #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.
#LI-DNI
Apply for this job
*
indicates a required field