Data Architect - Transact

Transact; City Of London; Hybrid; GBP 85,000 - 115,000; Full time

Job summary

A leading investment platform in London is seeking a Data Architect to lead the development of a Data Governance Strategy and platform implementation. The ideal candidate will have over five years of experience in data architecture, particularly within the financial services sector. This role offers a competitive salary and a hybrid work model, with three days remote and two days in the office.

Benefits

Competitive remuneration package

Discretionary bonus

Health insurance

Annual leave purchasing options

Professional qualifications sponsorship

Qualifications

• At least five years of relevant experience in data architecture.
• Strong background in designing data lakes and data warehouses.
• Experience in the financial services sector is essential.
• Deep knowledge of data governance and compliance standards.
• Proficiency in data integration and orchestration of data pipelines.

Responsibilities

• Design and implement a comprehensive data governance framework.
• Establish and lead a cross-functional Data Governance Council.
• Ensure compliance with data protection regulations.
• Lead the deployment of modern data platform technologies.
• Promote a data-driven culture through training initiatives.

Skills

Data governance

Data architecture

Data modeling

Data integration

Cloud technologies

ETL processes

Education

Professional certifications in Data Engineering

Tools

Azure

Power BI

Snowflake

SQL Server

PostgreSQL

Job description

Job Description

We're looking for an innovative Data Architect to lead the creation and rollout of a comprehensive Data Governance Strategy, alongside the implementation of a data platform. This role will be instrumental in ensuring organisational data is accurate, secure, compliant, and strategically utilised to unlock business value.

This is a new role created due to growth, offering an exciting opportunity to shape and lead our data governance and platform strategy from the ground up.

Key responsibilities

• Design and implement a comprehensive data governance framework.
• Define and maintain data governance policies, standards, and procedures.
• Establish and lead a cross‑functional Data Governance Council.
• Collaborate with data owners, stewards, and custodians across departments to ensure alignment and accountability.
• Develop and enforce data quality standards, metrics, and monitoring processes.
• Ensure compliance with data protection regulations such as GDPR, CCPA, and other relevant standards.
• Evaluate, select, and implement data governance tools (e.g. data catalogues, data quality tools).
• Lead the deployment of modern data platform technologies including Data Warehouses, ETL services, and cloud‑based solutions.
• Promote a data‑driven culture through organization‑wide training and awareness initiatives.
• Develop and deliver role‑specific training for data owners, custodians, and other key stakeholders.

Requirements

The ideal candidate will have at least five years of relevant experience, with a strong background in designing and implementing data lakes, data warehouses, and analytics solutions.

Experience within the financial services sector is essential, along with a solid understanding of investment and financial products in the UK.

A deep knowledge of data architecture and modelling is required, including conceptual, logical, and physical data modelling, as well as expertise in data warehousing, data lake architecture, and Master Data Management (MDM).

The role also demands proficiency in data integration and ETL processes, including the design and orchestration of data pipelines and the use of ETL / ELT tools.

Candidates should be experienced with a range of database technologies, particularly cloud‑based storage, compute, and analytics services such as Azure, Fabric, and Power BI.

Familiarity with Snowflake and relational databases like SQL Server and PostgreSQL is also essential. Professional certifications such as Microsoft Certified : Azure / Fabric Data Engineer Associate and SnowPro® Advanced : Architect are highly desirable.

What we offer :

We offer a competitive remuneration package, including company discretionary bonus, excellent pension contributions, an attractive staff share scheme, BUPA health insurance, buying and selling of annual leave and sponsorship of relevant professional qualifications. The role is based in our central London office, working a minimum of two days a week in the office and three days a week from home.

About Us

Transact is a leading UK investment wrap platform for financial advisers and their clients. Our culture is collaborative, inclusive and open‑minded. We work hard to continually challenge the way we do things to maintain our market‑leading status.

As a customer‑centric and client‑focused business, we put our clients, like Mrs Miggins, at the heart of everything we do.

Our platform enables clients and their advisers to manage their financial portfolio in one single online place, and is supported by unrivalled personal service. Our goal is to make all aspects of portfolio management as easy and efficient as possible for everyone involved, through the features we develop, our integrations with other systems, and the support we provide.

Our purpose: We enable the Miggins family and their adviser to hold their investments on a single platform across wrappers. We provide custody, tax wrapping, trading and reporting.

Our strategy: We make financial planning easier for advisers by delivering great service. Our platform helps advisers grow revenues and reduce risk and cost in their business. We will always have control of our technology, wrappers and service.

Our values: We do the right thing for customers, advisers, staff, shareholders, suppliers and the wider community.

Transact's parent company, IntegraFin Holdings plc, is listed on the London Stock Exchange and is a constituent of the FTSE 250 index. Established in 2000, today we have over £74.2 billion of funds under direction on behalf of over 246,000 investor clients (as at September 2025).

Equal Opportunities

We provide a diverse and inclusive workplace and ensure that all of our staff respect and understand individual differences. We are an equal opportunities employer and positively encourage applications from suitably qualified and eligible candidates regardless of age, disability, gender reassignment, marital or civil partner status, pregnancy or maternity, race, religion or belief, sex or sexual orientation.