Senior Data Modelling Consultant

Overview

In this Senior Data Modelling Consultant role at Capco, you will shape enterprise-grade data models for large financial services clients and guide data migrations. You’ll translate business needs into robust conceptual, logical, and physical models while promoting data governance and standards. You’ll work with cross-functional teams to deliver best-practice solutions and contribute to Capco’s digital transformation agenda. This role offers impact at scale within a collaborative, entrepreneurial culture.

Pay / Benefits

• Discretionary bonus
• Competitive pension
• Health insurance
• Mental health resources
• Family-friendly leave policies
• Flexible holiday options

Responsibilities

• Define data requirements through business analysis and metadata management
• Design and deliver conceptual, logical, and physical models for complex programs
• Identify data entities, map source-to-target transformations
• Support data governance activities including standards enforcement and reviews
• Use modelling tools (Sparx, Erwin, Power Designer) to develop and refine models

Key requirements

• Proven experience in financial services data modelling within data migration or architecture programmes
• Strong grasp of data modelling layers (conceptual, logical, physical)
• Familiarity with FPML, FIX, or FIBO reference models
• Skilled in data model documentation, stakeholder engagement, and metadata practices
• Understanding of RDBMS, UML, JSON/XML schemas, and Agile project lifecycles

• Stakeholder engagement
• Communication
• Problem solving
• Sparx
• Erwin
• Power Designer

…