Data Product Analyst Manufacturing and Maintenance

Job title: Data Product Analyst Manufacturing and Maintenance

• Location: Hyderabad

About Us

Opella, formerly the Consumer Healthcare business unit of Sanofi, , is the purest and third-largest player globally in the over-the-counter (OTC) & Vitamins, Minerals & Supplements (VMS) market.   

We have an unshakable belief in the power of self-care and the role it can play in creating a healthier society and a healthier planet. 

That’s why we want to make self-care as simple as it should be by being consumer-led always, with science at our core.  

Through our unique and balanced portfolio of more than 100 loved brands, including 15 global and local high-growth challengers such as Allegra, Dulcolax, and Buscopan, we deliver our mission: helping more than half a billion consumers worldwide take their health in their hands. 

 This mission is brought to life by an 11,000-strong team, 13 best-in-class manufacturing sites, and 4 specialized science and innovation development centers.  

We are also proud to be the first major fast-moving consumer healthcare company to achieve B Corp certification.  

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

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.

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

www.opella.com/en/careers