Wood Mackenzie Logo

Wood Mackenzie

Data Analyst

Sorry, this job was removed at 06:22 p.m. (GMT) on Wednesday, Feb 11, 2026
In-Office
Edinburgh, Midlothian, Scotland, GBR
In-Office
Edinburgh, Midlothian, Scotland, GBR

Similar Jobs

15 Days Ago
Remote or Hybrid
United Kingdom
Mid level
Mid level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Analyze large-scale security telemetry, threat intelligence, endpoint, and detection data to identify trends, anomalies, and emerging threats. Build dashboards, reports, data pipelines, and KPI frameworks using SQL, Python, LogScale, or similar tools. Collaborate with data engineering, product, and engineering teams to ensure data quality and translate complex findings into actionable insights for technical and non-technical stakeholders.
Top Skills: Graph DatabasesLogscaleLookerMitre Att&CkPower BIPythonRSIEMSQLTableau
8 Days Ago
Hybrid
Internship
Internship
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Collect, maintain, and analyze Morningstar investment data across global markets. Support data accuracy, completeness, coverage, and production deadlines; collaborate with research analysts, fund companies, and third-party providers; assist with analytical tools, project teams, issue resolution, meetings, and daily team activities.
Top Skills: Lean Six SigmaMS Office
17 Days Ago
Hybrid
Junior
Junior
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Collects, maintains, and validates portfolio data across global markets, ensuring accuracy, completeness, coverage, and timely delivery. Collaborates with global data teams, fund companies, clients, and third-party providers. Improves procedures through analytical tools, automation, Lean Six Sigma, and process-improvement projects. Provides expertise on investment data calculations, supports portfolio template testing, handles data transfer agreements, and monitors relevant financial regulations.
Top Skills: AptLean Six SigmaTpt+

Wood Mackenzie is the global data and analytics business for the renewables, energy, and natural resources industries. Enhanced by technology. Enriched by human intelligence. In an ever-changing world, companies and governments need reliable and actionable insight to lead the transition to a sustainable future. That’s why we cover the entire supply chain with unparalleled breadth and depth, backed by over 50 years’ experience. Our team of over 2,400 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.

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 Purpose

The Data Analyst will play a key role in advancing forecasting and modelling efforts by managing, analysing, and optimising large datasets across renewable, conventional, and storage assets globally. Working on asset revenue forecasting, power dispatch modelling, or power markets data,  the analyst will focus on automating workflows, ensuring data quality, and delivering actionable insights through close collaboration with research, engineering, and product teams. This role contributes directly to improving forecasting accuracy and enhancing the company's global asset performance and revenue strategies.

Responsibilities

Knowledge:

  • Structures poorly defined problems, gathers feedback, and solves them effectively.
  • Defines hypotheses and appropriate analysis approaches.
  • Ensures statistical validity of results while avoiding common pitfalls.
  • Develops deep technical expertise and emerging domain knowledge in forecasting or dispatch modelling.
  • Provides specialist skills in data analysis, visualisation, and data management.
  • Fully understands the technical data landscape within the energy domain.
  • Maintains a growth mindset, continually evolving their skills.

Impact:

  • Performs defined and repeatable tasks with limited guidance.
  • Independently formulates new analyses and project components.
  • Carries out independent analysis on specific areas of forecasting or modelling projects.
  • Delivers high-quality outputs on time, recognised for accuracy and reliability.
  • Demonstrates strong proficiency in SQL or Python for data handling.

Collaboration:

  • Supports data governance and quality assurance activities.
  • Engages directly with stakeholders, building confidence in data-driven outcomes.
  • Works closely with peers in Research, Product, Data, Data Engineering, and other business functions.

Innovation:

  • Identifies opportunities for efficiency, optimisation, or new data creation within their focus area.
  • Uses technical and domain knowledge to create new value and insights.

Specialisms

General:

  • Owns and manages data within their role or team focus.
  • Leverages specialist toolsets or domain expertise for data analysis and decision-making.

Data Modelling:

  • Applies best practices in data modelling to support use cases.
  • Translates data requirements into effective data structures.
  • Collaborates with engineers to enhance data modelling capabilities for large-scale datasets.

Key Expectations

Experience & Qualifications:

  • 2–4 years of experience in data analysis, including handling large, complex datasets.
  • Advanced SQL skills for querying and managing relational databases.
  • Familiarity with data visualisation tools (e.g., Sisense, Power BI, Streamlit).

Technical Skills:

  • Experience with ETL processes and APIs for data integration.
  • Understanding of statistical methods and data modelling techniques.
  • Familiarity with cloud platforms like Snowflake is advantageous.
  • Knowledge of data governance frameworks and data security protocols.

Soft Skills:

  • Exceptional attention to detail and problem-solving capabilities.
  • Strong communication skills, able to translate complex insights for non-technical stakeholders.
  • Collaborative mindset with a commitment to continuous learning and staying updated on energy sector trends.

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.  

HQ

Wood Mackenzie Edinburgh, Scotland Office

Edinburgh, United Kingdom

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