Senior Executive, Business Intelligence & Supply Chain Planning Analyst

BEACON MART; Petaling Jaya; On-site; MYR 70,000 - 110,000; Full time

Job summary

BEACON MART seeks a Senior Executive, Business Intelligence & Supply Chain Planning Analyst to transform customer, sales, SKU, and inventory data into actionable insights. The role links business demand, data structure, and supply planning to improve sales, product availability and inventory efficiency.

The candidate should excel in Power BI, Excel and data analysis, with strong data modelling skills and understanding of SKU coding.

Qualifications

• Strong Power BI, Excel and data analytical skills.
• Good understanding of data structure, SKU/product coding and data modelling.
• Strong numerical and logical-thinking ability.
• Able to understand both commercial and supply-chain requirements.
• Experience in Business Analytics, BI, Demand Planning, Retail/FMCG or Supply Chain preferred.
• SQL, ERP and POS system knowledge is an advantage.

Responsibilities

• Analyse customer, sales, SKU and inventory data across channels and translate into insights for Revenue, Marketing, Demand Planning and Supply Chain teams.
• Develop Power BI dashboards and management reports.
• Collaborate with Revenue and Demand Planning to translate forecasts into SKU-level demand.
• Coordinate with farms, procurement and warehouse teams to convert demand into supply requirements.
• Maintain product codes, SKU categories, and promotion codes for accurate measurement.
• Provide data and analysis to support business decisions across Revenue, Marketing, Demand Planning and Supply Chain.

Skills

Power BI

Excel

Data analysis

Data modelling

SQL

ERP knowledge

POS knowledge

Tools

ERP systems

POS systems

Job description

Senior Executive, Business Intelligence & Supply Chain Planning Analyst

To analyse customer, sales, SKU and inventory data and convert them into actionable insights for Revenue, Marketing, Demand Planning and Supply Chain teams. The role connects business demand, data structure and supply planning, helping the company improve sales performance, product availability and inventory management.

1. Business & Customer Analytics

Analyse customer purchases across in-store, online and other sales channels.

Analyse performance by customer, outlet, channel, product category and SKU.

Identify sales trends, customer behaviour, product opportunities and areas requiring action.

Develop Power BI dashboards and management reports.

2. Demand, Supply & Inventory Planning

Work with Revenue and Demand Planning teams to translate sales/marketing forecasts into SKU-level demand.

Work with farms, processing plants, procurement and warehouse teams to translate demand into supply requirements.

Monitor stock levels and identify potential OOS, overstock and slow-moving inventory.

Monitor forecast vs actual and highlight potential demand or supply gaps early.

3. System, Product Code & Data Structure

Work closely with MIS and Revenue teams to establish appropriate system and data structures for business analysis.

Set up and maintain product codes, SKU categories, product bundling codes, promotion codes and campaign codes.

Ensure promotions and product bundles are structured correctly in the system so their sales and customer response can be measured accurately.

Continuously improve data structures to enable effective Power BI analysis and management business reviews.

4. Business Planning Support

Provide data and analysis to support Revenue, Marketing, Demand Planning and Supply Chain decisions.

Measure effectiveness of new products, promotions, bundles and marketing campaigns.

Turn data findings into practical recommendations and follow-up actions.

About you

Strong Power BI, Excel and data analytical skills

Good understanding of data structure, SKU/product coding and data modelling

Strong numerical and logical-thinking ability

Able to understand both commercial and supply-chain requirements

Experience in Business Analytics, BI, Demand Planning, Retail/FMCG or Supply Chain preferred

SQL, ERP and POS system knowledge is an advantage