Transform

Senior/Lead Data Solutions Architect

Transform

full-time

Posted on:

Location Type: Hybrid

Location: London • United Kingdom

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AWSAzureCloudETLGoogle Cloud PlatformInformaticaMongoDBMySQLNoSQLPostgresPySparkPythonRDBMSSQLSSIS

About the role

  • 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

Requirements

  • 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
Benefits
  • 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
  • Private healthcare
  • Life assurance
  • Enhanced maternity and enhanced paternity and shared parental leave
  • Cycle to work & electric car schemes
  • Gym & retail discounts
  • Regular social events/activities
  • A range of other benefits from our flexible benefits package
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data architecture designdata modellingschema designRDBMSSQLNoSQLdata lakesdata warehousesPythonPyspark
Soft Skills
team managementmotivationleadershipcollaborationagile methodologycommunicationproblem-solvingplanningresource managementquality management