Lead Data Architect

London

Full Time Senior-level / Expert
Mintel logo

Mintel

Mintel is a global award winning market intelligence agency. We provide expert analysis of consumer trends, market statistics and industry reports.

View all employer listings

Apply now Apply later

Why join Mintel? We are the world's leading market intelligence agency, and technology underpins our success. We help our clients understand consumers and consumer markets, and we aspire to provide the market intelligence behind every great business decision. Our technology allows us to deliver data, insights, and opinions in a compelling way to our clients across the globe.

We have embarked on a major data governance initiative at Mintel where we are building a data warehouse that will be the foundation for a new generation of data products. We are looking for a Lead Data Architect to steer the evolution of our data models, supporting standards and data governance processes. You will be reporting to the Chief Architect and working closely with business stakeholders, our data governance team, and data engineering teams based in London, Belfast, Shanghai and Chicago.

We have already established an enterprise data warehouse based on the Data Vault 2.0 methodology. Our technical stack includes technologies such as Snowflake, DynamoDB, DBT, FiveTran, Looker, Ataccama, and SAP PowerDesigner.

In this role, you will:

  • Own the creation of data architecture standards that govern the production of data models across Mintel, and the review processes that ensure their proper implementation.
  • Become an expert in Mintel’s data structures, working with technical and non-technical subject matter experts to document existing data assets
  • Take ownership of our data repository based on SAP PowerDesigner, taking responsibility for the organisation of our data assets and ensuring they drive the physical implementations of warehouse structures.
  • Drive the glossary and metadata cataloguing efforts for our data assets
  • Partner with our data governance team to define the data structures for reference and master data, working with operational teams to master initial versions of this data.
  • Help to identify and define data management best practices in areas such as data privacy and data quality
  • Drive data analytics best practices through education and collaboration with development teams
  • Collaborate with stakeholders to create conceptual, logical, and physical data models and generate mapping documents that show how data can be transformed between them.
  • Work with data engineering teams to support the implementation of physical data models and transformation pipelines.
  • Support our data analysis delivery by driving best practice and assisting in the development of models used in the production of visualisations and dashboards using Looker
  • Evaluate and profile existing data systems, helping to identify and troubleshoot any issues that arise in terms of modelling & performance

In terms of qualifications and experience, we are looking for the following:

  • Significant experience in data architecture, data modelling, or data warehouse design
  • Good communication and data presentation skills with the ability to pitch and explain to business and technical stakeholders at various levels of the organisation
  • Deep experience of relational and dimensional modelling techniques
  • Experience working with data modelling tools such as Erwin, Idera ER Studio or SAP PowerDesigner and integrating them into the development process
  • The desire to work in a collaborative environment, where you work with governance, business, and technical stakeholders to iteratively build out data models
  • Experience of building and enforcing standards for data architecture across multiple delivery teams
  • Strong proficiency in SQL
  • Experience working with both structured relational and semi-structured data sets
  • Experience of working with cloud-native data warehouse technologies such as Snowflake, AWS Redshift, or Azure Data Warehouse as well as relational databases such as MySQL or Postgres
  • Experience modelling with Business Intelligence platforms such as Tableau or Looker

The following experience would be nice to see, but not essential:

  • Experience of designing for a warehouse based on the Data Vault 2.0 methodology
  • Direct experience of implementing SAP PowerDesigner
  • Experience working with a Master Data Management (MDM) system
  • Experience of working across a global organisation

 We hope you’ll like our…

  • Culture that supports true collaboration whilst embracing remote working
  • Generous holiday allowance with the opportunity to buy additional holiday
  • Approach to personal development where we encourage individuals to grow and share what they’ve learned
  • Frequent social events, both within the department and across the company
  • Blend of home and office working (1-2 days in the office) 
  Mintel is committed to building and supporting a diverse workforce, providing opportunities for all. 21% of our Engineering team and 27% of our Engineering leaders are women. We are proud to be a signatory of Tech Talent Charter, highlighting our goal of improving diversity within our team and supporting industry-wide improvement. We offer flexible working options and provide support, development and growth opportunities.
 

#LI-DB1

#LI-Hybrid

Tags: AWS Azure Business Intelligence Data analysis Data Analytics DynamoDB Engineering FiveTran Looker MySQL Postgres Redshift Snowflake SQL Tableau

Perks/benefits: Career development Equity Flex hours Team events

Region: Europe
Country: United Kingdom
Job stats:  4  1  0
  • Share this job via
  • or

Other jobs like this

Explore more AI/ML/Data Science career opportunities

Find open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general, filtered by job title or popular skill, toolset and products used.