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)
Requirements
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:
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
Benefits
Health insuranceDental insurancePerformance bonusParental leave
Additional Information
Senior Data Modelling Consultant
Location: Edinburgh (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.
Capco · United Kingdom