Rodeo
ResourcesPartnersSign in

Women in Data®

Senior Data Modelling Consultant

London
Posted about 18 hours ago
Sign up to applySee more jobs like this

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

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

Reasons to use Rodeo

I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?

Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.

Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.

Start with a chat, not a search bar

Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.

See breakdown
Save jobNot relevant
View details

It searches the market for you

Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.

Why you're a good match

You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.

See breakdown
Strong

Experience fit

Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.

See breakdown
Strong

Only hits

No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.

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.

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

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

Women in Data® advertise roles on behalf of our partners, alliances, and members. We are proud supporters of Women in Data. Connect, engage and belong to the largest free female data community in the UK – visit: www.womenindata.co.uk to join our community. Stay connected! Follow us on LinkedIn for updates on career opportunities and more.

Trusted by 25,000+ job seekers

“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”

Jessica, London

Get help applying for this job

Skills

Data Modelling
Business Analysis
Metadata Management
Conceptual Data Modelling
Logical Data Modelling
Physical Data Modelling
Data Governance
Sparx
Erwin
Power Designer
Financial Services
Data Migration
RDBMS
UML
JSON
XML

Location

London, England, United Kingdom

Sign up to applySee more jobs like this