Operational Data Architect

Aviva Direct Ireland Limited; Greater London; Hybrid; GBP 100,000 - GBP 115,000; Full time

Job summary

A leading insurance company based in the UK is seeking an experienced Operational Data Architect to design and govern the architecture supporting operational data flows. The role involves ensuring data accuracy, managing data integrations, and collaborating with technical teams. Suitable candidates will have expertise in data architecture, including both OLTP and NoSQL databases. This position offers a competitive salary range, generous benefits, and opportunities for personal development.

Benefits

12% annual bonus opportunity

Generous pension scheme - up to 14% contribution

29 days holiday plus bank holidays

Aviva-funded Private Medical Benefit

Up to 40% discount on Aviva products

Matching Share Plan up to £1,200 of free shares

Flexible benefits including sustainability options

Paid volunteering days

Wellbeing support and tools

Qualifications

• Expert ability to design, govern, and optimize operational data.
• Deep expertise in designing and governing Operational Data Stores (ODS).
• Strong experience architecting and governing Master Data Management platforms.
• Hands-on expertise with OLTP relational databases and NoSQL datastores.
• Capability to architect scalable and resilient data flow and storage architectures.

Responsibilities

• Design and govern the architecture that underpins operational data flows.
• Ensure operational data is accurate, trusted, secure, and efficiently delivered.
• Define and evolve target architectures for Operational Data Stores.

Skills

Operational Data Architecture Expertise

Operational Data Store (ODS) Architecture & Engineering

Master & Reference Data Platform Architecture

OLTP & NoSQL Database Expertise

Designing Performant, Resilient Operational Data Flows

Tools

PostgreSQL

SQL Server

Oracle

DynamoDB

MongoDB

Cassandra

Job description

Operational Data Architect

Location: London, Norwich, Bristol, Eastleigh, Manchester, York, Perth, and Manchester

Salary: £115k circa (London) / 100k circa (National)

This is a great job for someone who is an experienced data architect who enjoys combining big‑picture thinking with hands‑on design. You’ll be comfortable simplifying complex operational data landscapes, modernising legacy data and integration patterns, and working closely with engineers and enterprise architects. You’ll thrive in a federated environment, influencing change through collaboration while delivering practical, high‑value improvements.

A bit about the job:

The Operational Data Architect designs and governs the architecture that underpins Aviva’s operational data flows and platforms. The role ensures operational data is accurate, trusted, secure, and efficiently delivered across systems, markets, and business functions. You’ll define and evolve target architectures for Operational Data Stores and operational data platforms, supporting key programmes such as Data Case for Change and Data Readiness for AI. Working closely with architecture, data governance, and engineering teams, you’ll balance short‑term delivery with long‑term strategic direction.

Skills and experience we’re looking for:

• Operational Data Architecture Expertise -Expert ability to design, govern, and optimise operational data — including transactional data modelling, operational data lineage, data quality controls, and end‑to‑end operational data flow patterns.
• Operational Data Store (ODS) Architecture & Engineering -Deepexpertisein designing and governing Operational Data Stores (ODS), including structuring near‑real‑time data ingestion, ensuring performant storage patterns, decoupling consumption from source systems, enabling operational decisioning, and supporting downstream platforms such as AI, underwriting, and claims.
• Master & Reference Data Platform Architecture -Strong experience architecting and governing MDM and reference data platforms—covering domain mastering, matching/merging rules, golden‑record creation, publish/subscribe distribution, metadata‑driven governance, and integration of MDM with operational systems.
• OLTP & NoSQL Database Expertise - Hands‑on expertise with both OLTP relational databases (e.g., PostgreSQL, SQL Server, Oracle) and NoSQL datastores (e.g., DynamoDB, MongoDB, Cassandra). This includes schema design for transactional workloads, ACID properties, indexing, query optimisation, and high‑volume performance tuning, combined with NoSQL skills such as flexible schema modelling, partitioning, replication strategies, and scaling distributed data systems.
• Designing Performant, Resilient Operational Data Flows -Capability to architect scalable, resilient, compliant data‑flow and storage architectures that minimise duplication and ensure operational systems reliably serve business‑critical functions.

Whatyou’llget for this role:

Our purpose - with you today, for a better tomorrow – is a promise we make to our colleagues too.And one of the ways we live up to that promiseisby investing in you.We have so much to offer when it comes to being an Aviva colleague.

• Startingsalary£115k circa (London) / 100k circa (National) (depending on location, skills, experience, and qualifications)
• Bonus opportunity –12% annual salaryActual amountdependson your performance and Aviva’s.
• Generouspensionscheme-Avivawill contribute up to 14%, depending on what you put in.
• 29 daysholidayplus bank holidays,and you can choosetobuyorsell up to 5days
• Aviva-funded Private Medical Benefitto help you get expert support when you need it
• Make your money go further -Up to 40%discountonAviva products, and other retailer discounts
• Up to £1,200 of free Aviva shares per year through ourMatching Share Planand share in the success of Aviva with ourSave As You Earnscheme
• Brilliantlysupportive policiesincluding parentalandcarer’s leave
• Flexiblebenefits to suit you, includingsustainability optionssuch as cycle to work
• Make a difference,be part of ourAviva Communitiesand useyour3paid volunteering daysto help others
• We take yourwellbeingseriously withlots of support and tools

Take a look to learn more.Put a salary into this calculator to see what yourtotal Aviva Rewardcould be.

Aviva is for everyone:

’reinclusive andwelcome everyone– we want applications from all backgrounds and experiences. Excited but not sure you tick every box? Even if youdon’t, we would still encourage you to apply. We also consider all forms of flexible working, including part time and job shares.

We flex locations, hours and working patterns to suit our customers, business, and you. Most of our people are smart working –spendingat least50% of their time in our offices every week - combining the benefits of flexibility, with time together with colleagues.

To find out more about working at Aviva take a lookhere

We'dlove it if you couldsubmityour application online. If yourequirean alternative method of applying, or if you have any queries in relation to the vacancy, please giveChloe Nettley a call on 07795207964 or send an email to [e-mail]