Transform

Technology and data consulting for growth

Senior/Lead Data Solutions Architect

Data ManagementUpdated on Nov 14

Full-timeNo salary listed

About the Job

Requirements

Knowledge of relational database management systems, SQL, NoSQL databases, and cloud computing platforms.
Experience with database technologies including Azure SQL or SQL Server, PostgreSQL, Snowflake, MySQL, Cosmos DB or MongoDB, Python, and PySpark.
Experience with cloud database technologies on Azure, AWS, or Google Cloud Platform.
Experience with extract, load, and transform or extract, transform, and load tools such as Databricks, Azure Data Factory, SQL Server Integration Services, Talend, Informatica, and Palantir.
Understanding and application of statistical and analytical methods.
Experience with data analysis and governance.
Ability to lead and work as part of a team using Agile methodology.
Ability to manage and motivate teams and individuals.
Ability to work with clients to understand their needs and select appropriate technology solutions.
Ability to manage data architecture, data management, and data engineering frameworks across complex marketing, sales, and research processes.
Ability to work with CRM, sales, research, and HR data sources.
Ability to design and implement single customer views, customer data platforms, data warehouses, and data lakes.
Ability to develop data models, data dictionaries, metadata systems, and schemas.
Ability to design data management and data quality frameworks using real-time processing, bulk loading, APIs, flat files, streaming, public data sources, and survey data.

Responsibilities

Lead projects involving solution implementations such as single customer views, customer data platforms, data lakes, and data models that support application development and clients’ marketing and sales activities.
Understand internal and external client needs and design data solutions that enable customers to implement systems for their technology business applications.
Perform data modelling, analysis, and planning to implement data management and quality frameworks that meet business needs.
Bridge Enterprise Architecture and Data Engineering teams, and present and translate data management framework designs to meet client business requirements.
Lead data architecture design, data modelling, and schema development, applying data architecture best practices and providing advice and guidance to data engineering teams and clients.
Help scope and define enterprise data management solutions through conceptual, logical, and physical data models and schemas.
Improve the organisation’s thinking, processes, and capability in data architecture, management, and engineering; evaluate new technologies and approaches.
Manage the quality of outputs and plan and resource multiple projects simultaneously.
Design data models, data dictionaries, and metadata systems to support business needs.
Define data architecture standards for the organisation and work with technical architects to ensure client systems follow appropriate data architecture.
Build data warehouses or data lakes with single customer views or alongside customer data platform solutions.

Desired Qualifications

A growth mindset.
Curiosity about AI and readiness to embrace AI opportunities.

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.

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

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

About the Company

Transform

Technology and data consulting for growth

Transform is a technology and data consulting firm that helps clients grow, stay relevant to their audiences, and save costs by defining, designing, building, and operating products and services. It offers services in data engineering, data science, agile project management, DevOps, and deployment, delivering scalable and sustainable solutions tailored to each client’s needs. The firm works through high-performance, expert-driven engagements, typically on a project basis, to drive measurable outcomes for clients. Its goal is to amplify business outcomes by enabling growth, efficiency, and relevance through pragmatic, end-to-end technology and data initiatives.

Company size: Not listed
Company stage: Not listed
Total funding: Not listed
Headquarters: London, United Kingdom
Founded: 2010

Recently Posted Jobs

Explore more opportunities at Transform

See more jobs