Data Modeller

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

Job summary

A public service organization is seeking a Data Modeller to shape a modern data landscape. You will design scalable models for analytics and operational efficiency. Key responsibilities include maintaining data models and collaborating with teams. Ideal candidates have strong ETL skills and experience with cloud data platforms. The position offers a competitive salary and benefits, with a hybrid work model in Coventry, Manchester, or London.

Benefits

25 days holiday with options to buy/sell

Generous pension

Private medical insurance

Gym membership discounts

Qualifications

• Experience in large-scale data warehouse implementations.
• Writing SQL or Python queries and understanding data profiling.
• Experience with cloud-based data platforms.

Responsibilities

• Design and maintain data models.
• Collaborate to translate data requirements.
• Review and optimize existing data models.

Skills

ETL pipeline design

SQL queries

Data modelling tools

Python

Tools

Azure Synapse

ER / Studio

ERwin

dbt

Job description

we encourage you to apply!

Data Modeller

Join our Chief Data Office and help shape a modern, cloud-first data landscape that drives innovation and smarter decisions.

We’re looking for a Data Modeller to design scalable models that power analytics and operational efficiency.

You’ll play a key role in building scalable models that support analytics and operational efficiency.

If you’re enthusiastic about data modelling and cloud technologies, this is your chance to make an impact.

Contract : Permanent

Working Hours : Full-time, 35 hours per week

Salary : £53,300 - £64,786 London and £47,000 - £57,129 Coventry / Manchester (Salary offered is dependent on level of experience)

Report to : Data Engineering Manager

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

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.

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, Azure Synapse.

Why you'll love working with us

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 :

• Flexibility : Work your way — hybrid or in‑office
• Wellbeing : [Health plan, gym memberships, mental health support]
• Growth : We invest in your future with [courses, mentorship, promotions]
• Culture : Diverse. Inclusive. Collaborative. Fun.

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
• Gym membership discounts, and a fully equipped on‑site gym open 24 / 7 in London only

How do I apply?

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

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

The Financial Ombudsman is an Equal Opportunity Employer

We celebrate diversity and are committed to creating an inclusive environment for all our team. We view diversity as fundamental to our success and welcome applications from underrepresented groups across all communities. Please click on the link below to find out more

Don’t miss out, be part of the journey and take advantage of this opportunity.

Authenticity of applications

To ensure a good candidate experience we do not use AI tools for our screening process. As such we value authentic personal applications.

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!

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