Senior Commercial BI Analyst

Agensi Pekerjaan Penta Consultancy Sdn. Bhd; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Agensi Pekerjaan Penta Consultancy Sdn. Bhd is seeking a Senior Commercial BI Analyst to develop and maintain Power BI dashboards and KPI reports across sales, customer, inventory, and operational performance.

You will analyze sales trends, customer behavior, and market data to uncover opportunities, perform segmentation and churn analysis, and support forecasting and inventory planning. Collaboration with cross-functional teams and AI-driven reporting enhancements are expected.

Qualifications

• Bachelor's degree in a relevant field.
• Minimum 3 years in BI/Analytics.
• Experience in FMCG/retail/distribution preferred.
• Strong Excel, Power BI, SQL, and data visualization skills.
• Experience with Python or Copilot is a plus.

Responsibilities

• Develop and maintain Power BI dashboards and KPI reports to provide actionable insights.
• Analyze sales performance, customer behavior, and market trends to identify opportunities.
• Perform customer segmentation, churn analysis, and sales force productivity analysis.
• Support demand forecasting and inventory planning with sales trend data.
• Collaborate with sales, marketing, supply chain, and management for data-driven recommendations.
• Automate reporting processes using Power BI, Power Query, SQL, etc.
• Explore AI-driven solutions to enhance reporting and insights.
• Ensure data integrity, consistency, and governance across reports.

Skills

Excel

Data viz

Analytical thinking

Stakeholder engagement

Communication

Autonomous work

Education

Bachelor's degree in related field

Tools

Power BI

Power Query

SQL

Python

Microsoft Copilot

ChatGPT

ERP systems

Job description

About the job Senior Commercial BI Analyst

Job Responsibilities:

• Develop and maintain Power BI dashboards and KPI reports to provide actionable insights into sales, customer, inventory, and operational performance.
  
• Analyze sales performance, customer behavior, product profitability, and market trends to identify business opportunities and support strategic decision-making.
  
• Perform customer segmentation, churn analysis, and sales force productivity analysis to improve commercial effectiveness.
  
• Support demand forecasting and inventory planning by analyzing sales trends, stock movements, and forecast accuracy.
  
• Collaborate with sales, marketing, supply chain, and management teams to deliver data-driven recommendations and optimize business performance.
  
• Automate reporting processes using Power BI, Power Query, SQL, and other analytical tools to improve efficiency and data accuracy.
  
• Explore and implement AI-driven solutions using tools such as ChatGPT, Microsoft Copilot, and Power BI AI features to enhance reporting and business insights.
  
• Ensure data integrity, consistency, and governance across commercial reports, dashboards, and business intelligence solutions.

Job Requirements:

• Bachelor's Degree in Business Analytics, Data Science, Statistics, Economics, Finance, Engineering, Information Systems, or a related field.
  
• Minimum 3 years of experience in Business Intelligence, Commercial Analytics, or Data Analytics.
  
• Experience in FMCG, food manufacturing, retail, distribution, or consumer products is highly preferred.
  
• Strong proficiency in Microsoft Excel, Power BI, Power Query, SQL, and data visualization tools.
  
• Experience with Python, Power Automate, Microsoft Copilot, ChatGPT, or ERP systems will be an added advantage.
  
• Strong analytical, problem-solving, and critical thinking skills with the ability to translate data into actionable business recommendations.
  
• Excellent communication and presentation skills, with the ability to engage and influence stakeholders across different business functions.
  
• Self-motivated, commercially minded, and able to work independently in a fast-paced environment while managing multiple priorities.