Business Intelligence (BI) Administrator at Pepkor Speciality

Job Description    

• Pepkor Specialty Distribution Centre, based in Durban's Cornubia, is seeking to employ a highly motivated BI Administrator to support operations by providing accurate reports and data analysis. You will play a key role in managing and distributing operational reports, ensuring data accuracy, and providing insights to support decision-making across the DC. 

Qualifications    

• Minimum of 1-2 years of experience
• Relevant tertiary qualification in Supply Chain Management or Bachelor of Commerce in Accounting
• Must have Microsoft Office (Teams, Excel, PowerPoint, and Word) and Power BI knowledge

Knowledge, Skills and Experience    

• Knowledge of RMS, QlikView, and Qlik Sense
• Time management skills
• Strong analytical and problem-solving skills
• Knowledge of supply chain processes
• Strong analytical and reporting skills, including report analysis.
• High attention to detail
• Good time management skills with the ability to meet deadlines
• Problem-solving ability
• Effective communication skills

Key Responsibilities    
Reporting & Dashboard Development
Design and maintain dashboards for DC operations, such as:

• Order fulfillment rates
• Inventory accuracy
• Picking/packing productivity
• On-time dispatch and delivery
• Use BI tools (e.g., Power BI, Tableau, Qlik) to create visual insights for managers.
• Customize reports for different stakeholders (warehouse supervisors, supply chain managers, executives)

Other Duties (Outside of Reporting)

• Support the DC track breakbulk and ensure stock does not stay too long on the floor.
• Prepare and publish the outbound report twice weekly
• Provides visibility into the number of utilized bins for stock racked within the DC.    
• Verified routing file for the DC to ensure accurate LPN label printing
• Conducted whenever routing changes occur, new stores are added, or LPNs print incorrectly
• NSI (Non-Sellable Items) allocations:
• Stationery: allocated upon ROM request to Livewire
• Sellable Packaging: allocated weekly to ensure store readiness.
• Stock in transit tracking (as required)
• Cross-border invoice duties.