Business Analytics Coordinator

Pfizer, S.A. de C.V; Ciudad de México; Presencial; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A leading pharmaceutical company based in Ciudad de México seeks a candidate for the Sales Operations role. This position focuses on leveraging advanced analytics and data preparation to generate insights driving business objectives. Key responsibilities include analyzing data across multiple sources, developing sales forecasts, designing reports, and enhancing processes through automation. Candidates should have strong proficiency in BI tools, particularly Power BI, and excellent analytical and communication skills. Apply by December 19th, 2025.

Formación

• Advanced proficiency in Power BI or similar BI tools.
• Strong analytical and problem-solving skills to translate complex data.
• Experience with database management and data integration.

Responsabilidades

• Integrate and analyze data across business portfolios.
• Develop sales forecasts and present findings to leadership.
• Design and automate sales reports from retailers and wholesalers.
• Analyze inventory days and product movement.
• Oversee daily, weekly, and monthly sales closure reports.

Conocimientos

Advanced proficiency in Power BI

Strong analytical skills

Excellent collaboration

Data integration

Herramientas

Power BI

Excel

Descripción del empleo

We’re in relentless pursuit of breakthroughs that change patients’ lives. We innovate every day to make the world a healthier place.

To fully realize Pfizer’s purpose – Breakthroughs that change patients’ lives – we have established a clear set of expectations regarding “what” we need to achieve for patients and “how” we will go about achieving those goals.

Pfizer offers competitive compensation and benefits programs designed to meet the diverse needs of our colleagues.

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

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