Sales Operations Reporting Analyst

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.

**Wood Mackenzie brand video**

**Job Description**:
A key purpose of this role is supporting the design and build of reports, dashboards and data extracts needed to review leading indicators of sales performance and customer analytics. Working to understand both internal and external requirements, then providing solutions to meet those requirements. Solutions must be efficient and effective in their use and design, turning data into actionable insights and intelligence.

**Responsibilities to include**:
**Sales Performance Reporting**
- Support the Sales division in reaching their goals through data analysis
- Generate insightful recommendations from reporting to improve commercial performance
- Understand the end-to-end sales process and ensure reporting drives consistent improvements

**Customer Usage Reporting**
- Support the creation and maintenance of customer usage reports and dashboards to meet the needs of Sales, Customer Organisation, as well as the wider business
- Support requests for ad-hoc analysis required in custom formats

**Product Pricing Support**
- Provide support to the Product Pricing team as required
- This may include data audit activities, and maintenance of price books and other pricing tools
- Support the price setting process, including discount analysis, risk analysis & replacement costs

**Sales Resourcing and Target Setting**
- Data audits to ensure alignment of sales opportunity and target ownerships throughout the year
- Data audits to ensure sales opportunity ownerships fall within sales matrix rules
- Work with Global Sales Managers and Account Managers to correct issues discovered

**General**
- Act as a key point of contact for any data or reporting queries
- Auditing of data for quality through its lifecycle to ensure its accuracy and efficacy for use
- Provide day-to-day support to key stakeholders, understanding issues and requirements, ensuring quick and high-quality response
- Create and maintain documentation to provide clear understanding of processes
- Ensure actions and tasks are delivered on schedule and to a high standard
- Ensure any delays/issues are raised and items escalated as appropriate
- Operate with best practice to deliver a globally consistent 'best in class' service
- Ensure quality and accuracy in all work completed
- Proactive in terms of identifying key stakeholder needs (business partner mindset)

All reporting, analytical and insight solutions must be effective, optimal and scalable

**Qualifications**:

- 3+ years of related experience in a similar role
- Relevant Bachelor’s degree, or equivalent combination of education and experience
- Some experience of sales environments and data, with acute commercial and business awareness
- Advanced knowledge of MS Excel (vlookups, pivot tables & reporting, data models etc.)
- Experience in using data visualisation tools (Power BI preferred)
- Some knowledge of SQL and DAX preferred but not essential
- Knowledge of CRM systems (Salesforce preferred)
- Analytically minded with strong problem solving and data analysis skills
- Curious and driven to unlock the insights available in large complex data sets
- A high level of attention to detail
- Good organisation and time management skills, with the ability to work autonomously
- Ability to elicit stakeholder requirements and turn requirements into a set of data outputs
- Strong communication skills with ability to present clear information
- Ability to build and maintain effective relationships
- Confident, self-motivated, professional, proactive, and entrepreneurial

Additional Information
- “Wood Mackenzie is a place where we are committed to supporting our people to grow and thrive. We value different perspectives and aspire to create an inclusive environment which encourages diversity and fosters a sense of belonging._
- Wood Mackenzie values everyone’s contribution and helps them reach their full potential while sustaining an organisational culture of health and well-being._
- Our core values are:_
- _ Inclusive - we succe