Data Analyst

JOB TITLE: Data Analyst
Role Purpose 
The purpose of this role is to support the local purchasing function by ensuring accurate data management, insightful reporting and actionable analysis to enable informed purchasing, inventory and sales decisions. The role is responsible for cleaning, validating and consolidating data from the ERP system, preparing regular sales, stock and performance reports and analyzing trends across branches, categories, products and sales teams. Through timely reporting, inventory monitoring, supplier reporting and support to local imports, the role contributes to optimal stock availability, efficient purchasing and improved overall business performance.

Roles and Responsibilities
(i)    Clean, validate and consolidate data from the ERP system to ensure accuracy, consistency, and reliability of all sales, stock, and performance reports.
(ii)    Prepare and submit weekly and monthly sales and performance reports to support management decision-making and operational planning.
(iii)    Conduct detailed sales trend analysis at branch, category, product, and salesperson levels to identify performance patterns, growth opportunities, and areas requiring corrective action.
(iv)    Update inventory reorder level templates on a weekly basis using sales velocity, stock levels and historical consumption data to support optimal stock availability and prevent over- or under-stocking.
(v)    Prepare weekly best-sellers reports to highlight high-performing products and support purchasing, merchandising, and promotional decisions.
(vi)    Generate bi-weekly stock comparison reports between the central warehouse and branches to identify variances, discrepancies, and stock movement issues, and escalate findings for action.
(vii)    Prepare, analyze and share sales and performance reports with consignment suppliers to support transparency, reconciliations, and supplier performance management.
(viii)    Support the local imports process by tracking relevant data, preparing reports, and providing analysis to monitor lead times, costs, quantities and delivery performance.
(ix)    Develop and deliver personalized data reports and analysis on request to meet the specific needs of management, purchasing, operations and other stakeholders.
(x)    Maintain proper documentation of reports, templates and data sources to ensure consistency, audit readiness, and ease of reference.
(xi)    Collaborate closely with purchasing, warehouse, finance and branch teams to ensure data accuracy, timely reporting and effective use of insights in operational decisions.

Minimum Requirements for the role
•    Bachelor’s degree in Business Administration, Supply Chain Management, Statistics, Data Analytics, Finance, or a related field.
•    Proven experience in data analysis, reporting, purchasing support, buying/procurement background or inventory management.
•    Should have exposure to purchasing and buying functions, with familiarity in import and export processes.
•    Experience working in retail is an added advantage.
•    Strong proficiency in Microsoft Excel and data analysis tools is a MUST.
•    Experience working with ERP systems and large datasets.
•    Strong analytical, problem-solving, and reporting skills.
•    High level of attention to detail and data accuracy.
•    Excellent communication and collaboration skills.
•    Ability to manage multiple reports and meet strict deadlines.