SAP BW BPC Team Lead

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

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.

Qualifications

• Mandatory: Bachelor's degree in Information Technology, Computer Science, Finance, Accounting, or a related field.
• Mandatory: 7+ years of hands-on experience in SAP Business Warehouse (BW) and SAP Business Planning and Consolidation (BPC).
• Mandatory: Demonstrated expertise in SAP BW data modeling, data extraction (especially from ECC), query design, and performance tuning.
• Mandatory: Strong proficiency in SAP BPC for both Planning and Consolidation, including EPM reporting, business rules, and logic scripts.
• Mandatory: Familiarity with SAP HANA studio and its capabilities for HANA Modeler & BW Modeling.
• Mandatory: Excellent analytical, problem-solving, and debugging skills.
• Mandatory: Strong communication and interpersonal skills, with the ability to work collaboratively with both technical and non-technical stakeholders.
• Mandatory: Ability to manage multiple priorities and work effectively in a fast-paced environment.
• Mandatory: 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.
• Desirable: Familiarity with industries such as media, fashion, or talent representation.
• Desirable: Exposure to S4 Group Reporting and SAC Planning.

Skills & Attributes

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

Hiring Range

Hiring Range Minimum Compensation: $112,500
Hiring Range Maximum Compensation: $150,000