Manager, SAP Solutions Lead

ROLE SUMMARY

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/4

HANA and BW/4

HANA journey.

In order of importance, the primary responsibilities that are critical to the performance of this role:

• Lead end-to-end design, development, and deployment of SAP BW and BPC solutions supporting GMX and Finance domains.

• Data Ingestion: design and maintain data acquisition layers including Data Sources, , CDS-based extraction (ODQ framework), Info Packages, and Data Transfer Processes (DTPs); monitor and troubleshoot delta loads, error stacks, and process chains.

• Data Modeling: architect and build BW Info Providers 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

• Planning Functions: design and implement BPC planning functions, FOX formula scripts, configure input-ready queries and planning sequences to support Finance planning and consolidation cycles.

• BW Query Development: 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.

• Analysis for Office (AfO): 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.

• Troubleshooting: 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/4
  
  HANA and BW/4
  
  HANA 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, controlling areas) to ensure data integrity and consistency across BW reporting layers and BPC planning models.

• Support data validation and reconciliation between BW/BPC…