Business Intelligence Analyst

• Sales Data Consolidation & Reporting
• Consolidate and validate sales data from multiple sources, including CRM, ERP systems, distributor reports, and customer sales reports etc.
• Ensure the accuracy, completeness, and consistency of sales data across customers, products, regions, and channels.
• Maintain customer and product master data, including account hierarchies and SKU mappings.
• Prepare and distribute recurring sales reports, dashboards, and scorecards in a timely manner.
• Support reporting automation and process standardization initiatives to improve efficiency.
• Customer & SKU Performance Analysis
• Perform monthly sales performance analysis by customer, product category, brand, SKU.
• Analyze sales trends, customer purchasing patterns, and product performance.
• Identify growth opportunities, business risks, and underperforming customers or SKUs.
• Monitor product portfolio performance and provide recommendations on product mix optimization.
• Support customer business reviews and commercial discussions through data-driven insights.
• Conduct ad hoc analysis to support business priorities and management requests.
• Sales Reporting & Business Analytics
• Develop and maintain sales dashboards and performance reports.
• 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
• Generate weekly, monthly, quarterly, and annual business review materials.
• Present analytical findings and recommendations to sales and commercial stakeholders.
• Forecasting & Sales Planning Support
• Support sales forecasting and demand planning processes.
• Monitor forecast accuracy and sales performance against targets.
• Analyze forecast variances and identify trends impacting business performance.
• Assist in sales target setting, territory analysis, and performance tracking.
• Support annual operating planning activities through data analysis and reporting.
• Process Improvement & Commercial Support
• Identify opportunities to improve reporting processes, analytical tools, and data management practices.
• Support commercial projects, pricing analyses, promotional effectiveness reviews, and business cases.
• Assist in documenting and standardizing sales processes and reporting methodologies.
• 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.