Data Architect

Wood Mackenzie
Edinburgh
2 months ago
Applications closed

Related Jobs

View all jobs

Data Architect

Data Architect

Data Architect

Data Architect

Data Architect

Data Architect

Wood Mackenzie is the global data and analytics business for the renewables energy and natural resources industries. Enhanced by technology. Enriched by human an ever-changing world companies and governments need reliable and actionable insight to lead the transition to a sustainable future. Thats why we cover the entire supply chain with unparalleled breadth and depth backed by over 50 years experience. Our team of over 2400 experts operating across 30 global locations are enabling customers decisions through real-time analytics consultancy events and thought leadership. Together we deliver the insight they need to separate risk from opportunity and make confident decisions when it matters most.


Wood Mackenzie Brand Video


Wood Mackenzie Values

  • Inclusive we succeed together
  • Trusting we choose to trust each other
  • Customer committed we put customers at the heart of our decisions
  • Future Focused we accelerate change
  • Curious we turn knowledge into action

Role Summary

We are seeking an experienced Data Architect to lead design and manage our modern data infrastructure with a strong focus on Snowflake data modelling dbt and data engineering. The ideal candidate will play a key role in shaping AI‑centric data solutions that support scalable product development analytics operational efficiency and strategic decision‑making.


With an emphasis on Data as a Product this role requires strong leadership effective cross‑functional communication and a strategic collaboration with the Head of Data the incumbent will develop a robust operating model for implementing the data strategy ensuring that required skills and capabilities are established throughout the organisation. Additionally they will be responsible for ensuring data contracts are established guaranteeing that all data is suitably prepared for product development analytics and AI applications.


Role Responsibilities

  • Design and implement robust data architectures leveraging Snowflake and AWS cloud data platform.
  • Develop and maintain scalable data models to support product delivery analytics and business intelligence needs.
  • Lead the design and implementation of data transformation workflows using dbt or other identified solutions.
  • Establish operating model with data / analytical engineers to build reliable data pipelines models and integrations.
  • Ensure data quality governance and security across all data systems and platforms in collaboration with broader architecture group.
  • Optimize data storage performance and cost within the cloud data environment.
  • Document architectural standards best practices and data lineage.
  • Provide technical leadership and mentorship on data engineering modelling and architecture topics.
  • Experience of using AI to accelerate all aspects of good data management.

Key Skills and Experience

  • Proven experience designing and managing data architectures using Snowflake and AWS environments at scale.
  • Excellent leadership collaboration and communication skills across large multi‑disciplined organisations.
  • Practical expertise in designing enterprise ontologies and knowledge networks.
  • Strong understanding of dimensional and normalized data modelling techniques.
  • Hands‑on expertise in dbt for data transformation and pipeline orchestration.
  • Solid background in data engineering with proficiency in SQL and Python.
  • Experience with ELT / ETL frameworks and modern data stack tools.
  • Knowledge of data governance access control and privacy best practices.
  • Proficiency in applying AI foundations to ensure data is aligned for consumption and content generation.

Equal Opportunities

We are an equal opportunities employer. This means we are committed to recruiting the best people regardless of their race colour religion age sex national origin disability or protected veteran status. You can find out more about your rights under the law at


If you are applying for a role and have a physical or mental disability we will support you with your application or through the hiring process.


Employment Details

Employment Type: Full‑Time


Experience: years


Vacancy: 1


#J-18808-Ljbffr

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.