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 worlds 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

Bachelors degree in Information Technology Computer Science Finance Accounting or a related field.

Desirable

SAP Certification in relevant areas.

Advanced degree (e.g. MBA or Masters 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: $150000

Hiring Range Minimum Compensation: $112500

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: