Job Description
BI Administrator
Position Purpose
The position is two-fold: First, to provide admins 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.
Responsibilities
Customer Relations Management
- 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
- National consolidation of KPI reports for key group accounts and distribution thereof
Development of Group reports in Analysis excel, also using formulas, macros, pivot tables etc- Analysis of master data integrity and supply chain classifications that has an impact on company metrics
- Continuous analysis of commercials and integrity thereof
- 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.
- Continues automation of all reporting
Development of advanced excel reporting that is interactive for our customers with the specific aim of highlighting key KPI’s.
Adherence to Business Rules and Best Practises National Co-ordination of group accounts 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
Qualifications
Essential – MATRIC + 3 (Degree), preferably B. Com
Desirable; Degree Level or Professional Qualification in Business Analytics, IT or Accounting;
Experience
- 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, Salesforce
- 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
Skills and 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.
Preferred Education
Bachelors
Preferred Level of Work Experience
3 – 5 years
We are an Equal Opportunity Employer and we are committed to developing a diverse workforce in which everyone is treated fairly, with respect, and has the opportunity to contribute to business success while realizing his or her potential. This means harnessing the unique skills and experience that each individual brings and we do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state, or local protected class.
Individuals fraudulently misrepresenting themselves as Brambles or CHEP representatives have scheduled interviews and offered fraudulent employment opportunities with the intent to commit identity theft or solicit money. Brambles and CHEP never conduct interviews via online chat or request money as a term of employment. If you have a question as to the legitimacy of an interview or job offer, please contact us at [email protected].