Senior/Lead Data Solutions Architect

London, London or Manchester UK

Open 5 months, first seen by us 154 days ago

Pay: Pay not listed
Work setting: Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment: Permanent — employment source
Employment type Permanent - Full Time
Read the full posting

What you’ll work on

Full posting

Design data architecture, data models and schemas for client solutions
Design and help build Single Customer Views, CDPs, data warehouses or data lakes
Define the data management and quality framework with Data Engineering teams
Work with clients to understand their needs and fit them to available technology
Plan and resource multiple projects at the same time

From the employer’s posting

Focus on data architecture design, data modelling and schema

Design and help build Single Customer Views or CDPs or Data Warehouses/Data Lakes to merge disparate data sets for marketing or sales activation

Deliver optimum design for data management and data quality framework in conjunction with Data Engineering teams

Working with clients to understand needs, and best implement that with our available technology solutions

Planning and resourcing multiple projects simultaneously

About Transform

Transform is a fresh alternative to Big Consulting.

In the employer’s words · Read in context

Apply at Transform

Posting record

Report an error

Open 5 monthsWe first saw this posting 154 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records: Live
First seen by us: Jun 3, 2026154 days ago
Recorded sightings: 62
Last seen by us: Nov 4, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 154

Up longer than most. Similar jobs usually come down between day 7 and day 53.

From 7,804 similar postings that came down. Coming down is not always a hire.

Transform is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Takes jobs down at a usual pace

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

Python
SQL
AWS
Azure
Databricks
GCP
MySQL
NoSQL
PostgreSQL
Snowflake
SQL Server
PySpark

Where the posting names them

- Work with technical architects to ensure that client systems are designed in accordance with the appropriate data architecture - Experience with a range of database technologies including data lakes such as Azure SQL or SQL Server, PostgreSQL, Snowflake, MySQL, Cosmos DB or Mongo DB with Python and Pyspark - Building data warehouse or data lakes with SCVs or in conjunction with CDP platforms

- Design and help build Single Customer Views or CDPs or Data Warehouses/Data Lakes to merge disparate data sets for marketing or sales activation - Knowledge of RDBMS, SQL and NoSQL databases and cloud computing platforms - Deliver optimum design for data management and data quality framework in conjunction with Data Engineering teams such as real-time, bulk loading, APIs, flat files, streaming, public data sources and survey data

Skills, Knowledge and Expertise - Experience with any of the following: Azure, AWS and GCP cloud database technologies - Design optimum data models, data dictionaries and metadata systems to support business needs

- Building data warehouse or data lakes with SCVs or in conjunction with CDP platforms - Experience of ELT/ETL tools such as Databricks, Azure Data Factory, SSIS, Talend, Informatica and Palantir - Managing and motivating teams and individuals

Upload resume Add LinkedIn

Your next step

Complete your application on transformuk.pinpointhq.com. The employer’s form will show what is required.

Applying through Pinpoint

Only .pdf and .docx are accepted. Older .doc files are turned away.

Already applied? Track this application

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025: $175,140
Expected change, 2025 to 2035: 15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Job description

View original posting ↗

About us

We're Transform.

Transform is a fresh alternative to Big Consulting. As an end-to-end transformation partner, we define, design, build and operate systems that solve our clients’ toughest challenges and seize their biggest opportunities. That often means combining strategy, data, AI, technology, and change management. Sometimes we manage and operate the systems we create; other times, we hand it over for the client to run – standing by to make improvements when things change. It all comes down to making an impact: improving lives, supporting citizens, streamlining workflows, and making the world a better place. We specialise in public sector and public-facing organisations—from government agencies and local authorities to energy, utilities, transportation and healthcare. We also work for some of the world’s most dynamic brands across automotive, retail, financial services, and consumer goods. We work closely (often on site) with our clients; to deliver impact you are keen to help us build the workforce of the future, we should talk.

We’re all in! That's what gets us out of bed every day. We hope you feel the same.

The Role: Senior/Lead Data Solutions Architect

Transform are looking for someone who can serve as the Data Solutions Architect, leading on projects involving solution implementations such as SCVs, CDPs, Data Lakes and data models to support application development and to power clients marketing and sales activities.

The ideal person will understand internal and external client needs, designing data solutions that allow customers to implement systems for their technology business applications. This involves performing data modelling, analysis and planning to implement a data management and quality framework that meets business needs. This person would act as a bridge between Enterprise Architecture and Data Engineering teams. The data architect presents and translates the data management framework design that will meet the client business requirements.

Key Responsibilities

Focus on data architecture design, data modelling and schema leveraging data architecture best practices, data architecture guides and advice and guidance to the data engineering team and clients
Helping to scope and define the team and client’s enterprise data management solution from conceptual, logical and physical data models and schemas
Working with clients to understand needs, and best implement that with our available technology solutions
Pushing forward our thinking, processes, and capability in the field of data architecture, management, and engineering
Constantly looking at new technologies and approaches that improve what we do
Managing quality of outputs
Planning and resourcing multiple projects simultaneously
Delivering data management and architecture frameworks on a range of complex marketing, sales, and research processes
Working with a range of data sources such as CRM, sales, research, and HR data
Design and help build Single Customer Views or CDPs or Data Warehouses/Data Lakes to merge disparate data sets for marketing or sales activation
Knowledge of RDBMS, SQL and NoSQL databases and cloud computing platforms
Deliver optimum design for data management and data quality framework in conjunction with Data Engineering teams such as real-time, bulk loading, APIs, flat files, streaming, public data sources and survey data

Skills, Knowledge and Expertise

Experience with any of the following: Azure, AWS and GCP cloud database technologies
Design optimum data models, data dictionaries and metadata systems to support business needs
Define data architecture standards for the organisation to support client needs
Work with technical architects to ensure that client systems are designed in accordance with the appropriate data architecture
Experience with a range of database technologies including data lakes such as Azure SQL or SQL Server, PostgreSQL, Snowflake, MySQL, Cosmos DB or Mongo DB with Python and Pyspark
Building data warehouse or data lakes with SCVs or in conjunction with CDP platforms
Experience of ELT/ETL tools such as Databricks, Azure Data Factory, SSIS, Talend, Informatica and Palantir
Managing and motivating teams and individuals
Understanding and application of statistical and analytical methods
Ability to lead, and to work well as part of, a team using the agile methodology
Experience with Data Analysis and governance
A growth mindset
AI curious and ready to embrace opportunities

Our culture and our benefits

Our culture is built on:

We raise the bar
We look out for each other
We embrace our differences
We shape a changing world
We’re all in

Our benefits include:

Holiday entitlement, 28 days with the option to buy/sell up to 5 days (note that 3 days are held for Christmas holidays)
Day off (on or in the week of) your birthday
Pension eligibility, up to 5% matched contributions
Private healthcare
Life assurance
Enhanced maternity and enhanced paternity and shared parental leave
Cycle to work schemes
Gym & retail discounts
Regular social events/activities
A range of other benefits from our flexible benefits package

At Transform, you can expect meaningful work, with real impact and the space to grow as people as well as a professional.

You’ll work alongside curious, authentic experts who care deeply about doing the right thing, for our clients and for each other with no egos, no blame, and no standing on the sidelines.

We’re all in on creating an environment where people feel supported, included and trusted to do their best work. In return, we ask for curiosity, honesty and a willingness to lean into learning, quality, teamwork, and to making change that truly lasts.

We’re committed to equality of opportunity for all, and we actively seek applications from all ethnicities, orientations, beliefs, gender identities + those with neurodiverse traits and disabilities. We want you to have the best opportunity to show us who you are and what you can do. Please do let us know if you need any adjustments now or at any point in the recruitment process.

If this sounds like you, please get in touch to discuss in more detail.

Use of AI in CV and Interviews
We value authenticity and transparency in our hiring process. To ensure fairness and accuracy in assessing your skills and experience, we ask that you refrain from using AI-assisted tools to generate answers during the application process or within interviews.

We are looking for genuine insights into your abilities, experiences, and personality. Any misrepresentation through AI-generated content may impact our ability to make an informed decision. We look forward to getting to know the real you!

Employment type

Permanent - Full Time

Source details