Company Description

Wood Mackenzie are the global research, analytics, and consultancy business powering the natural resources industry. For 50 years, we have been providing the quality data, analytics, and insights our customers rely on to inspire their decision making.

Our dedicated oil, gas & LNG, power & renewables, chemicals, metals & mining sector teams are located around the world and deliver a variety of projects based on our assessment and valuation of thousands of individual assets, companies, and economic indicators such as market supply, demand, and price trends.

We have over 1,900 employees in 30 locations, serving customers in nearly 80 countries. Together, we inspire and innovate the markets we serve – providing invaluable intelligence to help our customers overcome the toughest challenges, and make strategic decisions that will, ultimately, accelerate the world’s transition to a more sustainable future.

WoodMac.com

Wood Mackenzie brand video

Job Description

Role Purpose

This role will form part of the Metals & Mining Data team and will work closely with our Research, Product and Engineering colleagues. The successful candidate will be help solve challenges around data management, pipelines, analysis and data quality. 

The success of this role will require attention to detail, collaboration & problem solving. The core objective is to help manage and migrate workflows from legacy systems & deliver internal efficiencies through data. Ensuring we have a supportive and inclusive culture within our team is essential. 

Main Responsibilities

• Gain a deep understanding of our customer data and existing landscape and business processes and be the go-to person for questions about data/product/business processes
• Collect, extract, and compile data from various sources, ensuring its accuracy and completeness
• Identify and address data quality issues, such as missing or inconsistent data, by partnering with data engineers and implementing data cleansing techniques in analysis
• Determining, creating, and implementing internal process improvements, such as redesigning infrastructure for increased scalability, improving data delivery, and automating manual procedures
• Building necessary infrastructure using AWS and SQL technologies, and using Python/Java scripting for data flows creation. This will enable effective data extraction, transformation, and loading from a variety of data sources
• Collaborate with cross-functional teams and business stakeholders to understand their analytical needs and provide timely and relevant reports

#LI-AF1

Qualifications

About You

• Minimum 3-5 years of experience working as Data Analyst with data engineering experience as well
• Ability to reverse engineer the existing codes/scripts
• Possess a creative, systematic, and logical approach to problem-solving
• Preferable experience working in both cloud-based and on-premise platforms
• Ability to gather business requirements and translate to technical specifications
• Experience in automating data ingestion, data cleansing, data warehouse, data lake and data management concepts
• Deep knowledge of data modelling best practices and experience in APIs or web scraping
• Must have excellent writing skills, including the ability to write user guides and technical/functional documentation for complex processes that is concise, yet thorough
• Experience producing project artefacts, including meeting notes, mock-ups, process maps, and data flow diagrams to convey functionality to stakeholders and development teams
• Experience using tools (such as Jira, Confluence, or TFS) to document and trace requirements
• Proficient in MS Excel, MS Word, MS PowerPoint, and MS Visio
• Good problem solving, attention to detail and analysis skills
• Keen Interest in Commodity Market Dynamics, highly adaptive team player, growth mindset, change agility

Additional Information

WoodMackenzie is an equal opportunities employer.

We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran’s status, age or disability.

https://www.woodmac.com/careers/jobs/

Unsolicited resumes sent to WoodMackenzie, including unsolicited resumes sent to a WoodMackenzie business mailing address, fax machine or email address, or directly to WoodMackenzie employees, will be considered WoodMackenzie property. WoodMackenzie will not pay a fee for any placement resulting from the receipt of unsolicited resume.

WoodMackenzie takes your data privacy seriously, please click here to view our privacy notices: Candidate Privacy Notice | Wood Mackenzie | Wood Mackenzie / Candidate Notice - California