Business Intelligence Analyst

• Sales Data Consolidation & Reporting

1. Consolidate and validate sales data from multiple sources, including CRM, ERP systems, distributor reports, and customer sales reports etc.

2. Ensure the accuracy, completeness, and consistency of sales data across customers, products, regions, and channels.

3. Maintain customer and product master data, including account hierarchies and SKU mappings.

4. Prepare and distribute recurring sales reports, dashboards, and scorecards in a timely manner.

5. Support reporting automation and process standardization initiatives to improve efficiency.

• Customer & SKU Performance Analysis

1. Perform monthly sales performance analysis by customer, product category, brand, SKU.

2. Analyze sales trends, customer purchasing patterns, and product performance.

3. Identify growth opportunities, business risks, and underperforming customers or SKUs.

4. Monitor product portfolio performance and provide recommendations on product mix optimization.

5. Support customer business reviews and commercial discussions through data-driven insights.

6. Conduct ad hoc analysis to support business priorities and management requests.

• Sales Reporting & Business Analytics

1. Develop and maintain sales dashboards and performance reports.

2. Track and analyze key business metrics, including sales revenue, sales volume, average selling price (ASP), customer contribution, product mix, SKU productivity, sales growth trends and forecast versus actual performance

3. Generate weekly, monthly, quarterly, and annual business review materials.

4. Present analytical findings and recommendations to sales and commercial stakeholders.

• Forecasting & Sales Planning Support

1. Support sales forecasting and demand planning processes.

2. Monitor forecast accuracy and sales performance against targets.

3. Analyze forecast variances and identify trends impacting business performance.

4. Assist in sales target setting, territory analysis, and performance tracking.

5. Support annual operating planning activities through data analysis and reporting.

• Process Improvement & Commercial Support

1. Identify opportunities to improve reporting processes, analytical tools, and data management practices.

2. Support commercial projects, pricing analyses, promotional effectiveness reviews, and business cases.

3. Assist in documenting and standardizing sales processes and reporting methodologies.

4. Collaborate with cross-functions including CO, Finance, Marketing, RAQA, Supply Chain, and Customer Service

Knowledge, Skills and Abilities:

• Knowledge of CRM systems such as Salesforce
• Familiarity with ERP systems (SAP, Oracle, Microsoft Dynamics, etc.) is preferred.
• Strong data visualization and reporting capabilities.
• High attention to detail and data accuracy
• Ability to translate data into actionable business insights
• Ability to manage multiple priorities and deadlines
• Excellent communication and collaboration skills
• Strong analytical and exceptional problem-solving skills
• Strong capacity for continuous learning, enabling the ongoing updating of product knowledge as well as the company's processes and policies.

Work Environment:

• Office based working environment
• Capable of working independently

Experience:

• 5 years of experience in Sales Operations, Business Analytics, Commercial Analytics, Financial Analysis, or a related analytical role.
• Experience in sales reporting, data consolidation, and business analysis preferred.
• Experience working with large datasets and multiple reporting systems.

• Experience with Power BI, Tableau, or other business intelligence tools.

Education:

• Bachelor's degree in Business Administration, Finance, Economics, Statistics, Data Analytics, Marketing, or a related field.