Pfizer

Business Analytics Coordinator

Mexico - Mexico City Full time

Objective
Play a pivotal role in supporting critical decision-making for the Commercial Clients business unit by leveraging advanced analytics, data preparation, data mining, and interactive dashboards (e.g., Power BI) to generate actionable insights and strategies that drive the achievement of business objectives.

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.

Other Job Details:

Last Date to Apply for Job: Dec 19th, 2025

EEO (Equal Employment Opportunity) & Employment Eligibility 

Pfizer is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, or disability.

Sales Operations & Admin