Spend Data Analyst

WM de Mexico, S. de R.L. de C.V.; Ciudad Universitaria; Híbrido; MXN 558,000 - 745,000; Jornada completa

Descripción de la vacante

A leading analytical company seeks a Spend Data Analyst in Mexico City. The role involves data manipulation, research, and collaboration in an Agile team. Applicants should have over 3 years of experience, advanced Excel skills, and proficiency in English. The position offers a hybrid work model, requiring office presence at least 2 days per week.

Formación

• 3+ years’ experience in data analysis.
• Proficiency in English is required.
• Ability to communicate effectively at all levels.

Responsabilidades

• Perform data extraction, manipulation, and analysis.
• Research industry data to classify spend.
• Collaborate in an Agile team.

Conocimientos

Microsoft Office Suite proficiency

Advanced Excel skills

Analytical skills

Attention to detail

Problem-solving skills

Data manipulation

Herramientas

Talend or other ETL software

Python

SQL

Descripción del empleo

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.

• 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 Chain’s 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 Mackenzie’s 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
• 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
• 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.

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.

If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!

About Us

Our Work Experience is the combination of everything that's unique about us: our culture, our core values, our company meetings, our commitment to sustainability, our recognition programs, but most importantly, it's our people.

Our employees are self-disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.