IT Systems Specialist & Business Analyst (F&B)

Salary: RM 4,000 – RM 5,000 per month

About the Role

We are seeking a hands-on and analytical IT Systems Specialist & Business Analyst to support our growing F&B operations across our headquarters and five outlets.

This hybrid role combines IT infrastructure management, SQL database administration, business data analysis, and CRM system support.

The successful candidate will be responsible for ensuring smooth daily IT operations while transforming business and customer data into actionable insights to support operational efficiency, sales performance, and business development strategies.

Key Responsibilities

1. IT Infrastructure & Technical Support

• Maintain, configure, and troubleshoot IT hardware across HQ and five F&B outlets, including POS terminals, receipt/kitchen printers, payment terminals, routers, and networking equipment.

• Monitor and maintain network connectivity (LAN/Wi-Fi) to minimize operational downtime.

• Provide timely technical support for system and hardware issues, particularly during critical business hours.

• Coordinate with external IT vendors for technical support, system maintenance, equipment procurement, and warranty claims.

• Maintain IT asset records, system documentation, and preventive maintenance schedules.

2. SQL Database & Systems Management

• Support and maintain SQL databases, including Microsoft SQL Server, MySQL, or PostgreSQL.

• Write and execute SQL queries to retrieve, organize, and analyze transactional, customer, inventory, and sales data.

• Perform database backups, data validation, maintenance, and user access management.

• Investigate database connectivity, data synchronization, and system integration issues.

• Ensure data accuracy, system reliability, and appropriate data security practices.

3. Business Data Analysis & Reporting

• Extract and analyze sales, customer, product, and operational data to support management decision-making.

• Develop and maintain dashboards and reports using Advanced Excel, Power BI, or Looker Studio.

• Monitor key F&B performance indicators, including:

• Outlet sales performance and trends

• Peak-hour sales and average transaction value

• Product sales performance and menu item popularity

• Customer spending patterns and purchase frequency

• Membership growth, retention, and customer segmentation

• Identify business trends and provide practical recommendations to improve operational efficiency, customer retention, and sales performance.

• Support the BD team in evaluating promotional strategies, pricing, and campaign effectiveness.

4. CRM & Digital Platform Support

• Support the configuration and maintenance of membership, CRM, POS, and digital promotion systems.

• Assist with customer segmentation, loyalty programs, voucher configuration, and promotional campaign setup.

• Support targeted SMS and WhatsApp campaign execution through approved CRM platforms.

• Monitor campaign performance, customer redemption behavior, and promotional ROI.

• Coordinate with system vendors to troubleshoot integration issues and ensure data consistency across platforms.

Job Requirements

Education & Experience

• Diploma or Bachelor's Degree in Information Technology, Computer Science, Information Systems, Business Analytics, or a related field.

• Minimum 2 years of relevant experience in IT support, database management, systems administration, or business data analysis.

• Experience in the F&B, retail, hospitality, or POS industry will be an added advantage.

Technical Skills

SQL & Database Management

• Proficient in SQL queries, including SELECT, JOIN, GROUP BY, subqueries, and data extraction.

• Practical experience with Microsoft SQL Server, MySQL, or equivalent relational databases.

• Understanding of database maintenance, backups, data integrity, and system integration.

IT Hardware & Networking

• Hands-on experience troubleshooting computers, POS terminals, printers, and networking equipment.

• Basic understanding of TCP/IP, LAN/Wi-Fi, routers, switches, and network troubleshooting.

• Ability to diagnose and resolve hardware, software, and connectivity issues independently.

Data Analytics & Reporting

• Proficiency in Microsoft Excel or Google Sheets, including PivotTables, lookup functions, and data analysis.

• Experience with Power BI, Looker Studio, or other business intelligence tools is an advantage.

• Ability to interpret business data and present findings in clear, practical reports.

CRM & Business Systems

• Familiarity with POS, CRM, loyalty programs, or membership management systems.

• Understanding of customer segmentation, promotional reporting, and campaign performance tracking is an advantage.

Desired Candidate Profile

• Strong problem-solving and troubleshooting abilities.

• Analytical mindset with good attention to detail.

• Able to work independently and manage multiple priorities.

• Good communication skills when coordinating with outlet teams, management, and external vendors.

• Willing to travel between HQ and outlets when technical support is required.

• Able to respond promptly to critical operational IT issues when necessary.

• Commercial awareness and an interest in using technology and data to improve business performance.

Why Join Us?

• Opportunity to work across IT systems, data analytics, and business development.

• Gain exposure to multi-outlet F&B operations, POS systems, and CRM platforms.

• Contribute directly to business improvement and digital transformation initiatives.

• Work closely with management on operational reporting, customer insights, and technology-driven strategies.