Rodeo
Get started

Transform

Senior Data Architect

London
Posted about 19 hours ago
Sign up to applySee more jobs like this
Get notified of more jobs like this · No spam, ever

How your CV stacks up

1Upload CV
2Analyse CV
3Improve CV

Upload your CV to see how well it fits this job role

?%

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

Reasons to use Rodeo

I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?

Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.

Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.

Start with a chat, not a search bar

Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.

P

Graduate Consultant — 2026 Scheme

PwC·London, UK
£35,000/yr

Why you're a good match

Strong

Your economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.

See breakdown
Save jobNot relevant
View details

It searches the market for you

Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.

Why you're a good match

You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.

See breakdown
Strong

Experience fit

Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.

See breakdown
Strong

Only hits

No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.

Key Skills/Experiences:

  • 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

Get help with your application

Your very own career expert that helps elevate your application to the next level.

Get help applying for this job

Our Culture

  • 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

  • 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!

Trusted by 25,000+ job seekers

“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”

Jessica, London

Get help applying for this job

Skills

Data Architecture
Data Modelling
Azure
AWS
GCP
SQL
NoSQL
Python
PySpark
Databricks
Azure Data Factory
Snowflake
CDP
ETL/ELT
Agile Methodology
Data Governance

Location

London, England, United Kingdom

Sign up to applySee more jobs like this