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
• 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
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.
Marketing and Market Research