Back to jobs

Senior Data Modelling Consultant

Pay
Pay not listed
Work setting
Hybrid — work setting source
Senior Data Modelling Consultant Location: London (Hybrid) | Practice Area: Data & Analytics | Type: Permanent Transform data structure. Model business value. Build data-driven futures.
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Design conceptual, logical and physical data models for complex data programmes

  • Conduct business analysis to define data requirements and metadata

  • Identify data entities and relationships and map source-to-target transformations

  • Support data governance, including standards enforcement and review forums

  • Build and refine models in tools such as Sparx, Erwin or PowerDesigner

From the employer’s posting
Design and deliver conceptual, logical, and physical data models for complex data programmes
Conduct business analysis to define data requirements and support metadata management
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
Apply at Capco

Posting record

Report an error

Open 8 monthsWe first saw this posting 243 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Mar 21, 2026243 days ago
Recorded sightings
555
Last seen by us
Nov 19, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 243

Up longer than most. Similar jobs usually come down between day 7 and day 51.

Well past Capco’s usual: its jobs come down by about day 39.

From 1,682 similar postings that came down, and 232 of Capco’s. Coming down is not always a hire.

Capco is hiring

104 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down at a usual pace
  • 2% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
Where the posting names them
- 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

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Has Capco posted this job before?

Yes. We’ve followed one other Senior Data Modelling Consultant job there since December 2025. It came down after 5 days.

  1. EdinburghCame down after 5 days, first seen Dec 13
  2. This jobUp 243 days so far, first seen Mar 21

Job description

View original posting ↗

Senior Data Modelling Consultant

Location: London (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.

#LI-DNI

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 20% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 82, the most 171, and the latest week had 93.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

UK - London

Senior Data Modelling Consultant Location: London (Hybrid) | Practice Area: Data & Analytics | Type: Permanent Transform data structure. Model business value. Build data-driven futures.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.