Senior Manager, BI Modeling and Dashboard Design

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

ROLE SUMMARY

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.

BASIC QUALIFICATIONS

Bachelors 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

Masters 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

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.