Senior Data Modelling Consultant

Senior Data Modelling Consultant

Full-Time 60000 - 80000 £ / year (est.) Home office (partial)

At a Glance

  • Tasks: Transform data structures and model business value for top-tier financial clients.
  • Company: Capco, a leading consulting firm in financial services.
  • Benefits: Competitive salary, generous leave, mental health support, and continuous learning opportunities.
  • Other info: Join a collaborative culture that values individuality and offers excellent career growth.
  • Why this job: Shape the future of digital transformation in finance while working with cutting-edge technology.
  • Qualifications: Experience in data modelling within financial services and strong analytical skills.

The predicted salary is between 60000 - 80000 £ per year.

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.

Senior Data Modelling Consultant employer: 慨正橡扯

Capco is an exceptional employer that fosters a collaborative and entrepreneurial culture, making it an ideal place for a Senior Data Modelling Consultant to thrive. With a strong commitment to employee growth through continuous learning opportunities, competitive benefits, and a people-first approach, Capco ensures that its team members are well-supported both professionally and personally. Located in London, the hybrid work model allows for flexibility while contributing to transformative projects for top-tier financial institutions.

Contact Details:

慨正橡扯 Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Senior Data Modelling Consultant

Tip Number 1

Network like a pro! Reach out to your connections in the financial services sector and let them know you're on the lookout for opportunities. You never know who might have a lead or can put in a good word for you.

Tip Number 2

Prepare for those interviews! Research common questions for data modelling roles and practice your responses. We recommend using the STAR method (Situation, Task, Action, Result) to structure your answers and showcase your experience effectively.

Tip Number 3

Showcase your skills with a portfolio! If you've worked on any data models or projects, compile them into a portfolio to demonstrate your expertise. This will give potential employers a tangible sense of what you can bring to the table.

Tip Number 4

Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining our team at Capco.

We think you need these skills to ace Senior Data Modelling Consultant

Data Modelling
Business Analysis
Metadata Management
Conceptual Data Models
Logical Data Models
Physical Data Models
Data Governance

Some tips for your application 🫡

Tailor Your CV:Make sure your CV is tailored to the Senior Data Modelling Consultant role. Highlight your experience in financial services data modelling and any relevant tools you've used. We want to see how your skills align with what we're looking for!

Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data modelling and how you can contribute to our team. Be sure to mention specific projects or experiences that showcase your expertise.

Showcase Your Analytical Mindset:In your application, demonstrate your analytical mindset by providing examples of how you've tackled complex data challenges in the past. We love seeing how you think and approach problems, so don't hold back!

Apply Through Our Website:We encourage you to apply through our website for a smooth application process. It’s the best way for us to receive your application and ensure it gets the attention it deserves. Plus, it shows you're keen on joining our team!

How to prepare for a job interview at 慨正橡扯

Know Your Data Models

Make sure you brush up on your understanding of conceptual, logical, and physical data models. Be ready to discuss how you've applied these in past projects, especially in financial services. This will show that you’re not just familiar with the theory but can also implement it effectively.

Showcase Your Analytical Mindset

Prepare examples that highlight your analytical skills and how you've used them to drive business understanding. Think about specific instances where your insights led to successful data migrations or improved modelling solutions. This will demonstrate your value to potential employers.

Familiarise Yourself with Tools

If you’ve worked with tools like Erwin, Sparx, or Power Designer, be ready to discuss your experience with them. If you haven’t, consider doing a quick tutorial or two to get a basic understanding. Being able to talk about these tools confidently can set you apart from other candidates.

Engage with Stakeholders

Prepare to discuss how you’ve engaged with stakeholders in previous roles. Highlight your communication skills and how you’ve managed expectations during data governance activities. This is crucial for a role that involves collaboration and stakeholder engagement.