Consultant/Senior Consultant - Data Modelling

Capgemini; Liverpool City Region; Hybrid; GBP 40,000 - 70,000; Full time

Job summary

A leading consulting firm is seeking dynamic team members for their Data-Driven Financial Risk & Compliance team. This role involves leveraging data modeling and stakeholder collaboration to redefine risk management. Ideal candidates will possess consultancy experience and technical skills in data governance and cloud platforms, preparing them to drive impactful transformations.

Benefits

Flexible working arrangements

Employee wellbeing programs

Professional development opportunities

Qualifications

• Minimum 2 years of experience in consulting or finance.
• Proficiency in SQL and programming languages like R or Python.
• Experience with cloud platforms is a plus.

Responsibilities

• Design and maintain data models.
• Collaborate with stakeholders to meet data requirements.
• Align data models with governance policies.

Skills

Data Modeling

Stakeholder Management

Agile Delivery

Data Analysis

Governance

Education

Bachelor's Degree in a relevant field

Tools

ER Studio

Oracle SQL Developer

JIRA

Job description

Capgemini

Glasgow, London, Manchester

GBP 40,000 - 70,000

Be among the first applicants.

6 days ago

At Capgemini Invent, we believe difference drives change. As inventive transformation consultants, we blend our strategic, creative and scientific capabilities, collaborating closely with clients to deliver cutting-edge solutions. Join us to drive transformation tailored to our client's challenges of today and tomorrow. Informed and validated by science and data. Superpowered by creativity and design. All underpinned by technology created with purpose.

Your Role

Join our fast-growing & collaborative Data-Driven Financial Risk & Compliance (DFRC) team and shape the future of risk and finance! We harness cutting-edge technology, AI-powered models, and cloud-first data platforms to transform risk management from a reactive function into a strategic powerhouse—driving growth, resilience, and competitive edge. Be part of a dynamic and inclusive team that’s redefining how businesses anticipate, manage, and capitalize on risk.

In this role you will have the opportunity to demonstrate the following:

• Data Model Development: Design, develop and maintain conceptual, logical and physical data models to provide structured view of data domains, entities, and their relationships.
• Data Documentation: Create and update data dictionaries, entity-relationship diagrams (ERDs), and metadata to ensure clarity and consistency.
• Stakeholder Collaboration: Collaborate closely with business stakeholders to understand data requirements and translate them into structured data models that meet business needs.
• Data Governance Alignment: Ensure models align with data quality, security, and governance policies.

While this role requires expertise in data modelling, we are looking for versatile team members, capable of successfully executing a diverse array of data-driven projects. This includes expertise in agile delivery, requirements gathering, data analysis, stakeholder management, governance, and compliance.

Your Profile

We are looking for candidates who bring a combination of technical expertise, consultancy experience, and leadership skills to excel in this role.

The ideal candidate will demonstrate most or all of the following bullet points:

Professional Experience:

• Current experience in a consulting firm and/or preferably Financial Services background (minimum 2 years of experience, dependent on grade) with evidence of effective stakeholder management to address business challenges.
• Beneficial to have experience in Financial Services data models like FSLDM, BIAN, Data Vault etc.
• Experience working across various stages of End-to-End Analytics /AI Transformation or Large-scale Deployments / Technology Implementation Programmes.
• Passionate about data with demonstrated ability in solving complex problems and leveraging the latest tools & technologies to create innovative data-focused solutions.
• The ability to simplify the complex, storytelling and bring to life the outcomes rather than just the steps to achieve them.

Technical and Analytical Skills:

• Extensive experience in and strong understanding of data modelling principles, data dictionaries and key data modelling tools such as ER studio, Oracle SQL Developer data.
• Knowledge of SQL and other programming languages such as R and Python.
• Strong understanding of data management, data quality, master data management and other data governance principles.
• Familiarity with project governance tools and artifacts for product delivery (e.g. JIRA, Epic and User Story, Backlog).
• Practical experience with agile methodologies such as Scrum, Kanban, or SAFe frameworks.
• Storytelling/presentation skills with the ability to present technical and non-technical concepts to a wide variety of audiences.

For candidates applying for the Senior Consultant role, we additionally require:

• Working experience with at least one Cloud Platform (AWS, Azure, GCP, Snowflake, Databricks etc.) and exposure to Cloud Architecture principles.
• Demonstrated experience in people management, product owner or workstream management.
• Experience supporting and participating in the commercial cycle, including defining project scope and agreeing on budgets.

WHAT YOU’LL LOVE ABOUT WORKING HERE?

Our DFRC team is part of the wider Data & AI Factory team within our Enterprise Data Analytics (EDA) team which takes pride in transforming clients’ businesses with Data & AI making a tangible difference for our clients, setting industry standards and unlocking business value.

By being part of the EDA team, you can grow your expertise, contribute to meaningful work, and celebrate successes as part of a dynamic team.
DFRC consultants will engage in projects designed to transform financial operations for our clients.

Our team’s expertise spans across several focus areas from risk based decisioning & analytics, credit risk, financial crime and KYC/AML to data privacy, governance and the many applications of GenAI within financial services.

At Capgemini Invent, our strong partnerships with our clients and partners allows us to harness the power of data and AI to address complex business challenges. We’re building a successful team of experts across risk and finance; leveraging these capabilities to solve intricate problems and unlock new opportunities in diverse sectors.

As a team:

• We value diversity: we embrace the value that diverse teams bring to our EDA practice and our clients.
• We focus on clients: positively impacting our clients data culture and operations.
• We are committed to learning and development: obsessed with advancing our data, insights and analytics skills.
• We're stronger when we collaborate: active collaboration and other Invent capabilities and with wider Capgemini, most notably I&D, Cambridge Consultants and with select third party alliances.
• We foster community: building new analytics and AI products and services through our functional and industry communities of interest.
• We believe data can be a driver for a better world: we will use our AI & analytics skills to improve sustainability, address climate change and champion active inclusion.

We are delighted to have received the “Glassdoor Best Places to work UK’ accolade for 4 consecutive years, to see what it’s like to work at Capgemini Invent, visit our Glassdoor page

NEED TO KNOW

At Capgemini we don’t just believe in inclusion, we actively go out to making it a working reality. Driven by our core values and Inclusive Futures for All campaign, we build environments where you can bring you whole self to work.

We aim to build an environment where employees can enjoy a positive work-life balance. We embed hybrid working in all that we do and make flexible working arrangements the day-to-day reality for our people. All UK employees are eligible to request flexible working arrangements.

Employee wellbeing is vitally important to us as an organisation. We see a healthy and happy workforce a critical component for us to achieve our organisational ambitions. To help support wellbeing we have trained ‘Mental Health Champions’ across each of our business areas. We have also invested in wellbeing apps such as Thrive and Peppy.

CSR:

We’re also focused on using tech to have a positive social impact. So, we’re working to reduce our own carbon footprint and improve everyone’s access to a digital world. It’s something we’re really serious about. In fact, we were even named as one of the world’s most ethical companies by the Ethisphere Institute for the 10th year. When you join Capgemini, you’ll join a team that does the right thing.

Whilst you will have London, Manchester or Glasgow as an office base location, you must be fully flexible in terms of assignment location, as these roles may involve periods of time away from home at short notice.

We offer a remuneration package which includes flexible benefits options for you to choose to suit your own personal circumstances and a variable element dependent grade and on company and personal performance.

About Capgemini Invent

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.

When you join Capgemini, you don’t just start a new job. You become part of something bigger.

Learn about how the recruitment process works – how to apply, where to follow your application, and next steps.

To help you bring out the best of yourself during the interview process, we’ve got some great interview tips to share before the big day.