Commercial Data and Business Intelligence Manager

Employer Overview A global healthcare organization specializing in innovative, high-quality, and cost-effective healthcare solutions across international markets. The company combines scientific expertise, commercial excellence, and a strong commitment to quality to improve patient outcomes and healthcare delivery. About the Role The Data & BI Manager will consolidate commercial data from multiple sources into a single, reliable data model and transform it into actionable business insights. The role will focus on sales and stock analysis, data governance, automated reporting, and business intelligence, enabling management to make informed decisions and improve commercial performance. Key Responsibilities Build and maintain a consolidated commercial data model integrating sales, sell-out, stock, CRM activity, targets, promotional history, and external market data. Consolidate, validate, and reconcile data from multiple sources to ensure accuracy and consistency across business units and Finance. Manage master data, including customer, pharmacy, doctor, territory, region, SKU, brand, and channel definitions. Develop and maintain sell-in, sell-out, and stock (SISO) analysis by distributor, wholesaler, channel, and SKU. Monitor stock cover, overstock, out-of-stock risks, near-expiry exposure, and sales trends to support inventory and forecasting decisions. Establish standardized data requirements, formats, and reporting frequencies for external distribution partners. Analyze commercial performance by business unit, brand, SKU, channel, region, and key account, identifying trends, gaps, and improvement opportunities. Develop dashboards and performance analysis to support sales teams, district managers, business unit heads, and senior management. Prepare monthly business review reports, translate findings into actionable recommendations, and follow up on agreed actions. Automate data collection, validation, and reporting processes while maintaining data quality, governance, and clear documentation. Qualifications Bachelor's degree in Business Analytics, Statistics, Computer Science, Engineering, Economics, or a related field. 8–10 years of experience in commercial analytics, sales analytics, or trade analytics within pharmaceuticals, consumer health, or FMCG. Experience working in a distribution-driven business involving wholesalers, distributors, or retail chains. Proven experience building and managing sell-in, sell-out, and stock (SISO) models. Experience consolidating multiple data sources, mapping partner codes, establishing master data, and reconciling figures with Finance. Experience developing commercial performance analysis used by sales teams and business leaders. Strong analytical and problem-solving skills. Excellent attention to detail and data accuracy. Strong communication and presentation skills. Ability to translate complex analysis into clear business recommendations. Strong stakeholder management and collaboration skills. Proactive mindset with a focus on process improvement and ownership. Advanced SQL and strong data modelling capabilities. Advanced Power BI or an equivalent BI tool, including DAX or equivalent analytical modelling capabilities. Experience building automated data pipelines and integrating multiple data sources. Strong understanding of sales performance, distribution analytics, stock management, and commercial KPIs. Hands-on experience with BI platforms, database tools, and data preparation technologies. Familiarity with CRM and commercial data systems. Ability to work with complex datasets and establish a single source of truth. Ability to identify data gaps, investigate discrepancies, and improve underlying processes. Ability to work effectively with senior management, sales teams, Finance, Supply Chain, IT, and distribution partners. Willingness to visit distribution partners and the field when required. Ability to deliver practical solutions quickly and continuously improve them. Show more Show less