Specialist Data Modeller
Role details
Job location
Tech stack
Job description
-
Designing and maintaining conceptual, logical, and physical data models.
-
Collaborating with data engineers, analysts, and business stakeholders to gather and translate data requirements.
-
Ensuring data models support operations, business intelligence and analytics use cases.
-
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.
-
Participating in architectural discussions and contributing to data strategy.
-
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.
-
Contributing to a fair and efficient service that reflects the diversity of our customers and staff., 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 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!
Requirements
-
Documenting, designing and aiding in the implementation of data models for data warehouses and analytics platforms.
-
Modelling unstructured, semi structured and structured data.
-
Modelling the migration of data from legacy systems.
-
Using data modelling tools such as ER/Studio, ERwin, dbt, or similar.
-
Writing complex SQL or Python queries and understanding data profiling techniques.
-
Working with cloud-based data platforms e.g. Azure Synapse.
-
Applying data governance and data quality principles in modelling work.
-
Holding a degree in computer science, information systems, or a related field or equivalent experience.
-
Having extensive experience in data modelling or related roles.
-
Holding relevant certifications (e.g. Azure Data Fundamentals, DAMA CDMP) is desirable.
Benefits & conditions
Working Hours: Full-time, 35 hours per week (The team offers support 07:00-18:00)Occasional out of hours work will be required, this will be paid or time off in lieu. Occasional travel to other sites will be required)
Salary: £53,300, 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!