> Markdown version of [/jobs/ext/347619-senior-data-modelling-consultant](https://www.wearedevelopers.com/jobs/ext/347619-senior-data-modelling-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data Modelling Consultant

- **Company:** Capco
- **Location:** Edinburgh, UK
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** XML Schema, Agile Methodology, Big Data, Data Governance, Data Transformation, Data Migration, Relational Databases, JSON, Python (Programming Language), Meta-Data Management, SQL Databases, UML, Extensible Markup Language (XML), Physical Data Models, FpML
- **Published:** June 20, 2026
- **Apply:** https://uk.indeed.com/viewjob?jk=e0af28c2e2a88542

## About the Role

Do you have experience in XML?, * 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

## Description

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.

This role will sit in our Scotland office, with a need to potentially work in either Edinburgh or Glasgow depending on client expectations.

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)


## Related Videos

- [ChatGPT and Java: A Match Made in Heaven or Hell?](https://www.wearedevelopers.com/videos/536-chatgpt-and-java-a-match-made-in-heaven-or-hell)
- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means)
- [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure)
- [Beyond UML: Making Sense of AI-Generated Code through Visual Architecture](https://www.wearedevelopers.com/videos/2102-beyond-uml-making-sense-of-ai-generated-code-through-visual-architecture)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023)
- [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)
- [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)