Sap Bw Architect Jobs (NOW HIRING)

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/4HANA and BW/4HANA journey.
ROLE RESPONSIBILITIES
In order of importance, the primary responsibilities that are critical to the performance of this role:
1. SAP BW Solution Design, Development & Delivery

• 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 DataSources, , CDS-based extraction (ODQ framework), InfoPackages, and Data Transfer Processes (DTPs); monitor and troubleshoot delta loads, error stacks, and process chains.

• Data Modeling: 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

• 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/4HANA and BW/4HANA migration roadmap, maintaining data architecture integrity throughout transitions.

2. SAP S/4 SD & Finance Functional Expertise

• 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 outputs and source S/4HANA systems, particularly for pricing, costing, and GL balances.

3. Stakeholder Collaboration

• 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.

4. Delivery Oversight & Governance

• 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.

5. Communication & Escalation

• • 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.

QUALIFICATIONS
BASIC QUALIFICATIONS

• 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.

PREFERRED QUALIFICATIONS

• 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.

ORGANIZATIONAL RELATIONSHIPS
This role regularly interacts with the following groups:

• Enterprise Solutions Insights (ESI) Team and GMX Team colleagues

• Pfizer Finance teams (Commercial Finance, FP&A, Corporate Finance)

• Global markup Exchange (GMX) business leads

• SAP S/4HANA and ERP platform teams

• SAP and strategic vendor partners

• Cross-digital portfolio and Digital Creation Center teams
• Internal audit and compliance teams (as applicable)

PHYSICAL/MENTAL REQUIREMENTS
N/A
NON-STANDARD WORK SCHEDULE, TRAVEL OR ENVIRONMENT REQUIREMENTS

• Possible night and weekend work during project/program deployments.
• Ability to travel up to 10% of time as required

OTHER JOB DETAILS:

• Last Day to Apply: August 12, 2026
• Work Location Assignment: Hybrid, 2-3 days onsite/week, any US Digital Pfizer site (Pfizer LIFYD)
• Eligible for employee referral bonus

The annual base salary for this position ranges from $99,200.00 to $165,400.00.* In addition, this position is eligible for participation in Pfizer's Global Performance Plan with a bonus target of 12.5% of the base salary and eligibility to participate in our share based long term incentive program. We offer comprehensive and generous benefits and programs to help our colleagues lead healthy lives and to support each of life's moments. Benefits offered include a 401(k) plan with Pfizer Matching Contributions and an additional Pfizer Retirement Savings Contribution, paid vacation, holiday and personal days, paid caregiver/parental and medical leave, and health benefits to include medical, prescription drug, dental and vision coverage. Learn more at Pfizer Candidate Site - U.S. Benefits | (uscandidates.mypfizerbenefits.com). Pfizer compensation structures and benefit packages are aligned based on the location of hire. The United States salary range provided does not apply to Tampa, FL or any location outside of the United States.* The annual base salary for this position in Tampa, FL ranges from $89,400.00 to $149,000.00.This role is posted in multiple locations. If you are applying for the role in an secondary job posting location where pay transparency regulations apply, your Talent Advisor will share the local pay information with you during the first interview.
Relocation assistance may be available based on business needs and/or eligibility.
Candidates must be authorized to be employed in the U.S. by any employer.
U.S. work visa sponsorship (such as TN, O-1, H-1B, etc.) is not available for this role now or in the future.
Sunshine Act
Pfizer reports payments and other transfers of value to health care providers as required by federal and state transparency laws and implementing regulations. These laws and regulations require Pfizer to provide government agencies with information such as a health care provider's name, address and the type of payments or other value received, generally for public disclosure. Subject to further legal review and statutory or regulatory clarification, which Pfizer intends to pursue, reimbursement of recruiting expenses for licensed physicians may constitute a reportable transfer of value under the federal transparency law commonly known as the Sunshine Act. Therefore, if you are a licensed physician who incurs recruiting expenses as a result of interviewing with Pfizer that we pay or reimburse, your name, address and the amount of payments made currently will be reported to the government. If you have questions regarding this matter, please do not hesitate to contact your Talent Acquisition representative.
EEO & 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, disability or veteran status. Pfizer also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as work authorization and employment eligibility verification requirements of the Immigration and Nationality Act and IRCA. Pfizer is an E-Verify employer. This position requires permanent work authorization in the United States.
Pfizer endeavors to make www.pfizer.com/careers accessible to all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process and/or interviewing, please email disabilityrecruitment@pfizer.com. This is to be used solely for accommodation requests with respect to the accessibility of our website, online application process and/or