Data Architect

Defaqto; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

Defaqto is seeking an experienced Data Architect to lead the design and architecture of its market data model. The role involves creating a logical data model and technology implementation recommendations in collaboration with the CTO and Head of Data. Required skills include entity-relationship modelling and expertise with cloud data warehouse platforms like Google BigQuery. This is a hybrid role based in London with potential for expansion after an initial 3-month contract.

Qualifications

• Experience leading logical and physical data model design for analytical data warehouses.
• Ability to produce technology-agnostic logical models and translate into implementation recommendations.
• Comfortable working independently and managing delivery to milestone-based timelines.

Responsibilities

• Lead the data architecture of Defaqto's redesigned market data model.
• Produce a signed-off logical data model and technology implementation recommendation.
• Interrogate current logical model structure and validate against business requirements.

Skills

Entity-relationship modelling

Cloud data warehouse platforms

Workshop facilitation

Data dictionary production

Architecture presentation skills

Tools

Google BigQuery

Snowflake

Redshift

Databricks

Job description

This role can be filled via fixed term contract or via daily rate (Inside IR35) via umbrella company. Initially 3 months with the potential for expansion.

Department: Data

Location: London

Role Overview

This is a focused, high‑value engagement to lead the data architecture of Defaqto's redesigned market data model. We have an initial view of the logical structure we need, and we are looking for an experienced architect to test, challenge, and refine that thinking – then translate it into a signed‑off logical model and implementation recommendations for the CTO and Head of Data to act on.

What you'll do

We have developed an initial view of the logical architecture – centred on four core entities: Package, Component, Attribute, and Market – but this is a starting point, not a fixed brief. We are looking for an architect who will interrogate that thinking, validate it against real business requirements, and produce a model that genuinely fits how our data needs to work. The initial scope is the market data product estate and the primary research data platform.

Technology choices for physical implementation have not been finalised. Google BigQuery is our existing lakehouse platform and the likely foundation, but decisions on the transformation layer, tooling, and overall implementation approach will be made during this engagement in collaboration with the CTO and Head of Data. The logical model itself is a technology‑agnostic deliverable; implementation recommendations are expected alongside it.

The Engagement

This contract covers the design and architecture phase of the data model project (Phase 1 of a phased delivery programme). The primary output is a signed‑off logical data model and a technology implementation recommendation, produced in close collaboration with the CTO and Head of Data. The logical model is a technology‑agnostic deliverable; the implementation recommendation should be grounded in Defaqto's existing technology landscape and make a clear case for the chosen approach.

A Senior Data Engineer will be recruited to own the build and ongoing implementation once the architecture is agreed. The architect's role is to design the model, recommend the implementation approach, and provide sufficient documentation that the engineering team can execute without ongoing dependency on the contractor.

Scope & Constraints

In Scope

• Logical model design for the market data product estate – core entities, relationships, and attributes
• Technology implementation recommendation – physical implementation approach suited to the existing stack, presented to CTO and Head of Data
• Compatibility view specification for research platform continuity during transition
• Business rule formalisation for deduplication, ratings hierarchy, and attribute priority logic
• Stakeholder workshops and sign‑off facilitation
• Data dictionary and handover documentation

Out of Scope

• Transformation layer build and implementation (owned by Senior Data Engineer)
• Research platform frontend adaptation (Phase 2 workstream)
• Full estate migration beyond the initial market data scope (Phase 2+)
• Ongoing data governance or catalogue ownership
• Graph database design or implementation

What you'll need to succeed

Essential requirements

• Demonstrable experience leading logical and physical data model design for analytical data warehouses
• Strong command of entity‑relationship modelling, normalisation, and dimensional design
• Experience with cloud data warehouse platforms – Google BigQuery is the existing lakehouse technology; hands‑on experience with BigQuery or equivalent (Snowflake, Redshift, Databricks) is expected
• Ability to produce technology‑agnostic logical models and translate them into well‑re‑asoned implementation recommendations
• Proven ability to facilitate workshops with mixed technical and non‑technical stakeholders and produce signed‑off artefacts
• Experience producing data dictionaries and technical documentation to a standard usable by engineering teams
• Comfortable presenting architecture options and trade‑offs to senior technology leadership
• Ability to work independently and manage delivery to milestone‑based timelines

Desirable requirements

• Experience in financial services, insurance, or fintech data domains
• Familiarity with dbt – sufficient to design a schema that a dbt‑based transformation layer can implement effectively
• Experience designing compatibility or migration layers for legacy platform transitions
• Exposure to data cataloguing tools (Google Dataplex, DataHub, Atlan)
• Understanding of product data or market intelligence data structures
• Experience working within a phased, non‑big‑bang migration approach

Important to know

Location

This is a hybrid working role, usually with 2 days each week in the office – office base can be London or Haddenham. From time‑to‑time if there are workshops, you may need to be in the office more frequently.

Right to Work

Applicants must already hold a legal right to work in the UK without time restrictions and without the need for future sponsorship. We are unable to provide Skilled Worker visa sponsorship.

Fintel plc and all the businesses within it adopt a zero‑tolerance approach to discrimination on any of the protected grounds in the Equality Act 2010.

We are committed to providing equal opportunities to all current and prospective employees regardless of age, disability, sex, sexual orientation, pregnancy and maternity, race or ethnicity, religion or belief, gender identity, or marriage and civil partnership.

We aspire to have a diverse workforce because, in our view, diversity enables better business outcomes. We also believe that a more inclusive workplace, where people of different backgrounds work together, ensures better outcomes for all staff. From application to interview, we place inclusion at the heart of all we do.