Wood Mackenzie Logo

Wood Mackenzie

Data Analyst

Posted 20 Days Ago
Be an Early Applicant
2 Locations
Junior
2 Locations
Junior
The Data Analyst role at Wood Mackenzie involves acquiring, analyzing, and preparing data for customer delivery and supporting research teams. Key responsibilities include ensuring data quality, creating data pipelines, collaborating with stakeholders, and identifying optimization opportunities in systems and datasets.
The summary above was generated by AI

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

Job Description

We are looking for a Data Analyst to join Wood Mackenzie’s Power and Renewables Data team.

This role will focus on the analysis, programmatic acquisition, and preparation of data for delivery to our customers and research teams.

Wood Mackenzie produces research and data that the energy industry relies on to understand and navigate the energy transition. Examples of products that you will contribute to include:

  • Power supply and demand long-term outlooks
  • Power market pricing history and long-term outlooks
  • Renewable technology supplier leaderboards
     

Responsibilities

  • Own the quality and delivery timeline of critical datasets
  • Obtain, transform, and deliver information from our databases to support industry analysis using Excel, PowerQuery, PowerBI, GraphQL, SQL, Sisense, Python, and Snowflake
  • Create and maintain workflows for internal stakeholders
  • Create and maintain data pipelines to feed customer facing products
  • Identify and assess opportunities for optimization of our systems, processes, and datasets
  • Monitor and resolve alerts in production environments to preserve the integrity of our products
  • Identify internal and external sources of data that will support customer needs
  • Collaborate with colleagues across multiple time zones and disciplines to uncover pain points, process improvements, and product requirements
     

About You

  • At least 2 years of experience in a data analyst or data engineering role
  • Experience working in environments reliant on SQL, Python, and Snowflake
  • Experience with ETL processes and APIs for data integration
  • Hands on approach to problem solving that delves into the details while maintaining the ability to succinctly propose solutions to steer management decisions
  • Independently completes projects given time and platform constraints
  • Desire to play a key role in the energy transition by delivering the data and research that catalyzes progress
  • Intellectual curiosity about the provenance of data and journey it makes to arrive at a destination
  • Passionate ownership of projects and excitement to share accomplishments with fellow Woodmackers
  • Preferred: Experience in the energy industry or power modelling domain
  • Fluent in English. Bonus language skills: Mandarin, Spanish

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

Excel
GraphQL
Power BI
Powerquery
Python
Sisense
Snowflake
SQL

Similar Jobs

3 Days Ago
2 Locations
Mid level
Mid level
Fintech • Financial Services
The Finance Data Analyst will support governance and oversight of finance data, improve data management, address data issues, and help establish robust finance data architecture.
Top Skills: Data ArchitectureData GovernanceData ScienceData StandardsFinancial Reporting
6 Days Ago
2 Locations
Mid level
Mid level
Biotech
The Data Analyst III will develop and implement financial concepts, prepare reports, analyze data trends, and support finance leadership. Strong analytical and communication skills are essential, with responsibilities including report preparation and process improvement collaboration.
Top Skills: ExcelOracle E1Power BIPythonSAP
9 Days Ago
2 Locations
Junior
Junior
Software • Database • Analytics
The Data Analyst will advance forecasting and modeling efforts by managing and optimizing large datasets across various energy assets. Responsibilities include delivering actionable insights, ensuring data quality, automating workflows, and collaborating closely with research and engineering teams. The role demands strong skills in SQL or Python and a focus on improving forecasting accuracy for global asset performance.

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