Lead Data Architect
London
Applications have closed
Mintel
Mintel is a global market intelligence agency. We provide market research, industry expertise & data insights to help you make better business decisions faster.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)
#LI-DB1
#LI-Hybrid
Tags: Architecture AWS Azure Business Intelligence Data analysis Data Analytics Data governance Data management Data quality Data warehouse DynamoDB Engineering FiveTran Looker MySQL Pipelines PostgreSQL Privacy RDBMS Redshift Snowflake SQL Tableau
Perks/benefits: Career development Equity Flex hours Team events
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more 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 - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Engineer II jobs
- Open Senior Data Architect jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Principal Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Data Manager jobs
- Open Sr. Data Scientist jobs
- Open Data Scientist II jobs
- Open Big Data Engineer jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open CI/CD-related jobs