Data Architect

Transact; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A leading UK investment platform is seeking an innovative Data Architect to lead the creation and rollout of a data governance strategy and implement a modern data platform. The ideal candidate will have significant experience in data architecture within the financial services sector, particularly in designing data lakes, warehouses, and analytics solutions. This role offers a competitive remuneration package and a hybrid working model of two days in the office and three days from home.

Benefits

Discretionary bonus

Excellent pension contributions

BUPA health insurance

Staff share scheme

Professional qualification sponsorship

Qualifications

• Minimum five years of relevant experience.
• Experience in designing data lakes and warehouses.
• Deep knowledge of data modelling techniques.

Responsibilities

• Design and implement a comprehensive data governance framework.
• Collaborate with departments to ensure data accountability.
• Lead the deployment of data platform technologies.

Skills

Data architecture expertise

Proficiency in data integration and ETL processes

Strong background in financial services

Experience with cloud-based storage and analytics

Familiarity with Snowflake and SQL Server

Education

Professional certifications

Tools

Azure

Power BI

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.