Job Description: SAP BW BPC Team Lead
Location: New York / Los Angeles Reports to: VP SAP Technical Services
Company Overview:
WME Group is the global platform representing the world’s leading talent, intellectual property, and brands encompassing four flagship business units, each a market leader in its field.
WME : the preeminent global talent agency with over 125 years of legacy, representing artists, athletes, fashion designers, creators, and brands across books, media, film, music, theatre, sports, and more.
160over90 : a culturally connected full-service marketing and creative agency that partners with blue-chip brands to deliver activations, experiential events, PR, and content rooted in cultural insight and relevance.
IMG Licensing : global brand licensing leader managing the intellectual property of iconic brands, media franchises, events, and talent to maximize their market reach and value.
Pantheon Media Group : Emmy Award-winning non-scripted content and production powerhouse comprising labels renowned for live events, factual entertainment, documentaries, true crime, sports programming.
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
Hiring Range Maximum Compensation: $150,000
Hiring Range Minimum Compensation: $112,500
Per local requirements and in the interest of transparency, the hourly rate shown below reflects the prevalent current hiring range for this position. Hiring pay rates are based on a number of factors, including location and may vary depending on job-related qualifications, knowledge, skills and experience. The company strives to provide locally competitive rewards packages, which include base rate along with, as applicable, short- and long-term incentives, growth and developmental opportunities, and robust benefits, such as health care, retirement, vacation and other paid time off, and additional offerings.
Hiring Rate Minimum:
Hiring Rate Maximum: