Manager, SAP Solutions Lead

Pfizer • New York City, NY

2d • Hybrid

About The Position

Every day at Pfizer, we are dedicated to delivering top-notch, safe, and effective products to those who need them the most. In the Digital division, our commitment is reinforced by a science-driven, risk-aware quality culture, extending a passionate endeavor to improve patients’ lives. The Manager, SAP GMX Solution Lead will be a key technical and functional leader within the Enterprise Solutions Insights (ESI), responsible for designing, developing, and delivering SAP Business Warehouse (BW) and SAP Business Planning & Consolidation (BPC) solutions that support Global Markup Exchange (GMX) and Finance functions. This role is the primary SAP subject matter expertise in Mark up exchange domain knowledge with analytical platforms. The ideal candidate brings deep hands-on BW and BPC expertise combined with a strong understanding of SAP SD and Finance functional processes. They will partner closely with Finance, and Digital stakeholders to translate complex business requirements into scalable, high-quality analytical solutions. This role will also play a critical part in Pfizer’s SAP platform modernization, ensuring that BW data architecture integrity is maintained as the organization advances its S/4HANA and BW/4HANA journey.

Requirements

• Bachelor's or Master's degree in Information Systems, Computer Science, Finance, or a related field
• 4+ years of hands-on SAP BW development experience across the full delivery lifecycle; or a Master's degree with 2+ years of experience; or a PhD with equivalent experience, including:
• Data Ingestion: DataSources, ODQ, InfoPackages, DTPs, process chains, and delta load management.
• Data Modeling: Advanced DSOs, Composite Providers, Open ODS Views, Analytic Indexes, and ABAP transformation routines (start, end, expert routines).
• BW Query Development: BEx Query Designer or BW Modeling Tools, calculated/restricted key figures, variables (replacement path, customer exit, SAP exit), exceptions, and conditions.
• Analysis for Office (AfO): building and maintaining AfO workbooks and input-ready planning templates for end-users.
• Planning Functions: BPC planning functions, FOX formula scripts, data manager packages, planning sequences, and input schedules.
• In depth ABAP programming knowledge
• Troubleshooting: end-to-end issue diagnosis across extraction, transformation, loading, query performance, and BPC planning inconsistencies.
• Demonstrated experience with SAP BPC (Standard or Embedded) including planning model configuration, logic scripts/FOX formulas, input schedules, and consolidation processes.
• Functional knowledge of SAP S/4HANA Sales & Distribution (SD): pricing condition technique (condition types, condition tables, access sequences, pricing procedures, condition records).
• Working knowledge of SAP Material Master data concepts: material types, plant and sales organization views, valuation class, pricing-relevant fields, classification/characteristics, and their relevance to BW extraction and reporting.
• Finance domain knowledge in Product Costing (CO-PC): standard cost estimates, cost component structures, material ledger/actual costing, and variance analysis; and General Ledger (FI-GL): G/L account master data, document types, posting keys, and period-end closing processes.
• Understanding of Finance master data governance: company codes, controlling areas, cost centers, profit centers, and G/L account master data structures.
• Exceptional verbal, written communication, and organizational skills, with the ability to collaborate across diverse technical and business teams.
• Ability to work in a fast-paced, dynamic environment managing competing priorities.

Nice To Haves

• Master's degree
• SAP BW/4HANA experience: ABAP CDS-based extraction, Open ODS Views, Composite Providers, and HANA-optimized models.
• SAP Analytics Cloud (SAC) Live Connection or import models built on BW/4HANA or BPC Embedded.
• Knowledge of SAP SD (pricing procedure setup, condition type configuration, Material Master maintenance) in a production S/4HANA environment.
• Experience with SAP CO-PC (product cost planning, actual costing/material ledger) and FI-GL in an S/4HANA context, including universal journal (ACDOCA) reporting.
• SAP certification in BW, BPC, or SAP Analytics Cloud (SAC).
• Experience with SAP Analytics Cloud (SAC) or SAP BOBJ tools
• Experience in a pharmaceutical, life sciences, or regulated industry.
• PMP certification or equivalent project management credential.
• Familiarity with Agile methodologies and experience working within large enterprise SAP landscapes.

Responsibilities

• Lead end-to-end design, development, and deployment of SAP BW and BPC solutions supporting GMX and Finance domains.
• Design and maintain data acquisition layers including DataSources, CDS-based extraction (ODQ framework), InfoPackages, and Data Transfer Processes (DTPs); monitor and troubleshoot delta loads, error stacks, and process chains.
• Architect and build BW InfoProviders including Advanced DSOs, Composite Providers, Open ODS Views, design transformation logic (start routines, end routines, expert routines in ABAP) to meet complex mapping requirements.
• Create/Maintain ABAP Programs and troubleshoot ABAP programs.
• Design and implement BPC planning functions, FOX formula scripts, configure input-ready queries and planning sequences to support Finance planning and consolidation cycles.
• Create, maintain, and optimize BEx queries and Analysis for Office (AfO) workbooks, including calculated key figures, restricted key figures, variables, exceptions, and conditions; ensure query performance through partitioning strategies.
• Build and maintain AfO-based reporting and planning templates for end-users; train and support users on AfO refresh, navigation, and input-ready planning functionality.
• Diagnose and resolve BW issues across the full stack — extraction failures, transformation errors, query performance degradation, process chain failures, and BPC planning inconsistencies; perform root-cause analysis and implement sustainable fixes.
• Ensure solution alignment with SAP S/4HANA and BW/4HANA migration roadmap, maintaining data architecture integrity throughout transitions.
• Apply knowledge of SAP SD condition types, condition tables, access sequences, pricing procedures, and condition records maintenance to ensure integration to GMX Solutions.
• Apply knowledge of SAP Material Master data — including material types, plant/sales organization views, valuation class, pricing-relevant fields, classification/characteristics, and MRP views — to ensure accurate integration to GMX solutions.
• Apply Finance domain expertise in Product Costing (CO-PC) — standard cost estimates, cost component splits, material ledger/actual costing — and General Ledger (FI-GL) — G/L account master data, document types, posting keys, and period-end processes — to shape GMX model design and data flows.
• Leverage knowledge of Finance master data (company codes, cost centers, profit centers, G/L account master) to ensure data integrity and consistency across BW reporting layers and BPC planning models.
• Support data validation and reconciliation between BW/BPC outputs and source S/4HANA systems, particularly for pricing, costing, and GL balances.
• Partner with GMX business leads, Finance partners, and Digital teams to gather, validate, and prioritize requirements.
• Represent the ESI team in cross-functional working sessions and governance forums involving Finance, and Digital stakeholders.
• Serve as the technical-to-business translator ensuring shared understanding and alignment between IT delivery teams and business partners.
• Apply SDLC methodologies to manage solution delivery from requirements through deployment and post-go-live support.
• Define and track delivery KPIs and OKRs to measure solution quality, adoption, and timeliness.
• Coordinate testing cycles (unit, integration, UAT) with business and technical teams; drive defect resolution.
• Contribute to code reviews and ensure adherence to development standards, naming conventions, and best practices.
• Contribute to and execute the ESI team communication strategy for GMX and Finance stakeholder groups.
• Participate in required demos and training sessions to drive adoption of delivered BW/BPC solutions.
• Escalate impactful technical risks and issues to the ESI Team Lead in a timely and structured manner.

Benefits

• 401(k) plan with Pfizer Matching Contributions
• additional Pfizer Retirement Savings Contribution
• paid vacation
• holiday and personal days
• paid caregiver/parental and medical leave
• health benefits to include medical, prescription drug, dental and vision coverage
• Relocation assistance may be available

What This Job Offers

• Job Type: Full-time
• Career Level: Manager