Data Modeller

Financial Ombudsman Service; Coventry; Hybrid; GBP 47,000 - 58,000; Full time

Job summary

A national public service organization is seeking a Senior Data Modeller to shape data-driven decision-making. In this pivotal role, you will design data models, work collaboratively with various stakeholders, and help build a cloud-first data landscape. This role offers competitive pay, hybrid working options, and a commitment to inclusion and diversity.

Benefits

25 days holiday entitlement

Generous pension

Private medical insurance

Gym membership discounts

Employee Assistance Programme

Qualifications

• Experience in large-scale data warehouse/Lakehouse implementations.
• Strong ETL pipeline design and implementation skills.
• Documenting, designing and aiding in the implementation of data models.

Responsibilities

• Designing and maintaining conceptual, logical, and physical data models.
• Collaborating with business stakeholders to gather and translate data requirements.
• Mentoring junior data modellers and supporting their development.

Skills

Data warehouse/Lakehouse implementations

ETL pipeline design

Data modelling tools

SQL or Python queries

Cloud-based data platforms

Tools

ER/Studio

ERwin

dbt

Job description

Looking for a new challenge? Learn about our current vacancies. If you see a vacancy that is right for you, we encourage you to apply!

Senior Data Modeller

Are you passionate about shaping how data drives decision-making? Join us at a pivotal moment in our transformation journey, where your expertise in data modelling will help build a modern, cloud‑first data landscape. As part of our newly formed Chief Data Office, you’ll play a key role in designing solutions that support innovation, improve operational efficiency, and put our customers at the heart of everything we do.

Contract: Permanent

Working Hours: Full-time, 35 hours per week

Salary: £53,300 - £64,786 London and £47,000 - £57,129 (Outside of London). All salaries are offered dependent on level of experience.

Report to: Data Engineering Manager

Location: London Docklands or Coventry or Manchester (Hybrid).

Our permanent hybrid policy sees us all working at least four days across a fortnight in the office.

The last few years have seen the Financial Ombudsman Service embark on an organisation‑wide transformation journey. With the customer at the heart of everything we do, we have already delivered significant improvements in the service we offer and 2025 will see us continue with our ambitious transformation agenda.

This year, we created our new Chief Data Office as part of redefining our data strategy across the organisation. With data playing an increasingly vital role in our transformation journey, the CDO is shaping a modern, cloud‑first data landscape that supports innovation, enhances decision‑making, and strengthens our customer‑centric approach. It’s an exciting time to be part of the Data team at the Financial Ombudsman Service.

Key Responsibilities:

• Designing and maintaining conceptual, logical, and physical data models.
• Ensuring data models support operations, business intelligence and analytics use cases.
• Collaborating with the Enterprise Architect, data engineers, analysts, and business stakeholders to gather and translate data requirements
• Implementing and maintaining metadata and data dictionaries.
• Reviewing and optimising existing data models for performance and scalability.
• Ensuring data models align with data governance and security standards.
• Mentoring junior data modellers and supporting their development.
• Documenting data structures, relationships, and business rules.
• Supporting data integration and transformation processes.
• Communicating modelling decisions and rationale to technical and non‑technical audiences.
• Identifying opportunities to improve data modelling practices and standards.

To be considered for this role, you’ll need to show us that you’ve got the skills and capabilities. You’ll have to meet the following minimum criteria:

Minimum Criteria

• Experience in large‑scale data warehouse/Lakehouse implementations transitioning from SQL Server‑based data warehouses or similar complex projects.
• Strong ETL pipeline design and implementation skills.
• Documenting, designing and aiding in the implementation of data models for data warehouses and analytics platforms.
• Using data modelling tools such as ER/Studio, ERwin, dbt, or similar.
• Writing SQL or Python queries and understanding data profiling techniques
• Experience of working with Cloud‑based data platforms, i.e. Azure Synapse.

Why Financial Ombudsman Service?

We are a values‑led organisation. Our values define our culture, influence our decisions, and underpin our vision and strategy. They set out how we play our PART through Purpose, Ambition, Respect and Trust. You can learn more about our values here: https://www.financial-ombudsman.org.uk/who-we-are/aims-values

We also offer an attractive, competitive salary and flexible benefits to suit our people. Here’s a list of some of the many benefits and perks you can get for working with us:

• 25 days holiday entitlement, with the option to buy extra or sell days
• Generous pension
• Various Family Friendly Policies, including enhanced maternity pay, carers and dependants leave
• Employer provided benefits such as Private medical insurance, virtual GP, Critical illness cover, Life assurance cover, to name a few
• Choice of voluntary benefits including Technology scheme, Cycle to work scheme, Will‑writing service amongst others
• Employee Assistance Programme
• Extensive opportunities for personal and career development
• Nationwide gym membership discounts, and a fully equipped on‑site gym open 24/7 in London
• Extensive Well‑being resources including on‑site therapists (London office only)
• Beautiful and bright London office looking over the Thames and near to mainline stations
• Our employee‑led networks (a couple of examples being our Women's Network, Carers network, and Neurodiverse Network) do fantastic work in educating and raising awareness across a range of experiences and support us in being an inclusive employer and a great place to work. You can get involved, too!

How do I apply?

• Please upload an up‑to‑date CV, ensuring you are highlighting the key skills/ tools and technologies as per the minimum criteria

Due to high application numbers this advert may end earlier than the date specified, so please don’t delay and apply now.

A full job profile is available on request and will be provided to candidates shortlisted.

We’re proud to be an inclusive employer

We view diversity as fundamental to our success and welcome applications from under‑represented groups across all communities.

We’re committed to being a great place to work– attracting and developing people from the widest possible range of backgrounds. We want everyone to perform at their best and feel able to be themselves. We understand that if we’re diverse and inclusive, we’ll better understand different perspectives, which is fundamental to our job resolving financial complaints.

We welcome applications from Black and other ethnic minority candidates, and female candidates, for all positions and particularly so for senior leader positions as they are under‑represented within the Financial Ombudsman Service at this level.

We are proud to be a Disability Confident Leader. This means that we will put disabled candidates entering under the scheme through to the next stage of the recruitment process should they meet the minimum criteria for a role. A minimum criterion needs to be measurable from reviewing a candidate’s CV/supporting statement. Exceptions may apply if due to the volume of applications, we are not able to interview all eligible candidates who qualify under the scheme. If you would like to speak to a member of our team about any reasonable adjustments you need, please email [e-mail] and let us know your preferred method of contact.

Find out more

Check out below channels to find out more about everyday life at the Financial Ombudsman Service – and don’t forget to follow us while you’re there!

• LinkedIn: https://www.linkedin.com/company/financial-ombudsman-service
• Our careers page: https://www.financial-ombudsman.org.uk/who-we-are/join-us

Thank you for your interest in working with us, we wish you luck with your application