General Information
Job title:
BI Analyst (Pricing)
Purpose:
The purpose of this role is to provide insights to the Pricing & Distribution Leaders, as well as the SPM Financial Controller. The BI Analyst’s core focus will be around centralized pricing, ensuring that commercial opportunities are maximized. This will involve utilizing numerous data sources to serve up solutions and recommendations to the main stakeholders. Excellent commercial acumen and understanding of the business is critical in order to provide the right level of support and challenge the business where deemed necessary.
Primary duties and responsibilities (KRAs)
Pricing and Commercial Opportunities
• Extracting and transforming complex and large data into insights for the P&D Leaders as well as the SPM FC.
• Creating visualizations in order to convey the necessary information in a simplified and insightful manner to enable the business to make quick decisions and maximize commercial opportunities.
• Serving up solutions and recommendations aimed at capturing commercial opportunities around centralized pricing.
• Analyzing external competitor data to identify opportunities and risks.
• Seeking out external data around competitors and the industry overall to ensure improvements internally are recommended and implemented where necessary around our pricing strategy.
• Flagging risks in the current or new processes to ensure that awareness is generated and remediate action is taken.
• Identifying information and insights that need to be set up into regular reports and processes.
• Dealing with ad hoc requests, not only from the P&D Leaders or the SPM FC, but also the SPM SWOT & Finance SWOT teams where needed.
• Engage and build strong multi-level relationships within the business to ensure that the BI Analyst continuously grows their understanding of the business and develops themselves.
Hierarchy:
Reports into the Financial Controller – Supply, Pricing & Marketing, as well as a dotted line into the Pricing & Distribution Leaders (Air & Land). Works closely with the SPM SWOT team as well as the overall finance team.
Key communication and relationships:
Internal: Works closely with the P&D Leaders, the SPM SWOT Team, the Finance SWOT team as well as the overall finance and SPM departments.
Job Requirements
Education and qualification:
Minimum requirements
Added advantage
A degree in a related field (i.e. Business, Commerce, Finance or Accounting) as well as excellent knowledge of BI tools and SQL.
Experience:
• 5 years experience in a similar role.
• Advanced level in PowerBI
• Advanced knowledge of SQL
• Advanced knowledge of Excel
• Experience in a finance role
• Track record of strong oral & written communication as well as good interpersonal skills.
• Track record of being accurate, deadline driven and detail oriented.
• Strong time management – flexible and able to balance multiple priorities.
Other:
Location:
Main Head Office – Johannesburg
Travelling:
No travel required
Office hours:
08:00am to 17:00pm Monday to Friday
Additional:
Attendance of company functions is required