Specialist Data Engineer

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

This role requires you to be 'on call' outside of usual working hours (Weekends and bank holidays). This will be discussed at interview stage in more detail.

The Financial Ombudsman Service has been resolving customer complaints since 2001. Our service is free for consumers to use and over 1 million people contact us every year.

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 2026 continues to be delivery focused.

Last year, we redefined our data strategy across the organisation. With data playing an increasingly vital role in our journey, we are 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 growing Data team at the Financial Ombudsman Service., * Designing and maintaining ETL/ELT pipelines using Azure Data Factory, Synapse and Databricks.

• Designing and maintaining conceptual, logical, and physical data models.
• Contribute to the design, implementation and maintenance of large-scale enterprise data platform solutions, ensuring quality, scalability, reliability and performance.
• Implementing CI/CD pipelines for data solutions.
• Building scalable data pipelines, utilising Azure Data Factory, Synapse and Databricks to build and maintain robust data pipelines that process and transform data efficiently.
• Ensuring the team's SLA obligations for data delivery, and reliability are met, and that incidents and requests are managed appropriately.
• Collaboration and overseeing development and testing of data service improvements with cross-functional teams in all environments. You will work with the team to provide end of life support to our SAP Data Services platform.
• Overseeing code promotion process across the data platform solutions and environments, adhering to Service Management change process.
• Partner closely with IT application and infrastructure teams in promoting; strong alignment to security and compliance, continual integration with source systems and efficient infrastructure resource management.
• Oversee the creation and maintenance of technical documentation and knowledge sharing including data flow/mappings, data dictionary, ERD related to the data solutions.

Are you an experienced Data Engineer with excellent programming and modelling skills?, * Experience in large-scale data warehouse/Lakehouse implementations, transitioning from SQL Server-based data warehouses. Strong ETL pipeline design and implementation skills.

• Creating and optimising data models, writing complex SQL and Python queries.
• Hands on experience with Spark and RESTful APIs
• Solid knowledge of data warehouse and Delta Lakehouse technologies.
• Experience working with Microsoft Azure and SQL technologies such as Azure Synapse Analytics, Azure Data Factory, Azure Databricks.

Desirable Criteria:

• SAP Data Services expertise

Pulled from the full job description

• Company pension
• On-site gym
• Private medical insurance
• Cycle to work scheme
• Tech scheme
• Discounted gym membership, We are a value 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
• Flexibility : remote, 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