Senior Data Solutions Architect - Hybrid, Weekly Travel in London

Role: Senior/Lead Data Solutions Architect

Type: Full time, permanent

Location: London or Manchester

WoW: Hybrid, weekly travel to the office/client site.

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. 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.

In 2024, Transform acquired Cadence Innova, the UK’s leading public sector change consultancy. The result is a fresh kind of partner: together, we’re able to deliver change from the very first ideas through to deployment—building on our deep relationships at every level of government.

The Role:

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.

Key Responsibilities:

• Focus on data architecture design, data modelling and schema leveraging data architecture best practices.
• 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.

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.

Our culture is built on:

• Being one team; looking out for each other as a team.
• The world never stops changing and we’ll never stop learning.
• Infinity & Beyond; we’re crazy ambitious, not afraid to fail along the way.
• Integrity is everything; we’re honest with each other and with our clients.
• Diversity is our superpower; everyone’s story is different, and we celebrate differences.
• We’re all in; we take on tough, complex challenges with lots of moving parts and we’re committed to the work, our clients and each other.

Our benefits include:

• Holiday entitlement, 28 days with the option to buy/sell up to 5 days.
• Day off (on or in the week of) your birthday.
• Pension eligibility, up to 5% matched contributions.
• Life assurance.
• Enhanced maternity and enhanced paternity and shared parental leave.
• Cycle to work & electric car schemes.
• A range of other benefits from our flexible benefits package.

At Transform we believe in a culture of inclusivity, we celebrate difference and believe that diversity makes our business more relevant, our work more meaningful and our people more empowered. 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.

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

Use of AI in CV and Interviews

Whilst we are a technology company and promote using AI the right and ethical way, we value authenticity and transparency in our hiring process. To ensure fairness and accuracy in assessing your skills and experience, we kindly request that you refrain from using AI-assisted tools to generate answers during interviews or enhancing your CV.

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!