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: Data Analyst
Team: P&R Data – Assets
Location: Madrid
Band: F
We are looking for a Data Analyst to join Wood Mackenzie’s Power and Renewables Assets 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 researchers
- 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
- Experience in the power modelling domain a plus
- Fluent in English
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.
