Work Location Assignment: Mexico City, must be able to work from assigned Pfizer office 2-3 days per week, or as needed by the businessThe 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 ResponsibilitiesDashboard 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: HybridBasic QualificationsBachelor's degree in analytics, information systems, engineering, statistics, business, or related quantitative field7+ years of experience in business intelligence, data visualization, or analytics deliveryDemonstrated ownership of end-to-end dashboard development supporting operational or commercial decision-makingHands‐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 validationExperience integrating multiple data sources and working with structured datasetsImplementation of validation checks, reconciliation logic, and refresh monitoringExperience documenting metric logic and business rulesFamiliarity with access control, versioning, and auditability within BI platformsProfessional written and verbal English suitable for direct engagement with U.S. business stakeholders and senior leadersAbility to explain data logic, assumptions,



and insights in clear business languageConfidence presenting dashboards and recommendations in working sessions or leadership reviewsExperience working on cross-functional teams pursuing multifaceted analytics initiativesPreferred QualificationsMaster's degree in analytics, information systems, engineering, statistics, business, or related quantitative fieldAdvanced Tableau and/or Power BI capabilities including data modeling, calculated fields, DAX or equivalent logic, and performance optimizationHands‐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 APIsUnderstanding of semantic layers and scalable BI architectureKnowledge of performance tuning, incremental refresh strategies, and large-scale dataset handlingExperience working with enterprise data platforms or cloud data warehouses (e.G., Snowflake)Exposure to ETL tooling, data pipelines, or workflow orchestration supporting BI use casesFamiliarity querying and modeling data in Snowflake to support scalable BI and reporting layersPharmaceutical, healthcare, or commercial analytics experienceUnderstanding of sales, market access, patient journey, or field force KPIsExperience supporting general or U.S. commercial organizations from near-shore teamsEstablishment of visualization standards, documentation frameworks, and reusable templatesDemonstrated delivery of efficiency gains, cost reduction, or decision-speed improvement through BINon-standard Work Schedule, Travel Or Environment RequirementsUp to 10% travel required for periodic meetingsWork Location Assignment: HybridEEO (Equal Employment Opportunity) & Employment EligibilityPfizer 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-*****-Ljbffr

📌 Senior Manager, Bi Modeling And Dashboard Design (Xico)
🏢 Pfizer
📍 Xico