Data Architect

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 organizational data is accurate, secure, compliant, and strategically utilized 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.