Senior/Lead Data Solutions Architect

Department: Technology: Data Technology

Employment Type: Permanent - Full Time

Location: London or Manchester UK

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 role involves designing data solutions, data modelling, analysis, and planning to implement a data management and quality framework that meets business needs. The architect acts as a bridge between Enterprise Architecture and Data Engineering teams, presenting and translating data management framework designs that meet 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

• 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

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 let us know if you need any adjustments now or at any point in the recruitment process.