Spend Data Analyst
Share
Job Location:
Mexico City - Mexico
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Wood Mackenzie is the global data and analytics business for the renewables energy and natural resources industries. Enhanced by technology. Enriched by human an ever-changing world companies and governments need reliable and actionable insight to lead the transition to a sustainable future. Thats why we cover the entire supply chain with unparalleled breadth and depth backed by over 50 years experience. Our team of over 2400 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.
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
Does your perfect day consist of cleansing researching and enriching complex data for customers to find useful insights and connections Do you have a passion for slicing-and-dicing data Would you like to categorize and classify data to make it more usable for our customers Do you enjoy working in a collaborative environment where you are constantly learning
Wood Mackenzie Supply Chain is seeking a Spend Data Analyst to join our team to provide cutting edge intelligence for supply chain organizations in the energy industry. We are looking for a team player who thrives in an agile and dynamic environment and wants to enrich data to deliver superior customer results.
As a Spend Data Analyst within Wood Mackenzie Supply Chains Spend Intelligence Group you will use your keen eye for detail your creative analytical skills and your love for working in a team to help Wood Mackenzie maintain its leadership position in energy information. The Spend Data Analyst is a key member of the Spend Intelligence Group responsible for the data aggregation normalization classification and enhancement process which turns raw customer spend data into Spend Intelligence. The analyst will utilize robust technology tools and energy industry knowledge to create a truly unique product that is critical to Wood Mackenzies Supply Chain Intelligence Platform.
Main Responsibilities
- Perform data extraction manipulation cleaning analysis and QA of large datasets
- Research energy industry data and suppliers to accurately and granularly classify spend into industry-specific schemas
- Evaluate categorized transactions to identify misclassified content redundant and/or ineffective categorization logic
- Collaborate in a self-managed Agile team an innovation Wood Mackenzie has adapted from the software development domain
About You
- 3 years experience
- Bachelors degree required
- Proficient in Microsoft Office Suite with advanced Excel skills including vlookups pivot tables and queries
- Exceptional analytical organizational problem solving and time management skills with attention to detail
- Proven ability to learn quickly in a fast-paced environment to manage multiple tasks and/or projects with changing priorities and to communicate effectively at all levels
- Ability to balance independent and team-based work
- Manages large volumes of data and ensures quality throughout the process
- Experience with data manipulation tools to solve complex quantitative problems such as joining multiple different data sources or troubleshooting data discrepancies
- Creative and innovative problem-solving skills
- A self-starter who takes initiative asks questions and is eager to learn
- Proficiency in the English language required
Pluses:
- Experience in the energy industry
- Proficiency with databases
- Proficiency with Talend or other ETL software
- Experience in spend analysis
- Some programming experience with Python or Java preferred
- Prior experience analyzing external datasets using Python SQL or visualization tools
Expectations
- We are a hybrid working company and the successful applicant will be expected to be physically present in the office at least 2 days per week to foster and contribute to a collaborative environment but this may be subject to change in the future.
- Due to the global nature of the team a degree of flexible working will be required to accommodate different time zones.
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
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.
Required Experience:
IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
Empower strategic decision-making in global natural resources with quality data, analysis and advice. Discover the latest insights and reports online.
