Data Product Analyst Manufacturing and Maintenance

Job title
:
Data Product Analyst Manufacturing and Maintenance

• Location: Hyderabad

About Us
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

About The Job
Role Overview:
The Data Product Analyst, part of the global Digital Data & Analytics team, is responsible for enabling data-driven decision-making across the Manufacturing, Maintenance, EM (External Manufacturing), and Product Portfolio domains. This role focuses on designing semantic layers in Snowflake, developing insights through Power BI dashboards (KPIs) and ad-hoc reporting, and ensuring the integrity and quality of data integration across multiple systems. The analyst will act as a key liaison between business functions, data engineers, and architects to bridge business insights with enterprise data solutions.

Key Responsibilities

• Stakeholder Engagement: Seamlessly collaborate with the Manufacturing, Maintenance and Portfolio Business & Digital functional teams to understand business processes, data sources, and reporting requirements.
• Scope management and prioritization: Manage multiple scope items simultaneously, being able to accurately estimate efforts and set the priorities.
• Semantic Layer Design: Design and implement semantic layers in Snowflake, integrating data from our multiple SAP environments and other enterprise systems (e.g. Kinaxis) to support scalable analytics solutions.
• Ad-Hoc Reporting: Develop ad-hoc reports in Snowflake/power BI by consolidating data from multiple domain systems including SAP (MM, PP, PM, PLM), MES, Kinaxis, etc., and third-party tools, ensuring accuracy and business relevance.
• Dashboard Development: Build and maintain domain-specific dashboards using Power BI, focusing on KPIs and operational metrics that drive continuous improvement in manufacturing and maintenance processes.
• Specifications & Documentation: Write clear functional and technical specifications for new datasets to be added to the data foundation, collaborating closely with data engineers and data architects.
• Testing & Validation: Conduct System Integration Testing (SIT) and support User Acceptance Testing (UAT) to validate data flows, transformations, and dashboard outputs for global solutions.
• Data Governance: Support the deployment of data governance practices, ensuring data quality, lineage, and compliance within the M&S domain.

Required Skills & Qualifications

• Business understanding: Deep understanding of Manufacturing, Maintenance, External Manufacturing, and Product Portfolio business processes — including demand planning, master production scheduling (MPS), material requirements planning (MRP), process order management, maintenance planning and execution, as well as portfolio planning, prioritization, and lifecycle management. Additionally, a solid understanding of various manufacturing models is essential, encompassing both internal and external manufacturing operations.
• Manufacturing, Maintenance, EM and Product Portfolio KPIs: Familiarity with key manufacturing, Maintenance and Product Portfolio KPIs.

• Data Architecture and Data Modeling: Proven experience in designing data models following best practices. Understanding of ETL/ELT processes and orchestration tools

• SAP functional and technical expertise: Strong functional and technical knowledge of SAP Manufacturing modules, including:

• SAP MM (Materials Management)

• SAP PP (Production Planning)
• SAP PM (Plant Maintenance)
• SAP PLM (Product Lifecycle Management)

• Understanding of SAP SD and SAP FICO is recommendable.

• Experience with MES systems, preferably Tulip (eBR and eOEE)

• SAP Analytics / SAP BW in manufacturing and supply chain expertise is strongly recommended.
• Power BI: Expert-level experience in developing interactive dashboards and reports in Power BI, with a deep understanding of DAX and data modeling.
• Snowflake: Proficient in querying and working with Snowflake, especially for designing semantic layers and integrating diverse data sources.
• Data Integration Collaboration: Demonstrated ability to work with data engineers and data architects to translate business requirements into scalable data pipelines and models.
• Testing & Quality Assurance: Experience conducting system integration testing (SIT) and supporting UAT for data and analytics solutions.

About You

• Education: Bachelor's or master's degree in business, Engineering, Computer Science, Data Science, or a related field.
• Experience: 10+ years in data and analytics for manufacturing and supply chain roles

Soft And Behavioral Skills

• Team Collaboration: Proven ability to work with multiple teams to drive alignment and results.
• Cultural Sensitivity: Experience working with multicultural, global teams.
• Service-Oriented: Flexible, positive team player with a strong service orientation.
• Communication: Excellent written and verbal communication skills.
• Initiative: Self-motivated, proactive, and takes initiative.
• Problem Solving: Strong problem-solving and critical thinking skills.

Why us?
At Opella, you will enjoy doing challenging, purposeful work, empowered to develop consumer brands with passion and creativity. This is your chance to grow new skills and be part of a bold, collaborative, and inclusive culture where people can thrive and be at their best every day.

We Are Challengers.
We Are Dedicated To Making Self-care As Simple As It Should Be. That Starts With Our Culture. We Are Challengers By Nature, And This Is How We Do Things

All In Together:
We keep each other honest and have each other's backs.

Courageous:
We break boundaries and take thoughtful risks with creativity.

Outcome-Obsessed:
We are personally accountable, driving sustainable impact and results with integrity.

Radically Simple:
We strive to make things simple for us and simple for consumers, as it should be.

Join us on our mission. Health. In your hands.