Senior Manager, BI Modeling and Dashboard Design

Pfizer; Ciudad de México; Hybrid; MXN 1,200,000 - 2,100,000; Full time

Job summary

Pfizer is seeking a Senior Manager of BI Modeling & Dashboard Design in Mexico City, hybrid work. You will design, build, and govern scalable BI dashboards to enable commercial decision-making across GCA's Performance Analytics and Insights group.

You will own data modeling, standards, and data integrity while mentoring analysts and partnering with stakeholders. Travel up to 10% may be required to support enterprise analytics initiatives.

Qualifications

• Bachelor’s degree in analytics, information systems, engineering, statistics, business or related field.
• 7+ years in business intelligence, data visualization, or analytics delivery.
• Ownership of end-to-end dashboard development for operational or commercial decisions.
• Hands-on experience with Tableau/Power BI and lightweight analytical apps or reporting tools (Python/Streamlit or React).
• SQL skills for data extraction, transformation, validation.
• Experience integrating multiple data sources and structured datasets.
• Validation checks, reconciliation logic, and refresh monitoring experience.
• Excellent written and verbal English for engagement with U.S. stakeholders.

Responsibilities

• Design, build, and maintain dashboards to support recurring commercial reporting.
• Translate stakeholder needs into structured dashboard solutions with clear narratives.
• Own end-to-end dashboard development including data modeling and visualization.
• Develop and maintain SQL logic for data extraction, transformation and validation.
• Integrate data from Snowflake, files, APIs, and enterprise systems; ensure data pipelines.
• Define BI architecture standards and governance for dashboards and access control.
• Mentor analysts and align priorities with stakeholders to meet timelines.
• Collaborate across cross-functional teams to drive analytics initiatives.

Skills

Tableau

Power BI

SQL

Python/Streamlit

React

Education

Bachelor's degree in analytics or related field

Master’s degree in analytics or related field

Tools

Snowflake

Streamlit

React

Job description

Work Location Assignment: Mexico City, must be able to work from assigned Pfizer office 2-3 days per week, or as needed by the business

The Senior Manager, BI Modeling & Dashboard Design transforms data into actionable insights by designing, building, and governing scalable business intelligence dashboards that establish durable internal analytics capability. This role owns BI modeling decisions, visualization standards, data integrity, and stakeholder adoption across recurring commercial performance reporting. The role operates within Performance Analytics and Insights (PAI), part of Global Commercial Analytics (GCA), supporting commercial decision-making through robust, executive-ready analytics solutions.

Role Responsibilities

Dashboard Design & Development - Design, build, and maintain dashboards using Tableau and/or Power BI to support recurring commercial performance reporting. Translate ambiguous stakeholder needs into structured dashboard solutions and clear visual narratives. Own end-to-end dashboard development including data modeling, calculated logic, and visualization design. Ensure dashboards are intuitive, executive-ready, and focused on driving decisions rather than displaying data.

Data Integration & ETL - Develop and maintain SQL logic for data extraction, transformation, and validation. Integrate multiple data sources including cloud data warehouses (e.g., Snowflake), flat files, enterprise systems, and APIs. Partner with data engineering or platform teams to support reliable data pipelines and refresh processes. Implement validation checks, reconciliation logic, and refresh monitoring.

Governance, Standards & Quality - Define and enforce BI architecture and visualization standards. Establish governance practices for dashboard access, versioning, and documentation. Stabilize existing reporting dashboards and maintain their sustainability. Ensure dashboards meet performance, scalability, reliability, and long-term maintainability expectations.

Leadership & Collaboration - Act as the technical and architectural point of contact for BI and dashboarding within PAI. Advise and mentor supporting analysts and reporting staff on BI best practices and standards. Partner with PAI analytics colleagues and business stakeholders to prioritize work and manage delivery timelines. Balance competing reporting demands while maintaining quality, governance, and architectural integrity.

Work Location Assignment: Hybrid

Basic Qualifications

• Bachelor’s degree in analytics, information systems, engineering, statistics, business, or related quantitative field
• 7+ years of experience in business intelligence, data visualization, or analytics delivery
• Demonstrated ownership of end-to-end dashboard development supporting operational or commercial decision-making
• Hands‑on experience developing dashboards in Tableau/Power BI and building lightweight analytical web applications or interactive reporting tools using Python-based frameworks (e.g., Streamlit) or component-based front-end technologies (e.g., React).
• SQL capability for data extraction, transformation, and validation
• Experience integrating multiple data sources and working with structured datasets
• Implementation of validation checks, reconciliation logic, and refresh monitoring
• Experience documenting metric logic and business rules
• Familiarity with access control, versioning, and auditability within BI platforms
• Professional written and verbal English suitable for direct engagement with U.S. business stakeholders and senior leaders
• Ability to explain data logic, assumptions, and insights in clear business language
• Confidence presenting dashboards and recommendations in working sessions or leadership reviews
• Experience working on cross-functional teams pursuing multifaceted analytics initiatives

Preferred Qualifications

• Master’s degree in analytics, information systems, engineering, statistics, business, or related quantitative field
• Advanced Tableau and/or Power BI capabilities including data modeling, calculated fields, DAX or equivalent logic, and performance optimization
• Hands‑on experience deploying Streamlit applications or React-based dashboards to support internal analytics use cases, including integration with back-end data sources such as Snowflake or cloud APIs
• Understanding of semantic layers and scalable BI architecture
• Knowledge of performance tuning, incremental refresh strategies, and large-scale dataset handling
• Experience working with enterprise data platforms or cloud data warehouses (e.g., Snowflake)
• Exposure to ETL tooling, data pipelines, or workflow orchestration supporting BI use cases
• Familiarity querying and modeling data in Snowflake to support scalable BI and reporting layers
• Pharmaceutical, healthcare, or commercial analytics experience
• Understanding of sales, market access, patient journey, or field force KPIs
• Experience supporting global or U.S. commercial organizations from near-shore teams
• Establishment of visualization standards, documentation frameworks, and reusable templates
• Demonstrated delivery of efficiency gains, cost reduction, or decision-speed improvement through BI

Non-standard Work Schedule, Travel Or Environment Requirements

Up to 10% travel required for periodic meetings

Work Location Assignment: Hybrid

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.

To learn more about acceptable and prohibited uses of AI during the recruitment process, please review our candidate AI-use guidelines available on Pfizer Careers.

Marketing and Market Research