BI Administrator at CHEP

Position Purpose:

• To provide office-based support to internal & external customers by analysing customer data ensuring that revenue, volume, profitability and customer service objectives are achieved. Manage, develop and enhance a suite of ad-hoc and scheduled reporting outputs, turning data into information to meet specific requirements of internal and external customer.

Key Accountabilities:

1. Customer Relations Management            
2. Liaison with client management as defined by the client profile.
3. Provide feedback to customer senior management on statistics, and handle business usage profile related problems.
4. Have a good understanding & business mind to be able to analyse customer usage profile, identify areas where improvements are required and escalate these in order for customers to make better business decisions
5. Entering into written correspondence with customer senior management.
6. National consolidation of KPI reports for key group accounts and distribution thereof
7. Development of Group reports in Analysis excel, also using formulas, macros, pivot tables etc
8. Analysis of master data integrity and supply chain classifications that has an impact on company metrics
9. Continuous analysis of commercials and integrity thereof
10. Development of workbooks within BW Analysis, compile as and when necessary on behalf of the FMCG team and ensure integrity of the data before distributing.
11. Continues automation of all reporting
12. Development of advanced excel reporting that is interactive for our customers with the specific aim of highlighting key KPI’s.  
13. Adherence to Business Rules and Best Practises
14. National Co-ordination of group accounts
15. Proficiency required on systems i.e. Advanced Excel/word, Advanced Analysis and Power BI

New and existing business development by:

• Ensure that relevant prospect information is obtained and all new accounts processed into the system
• Participate in new business projects.
• Assist BM/BR in all admin related tasks

Required Qualification, Experience and Skills

• Essential – MATRIC + 3 (Degree), preferably B.Com Desirable;
• Degree Level or Professional Qualification in Information Management/IT, Business or Accounting; SQL or similar

 
Skills and Knowledge

• Experience of Supply Chain industry – beneficial
• Experience of working with multiple business functions/stakeholders
• Ability to manage complex datasets, extracting data from Business Warehouse (Analysis), SAP, Siebel
• Delivering technical solutions on how best to present information to internal and external stakeholders and deliver process improvements across the wider business.
• 3-5 years BI Administration experience
• Ability to manage workload and deliver to deadline
• Ability to communicate effectively across all reporting levels
• Advanced MS Excel skills (data visualisation, macro’s etc.)
• Basic/working knowledge of SQL is desirable (automated reports, custom views, Auto-formatting, data consolidation and management)
• Office 365; MS Teams, Power BI beneficial
• Must be a self-starter who has strong administration skills.
• Must be courteous and polite in written and oral communication.