Retail MIS Analyst

Key Responsibilities

Reporting and Dashboard Management

• Develop and maintain daily, weekly, and monthly MIS reports and dashboards.
• Monitor sales performance, stock-to-sales ratios, sell-through rates, and footfall.
• Automate recurring reports and reduce manual reporting processes.
• Provide timely data analysis to support retail operations and management decisions.

Retail Data Management and Integrity

• Extract, clean, analyze, and reconcile transactional data from POS, warehouse management, and e-commerce systems.
• Identify data discrepancies in inventory and pricing records.
• Maintain accurate and consistent product codes, store records, and promotional data.
• Work with relevant departments to resolve data quality issues.

Inventory and Supply Chain Analytics

• Monitor inventory ageing, slow-moving stock, stock availability, and replenishment cycles.
• Support merchandising and supply chain teams with inventory performance reports.
• Develop tracking templates for promotional activities, markdowns, and seasonal stock management.

System Enhancement and Process Improvement

• Identify opportunities to automate reporting processes and improve operational efficiency.
• Collaborate with IT teams and database administrators on system upgrades and enhancements.
• Support the testing and implementation of ERP modules and data management systems.

Qualification and Experience

• 2–5 years of relevant experience in data analysis, business intelligence, or management reporting.
• Experience in retail, FMCG, or e-commerce will be an advantage.
• Strong proficiency in SQL and database querying.
• Advanced Microsoft Excel skills, including Pivot Tables, Power Query, advanced formulas, and Macros/VBA.
• Experience developing interactive dashboards using business intelligence and data visualization tools.
• Familiarity with retail ERP systems such as SAP, Oracle Retail, or Microsoft Dynamics.
• Good understanding of retail performance metrics, inventory turnover, shrinkage, and sales conversion.

Required Skills and Competencies

• Strong analytical and problem-solving skills.
• Excellent attention to detail and data accuracy.
• Ability to interpret complex data and present findings clearly.
• Strong communication and interpersonal skills.
• Ability to work under pressure and meet reporting deadlines.
• Good organisational and time-management skills.

Additional Advantage

• Experience using Python or R for advanced data analysis and data processing.
• Exposure to retail planning and inventory

Salary: GHS 2,500 Net (Negotiable)

Location: North Industrial Area (Accra)