Data Modelling Senior Consultant

Posted 14 August 2025
LocationEdinburgh
Job type Permanent
Reference34437

Job description

Job Title: Senior Data Modelling Consultant
Location: London (Hybrid)
Data & Analytics
Permanent


The Opportunity
We’re seeking an experienced Senior Data Modelling Consultant to play a key role in the design and implementation of enterprise-grade data models within large-scale transformation programmes. This is an exciting opportunity to work with leading financial organisations, translating complex business requirements into data structures that drive clarity, governance, and scalable outcomes.

Key Responsibilities
  • Conduct analysis to define data requirements and support enterprise metadata initiatives
  • Design conceptual, logical, and physical data models for complex transformation and migration programmes
  • Identify key data entities, relationships, and source-to-target mappings across systems
  • Support data governance through model standardisation, documentation, and governance forums
  • Use modelling tools (e.g. Sparx, Erwin, PowerDesigner) to build, maintain, and curate enterprise data models

What You’ll Bring
  • Demonstrable experience in data modelling within financial services, especially across architecture or migration projects
  • Expertise across the full data modelling stack (conceptual, logical, physical)
  • Familiarity with financial reference models such as FIBO, FIX, or fpML
  • Ability to communicate data structures clearly to both technical and non-technical stakeholders
  • Solid understanding of relational databases (RDBMS), JSON/XML schemas, UML, and Agile delivery methodologies

Desirable Skills
  • Practical experience with data modelling tools such as Sparx, Erwin, Visual Paradigm, or PowerDesigner
  • Exposure to ontology development and semantic web technologies (e.g. RDF, OWL, TTL)
  • Working knowledge of SQL or Python to support data model validation or prototyping
  • Understanding of enterprise metadata strategies and data governance frameworks
  • Experience supporting regulatory or compliance-led data transformation initiatives

Why Join
  • Work on impactful projects with leading organisations across financial services and beyond
  • Join a collaborative and forward-thinking consultancy focused on innovation and problem-solving
  • Access structured learning paths, certifications, and coaching to support your personal and professional growth
  • Be part of a multidisciplinary team delivering end-to-end data transformation solutions
 
Research indicates that men will apply to a role when they only meet 50-60% of the descriptions, however, when looking at women and other minority groups, they can look for up to a 99% match in order to apply to a role. If you feel you are a fit for our role, please still apply, don’t worry if you don’t tick every single box. We’d still love to hear from you. We encourage underrepresented talent to apply to all our roles & support accessibility needs