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

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

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.