JOB RESPONSIBILITIES

• Responsible for updating, maintaining, and ensuring data consistency and reliability in the Point of Sale (POS) system, ERP system, and report system.
• Implement and maintain data security measures to safeguard sensitive information within the current system and SQL databases.
• Facilitate seamless data integration between the POS and ERP systems for efficient data flow.
• Support biweekly stock-take processes by monitoring and validating ERP data transactions to ensure accurate stock records and timely reporting.
• Regularly update the daily sales report of stores to identify discrepancies or anomalies, ensuring accurate revenue tracking.
• Update and maintain promo keys in the POS system to facilitate smooth promotional activities.
• Develop and optimize SQL reports tailored for different departments to provide relevant insights and support data-driven decision-making.
• Conduct detailed data analysis on various datasets used across business units to evaluate business processes.
• Design and develop tools, metrics, and interactive dashboards for data visualization, enabling stakeholders to gain insights into business performance.
• Conduct in-depth reviews to identify root causes of data issues and collaborate with relevant teams to implement corrective measures, ensuring data integrity.
• Provide training and support to business units on data analysis tools and methodologies, fostering a data-driven culture.
• Assist users with data transaction issues, providing timely resolution and support.

QUALIFICATION, EXPERIENCE & SKILLS REQUIRED

• Bachelor’s degree in computer science, Statistics, Mathematics or related field
• Minimum of 2 years of experience as a Data Analyst in the F&B sector, with hands-on experience in ERP, POS, and data analysis
• Higher Proficiency in SQL, Python, and Excel for data manipulation, statistical analysis, and reporting.
• Experience in data visualization tools like Power BI, DAX, Tableau, or similar.
• Strong analytical skills with the ability to interpret complex data sets.
• Familiarity with ERP and other relevant F&B industry software is a plus
• Strong problem-solving skills with a keen attention to detail and an ability to proactively address data-related challenges
• Maintains a positive ‘can-do’ approach and eager to learn new systems and technologies
• Ability to work collaboratively and support colleagues in achieving common goals
•