SAP BW BPC Team Lead

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 in