Endeavor

SAP BW BPC Team Lead

Endeavor

full-time

Posted on:

Location Type: Hybrid

Location: New York City • California • New York • United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $112,500 - $150,000 per year

Job Level

Senior

About the role

  • Design, develop, and maintain SAP BW data models (DSOs, Cubes, Composite Providers, etc.) and data flows (Extractors, Transformations, DTPs).
  • Perform data extraction (direct extraction & SAP Landscape Transformation (SLT)) from source system SAP ECC and ensure data quality and consistency.
  • Develop and optimize Analysis for Office queries.
  • Monitor and troubleshoot data loads, process chains, and system performance within BW.
  • Maintain BPC applications, dimensions, models, and business rules for planning, budgeting, forecasting, and financial consolidation.
  • Maintain input schedules, reports, and dashboards using EPM Add-in and Web Client functionalities.
  • Configure and optimize BPC Logic Scripts.
  • Provide expert support for BPC users and troubleshoot BPC-related issues.
  • Proactively identify and implement performance improvements for both SAP BW and SAP BPC environments.
  • Assist in system upgrades, patches, and migration efforts.
  • Manage User Access Reviews
  • Ensure audit readiness of the applications.
  • Partner with Finance, Accounting, and other business units to gather requirements, translate them into technical specifications, and deliver effective solutions.
  • Provide expert functional and technical support to end-users, resolving issues and ensuring smooth operation of systems.
  • Adhere to company policy in development, testing, and deployment.
  • Operational ownership of the BW & BPC systems ensuring availability and accuracy of financial reporting.
  • Lead initiatives within BW/BPC space.
  • Lead and provide technical guidance and mentorship to BW/BPC team members.
  • Provide thought leadership on technology trends, opportunities, and process optimization.

Requirements

  • 7+ years of hands-on experience in SAP Business Warehouse (BW) and SAP Business Planning and Consolidation (BPC).
  • Demonstrated expertise in SAP BW data modeling, data extraction (especially from ECC), query design, and performance tuning.
  • Strong proficiency in SAP BPC for both Planning and Consolidation, including EPM reporting, business rules, and logic scripts
  • Familiarity with SAP HANA studio and its capabilities for HANA Modeler & BW Modeling.
  • Excellent analytical, problem-solving, and debugging skills.
  • Strong communication and interpersonal skills, with the ability to work collaboratively with both technical and non-technical stakeholders.
  • Ability to manage multiple priorities and work effectively in a fast-paced environment.
  • Strong understanding of financial principles & processes in the areas of Consolidated Group Reporting and FP&A.
Benefits
  • Health care
  • Retirement
  • Vacation and other paid time off

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SAP BWSAP BPCdata modelingdata extractionquery designperformance tuningEPM reportingBPC Logic ScriptsSAP HANA studiofinancial reporting
Soft skills
analytical skillsproblem-solving skillsdebugging skillscommunication skillsinterpersonal skillscollaborationtime managementability to manage multiple prioritiesleadershipmentorship