Assistant Manager - Business Analytics

Courts Malaysia; Kuala Lumpur; On-site; MYR 50,000 - 70,000; Full time

Job summary

A leading retail company in Kuala Lumpur seeks a data-oriented professional to support the Business Analytics Manager. The role involves coordinating data extraction processes, automating reporting tasks using BI tools, and translating business requirements into actionable technical specifications. Candidates should possess a degree in Business Administration or Statistics and demonstrate strong SQL and Excel skills. Proficiency in English and Mandarin is highly preferred to communicate with stakeholders effectively.

Qualifications

• Degree in Business Administration, Statistics, or an IT-related field.
• Hands-on experience in SQL query writing and complex queries.
• Proficiency in advanced Excel functions for data reconciliation.

Responsibilities

• Coordinate data extraction from internal databases and ensure accuracy.
• Facilitate transition of manual reporting tasks to automated workflows.
• Support translation of business requirements into technical specifications.

Skills

SQL query writing

Advanced Excel functions

BI tool proficiency

Effective communication

Education

Degree in Business Administration, Statistics, or IT

Tools

Tableau

Power BI

Qlik

Job description

This role supports the Business Analytics Manager by executing technical data extraction, maintaining accuracy of reporting infrastructure, and automating routine delivery processes.

Key Responsibilities

Data Management & Extraction: Coordinate the end-to-end process of data extraction from various internal databases, ensuring all data sets are cleaned, reconciled, and ready for analysis.

Reporting Automation: Facilitate the technical transition of manual, repetitive reporting tasks into automated workflows and visual dashboards (e.g. Tableau, Power BI, or Qlik) to improve team productivity.

Operational Support: Support the translation of business requirements into technical specifications and handle Change Request (CR) to ensure reporting logic remains aligned with evolving business processes.

Team Coordination & Deputizing: Assist the manager in monitoring the distribution of ad-hoc and routine reports to ensure all deadlines are met with high accuracy and consistency. Act as the primary point of contact for the team during the Manager’s absence.

Key Requirements

Formal Education and Certification

Degree in Business Administration, Statistics, or an Information Technology-related field. Knowledge of business process design and conceptualization skills is essential.

Skills and Qualifications

Technical Proficiency: Hands-on experience in SQL query writing is essential, with the ability to write complex queries and optimized data extraction.

Excel Skills: Proficiency in advanced functions to support data reconciliation and the preparation of structured reports.

BI Tools: Familiarity with BI platforms such as Tableau, Power BI, Qlik, or Crystal Reports to support the maintenance of BI dashboards.

Communication: Ability to communicate technical findings clearly. Proficiency in English and Mandarin is preferred to facilitate effective communication with specific internal and external stakeholders.