Key Responsibilities
- Integrate and analyze data from multiple sources across all business portfolios, including executive management, sales management, and key account managers (KAMs), using business intelligence platforms.
- Develop sales forecasts for Operating Plans and Latest Estimates (LE), presenting findings to category leads, finance, and executive leadership. Forecasts must cover all products and SKUs within the private channel.
- Design and automate Sell Out and Sell Thru reports sourced from retailers and wholesalers, ensuring data accuracy and timely delivery.
- Analyze inventory days and product movement, distributing dynamic dashboards and reports to Marketing, Finance, and Executive teams.
- Create and maintain Loss Opportunity reports, identifying out-of-stock Pfizer products and quantifying potential revenue impact.
- Oversee the generation of daily, weekly, and monthly sales closure reports by product and client, utilizing data visualization tools for enhanced clarity.
- Build and update historical sales databases, ensuring data integrity and accessibility for trend analysis.
- Coordinate the preparation of Returns and Rejections reports, as well as Fill Rate analyses, in collaboration with the Notes Management team.
- Monitor and calculate G2N (Gross-to-Net) investments within the Retail area, providing insights for optimization.
- Collaborate with Trade Marketing to align data-driven strategies and reporting.
- Track and coordinate territory assignments, quotas, and incentive programs for KAMs, working closely with the Incentives & Compensation (IC) team.
- Continuously improve reporting processes through automation, advanced analytics, and the adoption of new data mining tools.
Required Skills and Competencies
- Advanced proficiency in Power BI (or similar BI tools), Excel, and other data mining and visualization platforms.
- Strong analytical and problem-solving skills, with the ability to translate complex data into actionable business recommendations.
- Proactive and resilient, able to thrive in high-demand, fast-paced environments.
- Excellent collaboration and communication skills for building strong internal networks and presenting insights to diverse audiences.
- Demonstrated ability to manage stress and prioritize effectively under tight deadlines.
- Experience with database management, data integration, and process automation is highly desirable.
