SAP BW BPC Team Lead

This is a Full Time Job

Beverly Hills - 9601 Wilshire

Job Description: SAP BW BPC Team Lead

Location: New York / Los Angeles Reports to: VP SAP Technical Services

Position Summary: WME Group is seeking a highly skilled and experienced SAP BW & BPC Team Lead to join our dynamic team. This role is responsible for the ongoing support, enhancement, and performance of our SAP Business Warehouse (BW) and SAP Business Planning and Consolidation (BPC) solutions.

Combining deep technical proficiency, strong functional understanding and financial literacy, you will play a critical role in optimizing data warehousing, reporting, planning, and financial consolidation processes. You will ensure data integrity, system reliability, and the delivery of timely and accurate financial insights to key business stakeholders.

This is a hands-on leadership position, managing a team of two, where you will guide and mentor team members, promote best practices, and collaborate effectively with both IT and Finance. The role involves close coordination with other SAP technical and functional teams and reports directly to the VP, SAP Technical Services.

Key Responsibilities

SAP BW Development & Support:

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.

SAP BPC Development & Support:
• 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.

System Optimization & Performance:
• 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

Collaboration & User Support:
• 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.

Leadership & Mentorship:
• 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.

Knowledge & Experience

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

Desirable
• Knowledge of SAP ECC and SAP FI/CO configuration.
• Familiarity with industries such as media, fashion, or talent representation.
• Exposure to S4 Group Reporting and SAC Planning

Qualifications

Mandatory
• Bachelor's degree in Information Technology, Computer Science, Finance, Accounting, or a related field.

Desirable
• SAP Certification in relevant areas.
• Advanced degree (e.g. MBA or Master's in a technology-related field) is a plus.

Skills & Attributes

Mandatory
• Strong communication and interpersonal skills with a consultative approach.
• Strategic mindset with the ability to execute hands-on tasks.
• Keen prioritization skills focusing on overall delivery even under conflicting current needs pressures.
• Ability to synthesize complex ideas into practical solutions.
• Detail oriented