Hybrid SAP BW BPC Team Lead

at Endeavor

• Job title: SAP BW BPC Team Lead
• Job type: Full Time
• Experience level: Senior
• Salary: $112,500 - $150,000 per year
• Degree requirement: Bachelor's Degree
• Location requirements: Hybrid, Beverly Hills, United States

About the role

• SAP BW BPC Team Lead at WME Group overseeing SAP data solutions and leading a team. Ensuring data integrity, system reliability, and delivering financial insights with SAP BW and BPC.

Responsibilities

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

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.
• Bachelor's degree in Information Technology, Computer Science, Finance, Accounting, or a related field.
• SAP Certification in relevant areas is a plus.
• Advanced degree (e.g. MBA or Master's in a technology-related field) is a plus.

Benefits

• health care
• retirement
• vacation and other paid time off
• additional offerings