On Demand Analytics Planner

On Demand Analytics Planner at takealot.com – Cape Town takealot.com, a leading South African online retailer, is looking for a highly talented On-Demand Analytics Planner to join our team in Cape Town. This hybrid role combines inventory planning, data analysis, and process optimisation to support our fast-paced on-demand services operations. The role is responsible for ensuring efficient inventory replenishment across our dark store network, whilst leveraging data analytics to drive informed decision-making and continuous process improvements. Responsibilities Inventory Planning; Management (50%) Monitor inventory levels and manage the replenishment process to maintain continuous product availability across dark stores. Analyse sales data and inventory reports to forecast needs and adjust inventory levels accordingly. Coordinate and execute weekly cycle counts and investigations for stock discrepancies. Act as primary point of contact for dark stores regarding missing, damaged, or expired stock issues. Manage returns processing, ensuring accurate scheduling based on store requests and operational requirements. Develop strategies to minimise waste and markdowns whilst improving inventory turnover. Data Analysis; Business Intelligence (30%) Create and maintain business reports, dashboards, and alerts using BI tools (Looker and Knime). Extract, manipulate, and analyse data using SQL to provide actionable insights for stakeholders. Verify data quality and ensure adherence to required standards across all reporting structures. Model data for analysis and develop performance metrics for inventory and operational efficiency. Collaborate with internal stakeholders to understand their reporting and data analysis needs. Process Optimisation; Problem-Solving (20%) Identify systematic inefficiencies and recommend process improvements. Manage workflows for order processing, including file uploads, batch scheduling, and WMS coordination. Escalate and manage tickets between distribution centres and stores for operational discrepancies. Participate in cross-functional team meetings to discuss operational issues and develop solutions. Drive continuous improvement initiatives across planning and operational processes. Attributes Essential: Strong SQL skills for database querying and data manipulation. Essential: Proficiency with BI tools (Power BI, Looker, Qlik, or similar). Essential: Advanced knowledge of Microsoft Office Suite/Google Workspace (particularly Excel/Sheets). Working knowledge of inventory management systems and WMS platforms. Experience with customer service platforms (Zendesk or similar) advantageous. Familiarity with GBQ (Google BigQuery) preferred. Qualifications and Experience Bachelor's Degree in Commerce, Business Management, Information Systems, Supply Chain Management, or related field. 1-3 years of experience in inventory management, retail planning, business analysis, or related roles. Experience within e-commerce, retail, or quick commerce environments highly advantageous. Proven track record of working with inventory management systems and data analysis tools. We seek to employ an Extraordinary Mind who is respectful but forthright, an expert at doing who can design and execute, analytical, competitive and self-directed, and passionate about delivering a world-class customer experience. The right candidate will be entrepreneurial, adaptive to change, business-smart, curious, innovative, collaborative, and will think like an owner with integrity and hard work. Takealot is an Equal Opportunity Employer. Applicants from the previously disadvantaged groups and people with disabilities will be given preference. #J-18808-Ljbffr