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 Shape Enterprise Data Models. Drive Data Transformation. Turn Complex Data into Business Value.
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Lead data modelling activities, translating business requirements into clear, scalable data structures.

  • Design conceptual, logical and physical data models to support complex transformation programmes.

  • Define data entities, relationships and source-to-target mappings, ensuring accuracy and consistency.

From the employer’s posting
- Lead data modelling activities, translating business requirements into clear, scalable data structures. -
- Design conceptual, logical and physical data models to support complex transformation programmes. -
- Define data entities, relationships and source-to-target mappings, ensuring accuracy and consistency. -

Benefits in the posting

Full benefits wording
  • -
  • 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.
  • 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

From the employer’s posting.

Apply at Capco

Posting record

Report an error

Open 8 monthsWe first saw this posting 246 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, 2026246 days ago
Recorded sightings
558
Last seen by us
Nov 22, 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 246

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,783 similar postings that came down, and 240 of Capco’s. Coming down is not always a hire.

Capco is hiring

102 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
- Exposure to Python or SQL scripting to support data modelling. -

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 246 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

Shape Enterprise Data Models. Drive Data Transformation. Turn Complex Data into Business Value.

The Role

We're looking for an experienced Senior Data Modelling Consultant to join Capco's Data & Analytics practice, delivering complex data modelling and transformation initiatives for leading financial institutions. You'll combine technical expertise with strong analytical skills to design enterprise-grade data models that support business needs, data migrations and modern data architectures.

You'll take ownership of modelling decisions, challenge assumptions and help clients improve data quality, consistency and governance. Working closely with business and technical stakeholders, you'll translate complex requirements into scalable, well-structured models that deliver lasting business value.

Alongside client delivery, you'll contribute to strengthening Capco's data modelling capabilities, promoting best practices and supporting efficient, AI-enabled ways of working.

What You'll Do

  • Lead data modelling activities, translating business requirements into clear, scalable data structures.

  • Design conceptual, logical and physical data models to support complex transformation programmes.

  • Define data entities, relationships and source-to-target mappings, ensuring accuracy and consistency.

  • Support data governance, metadata management and modelling standards across client engagements.

  • Use modelling tools and approved AI-assisted workflows to improve documentation and analysis, with human validation and appropriate data safeguards.

What We're Looking For

  • Proven experience delivering complex data modelling initiatives within Financial Services environments.

  • Strong analytical judgement, with the ability to challenge requirements and resolve modelling challenges.

  • Experience translating business needs into accurate, maintainable data models and documentation.

  • Ability to collaborate with technical and business teams, ensuring modelling quality and consistency.

  • Excellent communication and stakeholder management skills, with a focus on delivering measurable client value.

  • Experience delivering data modelling within Financial Services, including data migration or architecture programmes.

  • Strong knowledge of conceptual, logical and physical modelling, including entities, relationships and source-to-target mapping.

  • Familiarity with financial industry reference models, including FpML, FIX or FIBO.

  • Experience with data model documentation, metadata management, stakeholder engagement and data governance standards.

  • Understanding of RDBMS, UML, JSON/XML schemas and project delivery lifecycles, with Agile experience preferred. Experience using data modelling tools, with no specific product required.

Bonus Points For

  • Hands-on experience with data modelling tools such as Erwin, Sparx or Visual Paradigm.

  • Experience with ontologies and semantic technologies, including RDF, OWL or TTL.

  • Exposure to Python or SQL scripting to support data modelling.

  • Knowledge of data governance and enterprise metadata integration strategies.

  • Experience supporting 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.

Benefits

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 21% 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 81, the most 168, and the latest week had 91.
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 Shape Enterprise Data Models. Drive Data Transformation. Turn Complex Data into Business Value.
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.