SAP Analytics Finance and SD expert

Job title

SAP Analytics Finance and SD expert

Location

Hyderabad

Opella is the self-care challenger with the purest and third-largest portfolio in the Over-The-Counter (OTC) & Vitamins, Minerals & Supplements (VMS) market globally.

Our mission is to bring health in people’s hands by making self-care as simple as it should be. For half a billion consumers worldwide – and counting.

At the core of this mission is our 100 loved brands, our 11,000-strong global team, our 13 best-in-class manufacturing sites and 4 specialized science and innovation development centers. Headquartered in France, Opella is the proud maker of many of the world’s most loved brands, including Allegra, Buscopan, Doliprane, Dulcolax, Enterogermina, Essentiale and Mucosolvan.

As a globally certified B Corp company, we are active players in the journey towards healthier people and planet. Find out more about our mission at www.opella.com.

Main responsibilities

Provide value to Opella by building and providing support for analytics solutions based on SAP Analytics products which include S/4HANA (Fiori), BW4/HANA, Business Objects (Webi and Analysis for Office), BODS, SAP BDC, SAP Analytics Cloud; but also, with other tools like Power BI or Snowflake, and own communication to stakeholders.

Understand the business requirements for S/4 HANA reporting needs and collaborate to define the list of solutions that will be required to meet these requirements. Build, own and share decision tree to leverage right solution for a requirement with pros and cons. Organize and execute Knowledge transfer to implementation/ support partner on decision tree and norms/ standards.

Collaborate on designing and building analytics best practices, standards, norms. Support the development and delivery of reusable components that can be orchestrated together.

Collaborate closely with the ERP Analytics Lead on providing advice and implementing governance to manage projects and change requests, impacting SAP Analytics products and integrated components.

Be part of multidisciplinary technical teams on technical life cycle activities including upgrades with hosting providers and implementation partners. Establish partnership with functional architect teams and business.

As member of the ERP Analytics team, you will drive the implementation of partner activities in analytics design, development, testing and deployments. You will monitor implementation partners to ensure the quality of their deliverables and there are following rules agreed and SLAs.

Own expertise and apply to bring value and innovation on S/4HANA Analytics, BW4/HANA, Business Objects (Webi and Analysis for Office), Power BI, SQL and BODS. Desired knowledge on SAP BDC services, including Datasphere, SAC and SAP Databricks.

About you

Experience

7+ years of Analytics and reporting technologies working on Global projects, preferably in a FMCG and/or FMCH context.

Strong experience and understanding of Data architecture, analytical solutions that include SAP and non-SAP solutions (Power BI and Snowflake). Nice to have experience on SAP BDC services (Datasphere, SAC and Databricks).

Deep knowledge of organizational processes, data and associated applications. Strong knowledge of Analytics solutions, tools and processes; collecting data from multiple systems on-premises and cloud-based.

Strong knowledge in Advanced analytics topics including predictive and prescriptive analytics.

Good experience in Embedded Analytics, SAP BW4/HANA and other Data warehouse platforms. In particular will be required the following skills

LSA++ Architecture: Understanding the Layered Scalable Architecture to build lean, high-performance data models.

Embedded Analytics

Using CDS (Core Data Services) Views to push logic down to the database level, allowing for real-time Fiori dashboards.

SQL coding

Ability to create SQL queries and procedures in technologies like Snowflake.

Knowledge of working in SAP functional areas (specifically focused on SAP Finance, Controlling and Sales and Distribution modules) and experience being participated in projects with global scope. Provide proved knowledge and experience in the following

Finance and Controlling

Core S/4HANA Finance & Controlling mastery, which means deep knowledge and understanding of Universal Journal (ACDOCA). Including

Financial Accounting (FI): Deep knowledge of General Ledger, Accounts Payable/Receivable, and Asset Accounting. You must understand how multi-currency and multi-ledger environments work for global reporting.

Controlling (CO): Functional knowledge of controlling processes.

Margin Analysis: Proficiency in account-based CO-PA (Profitability Analysis) to evaluate market segments, brands, or customer groups in real-time.

Industry-Specific Domain Knowledge: Consumer Health

Gross-to-Net (GTN) Accounting: Understanding the journey from gross sales to net revenue, including rebates, returns, and trade spend.

Inventory & Valuation

Managing its financial impact and its effect on balance sheets.

Sales and Distribution

Core S/4HANA Sales and Distribution mastery, which means deep knowledge and understanding the integration between the promotion commercial processes, sales and billing processes

OTIF (On-Time In-Full) Modeling

Outbound Delivery Performance

Analyzing the timestamps in the LIKP and LIPS tables to measure "Pick-to-Ship" cycle times.

Gross-to-Net (GTN) Modeling: Understand the processes and the models to be able to model the bridge from Gross Sales through Trade Promotions, Rebates, and Returns to reach Net Sales

Returns & Refusals

Understand how to track and analyze return reasons.

Pricing & Rebate Analytics

Deep understanding of the Condition Technique.

Sales Reporting: Building complex multi-level hierarchies (Global > Region > Country > Sales Territory) to compare performance against targets.

Experience of SAP analytics full lifecycle implementation projects.

Experience with multi-g