Wood Mackenzie Logo

Wood Mackenzie

Data Architect

Posted Yesterday
Be an Early Applicant
In-Office
Edinburgh, Midlothian, Scotland, GBR
Mid level
In-Office
Edinburgh, Midlothian, Scotland, GBR
Mid level
Design and manage data infrastructure with a focus on Snowflake, data modeling, and engineering. Lead data architecture and governance, ensuring quality for AI applications and analytics.
The summary above was generated by AI

Wood Mackenzie is the global leader in analytics, insights and proprietary data across the entire energy and natural resources landscape.


For over 50 years our work has guided the decisions of the world’s most influential energy producers, utilities companies, financial institutions and governments.


Now, with the world’s energy system more complex and interconnected than ever before, sector-specific views are no longer enough. That’s why we’ve redefined what’s possible with Intelligence Connected.


By fusing our unparalleled proprietary data with the sharpest analytical minds, all supercharged by Synoptic AI, we deliver a clear, interconnected view of the entire value chain. Our trusted team of 2,700 experts across 30 countries breaks siloes and connects industries, markets and regions across the globe.


This empowers our customers to identify risk sooner, spot opportunities faster and recalibrate strategy with confidence – whether planning days, weeks, months or decades ahead.


Wood Mackenzie
Intelligence Connected


WoodMac.com

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 mindset. In 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 www.eeoc.gov 

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.  

Top Skills

AWS
Dbt
Python
Snowflake
SQL

Similar Jobs

3 Hours Ago
Hybrid
Senior level
Senior level
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead WAM data architecture and cloud transformation engagements: define enterprise data strategies, design canonical WAM data models, architect cloud-native data platforms, integrate core WAM systems, establish data quality and control frameworks, and advise senior stakeholders on technical-to-business translation.
Top Skills: AWSAzureBloombergCloud-Native Data PlatformsCRMData LakeDatabricksFund AccountingGCPGraph ComputingModern Data StackOmsPmsSemantic Data Modelling
6 Days Ago
Hybrid
Senior level
Senior level
Healthtech • Biotech
The Data Architect will design, manage, and leverage data across Genomics England, ensuring data quality and compliance while guiding enterprise-scale data solutions.
Top Skills: Cloud Data PlatformsData ArchitectureData IntegrationData ModellingFhirGa4GhMetadata ManagementOmop
11 Days Ago
In-Office
Senior level
Senior level
Marketing Tech
The Lead Enterprise Data Architect leads the enterprise-wide data architecture strategy, influences data governance, and aligns data initiatives with organizational objectives. This role requires strategic direction, cross-functional collaboration, and expertise in complex data ecosystems.
Top Skills: AWSAzureConfluenceDatabricksGCPJIRAMaster Data Management

What you need to know about the Edinburgh Tech Scene

From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account