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 integral 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

#J-18808-Ljbffr

📌 Senior Manager, BI Modeling and Dashboard Design (Ciudad de México)
🏢 Pfizer
📍 Ciudad de México