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.
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 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.
Top Skills
What the Team is Saying
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of
business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance,
and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent.
TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients.
DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success.
DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions.
ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
