Data Product Analyst Manufacturing and Maintenance

Role Overview: As a Data Product Analyst at Opella, you will be a part of the global Digital Data & Analytics team with a focus on enabling data-driven decision-making across the Manufacturing, Maintenance, EM (External Manufacturing), and Product Portfolio domains. Your responsibilities will include 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. You will act as a key liaison between business functions, data engineers, and architects to bridge business insights with enterprise data solutions. Key Responsibilities: - Seamlessly collaborate with Manufacturing, Maintenance, and Portfolio Business & Digital functional teams to understand business processes, data sources, and reporting requirements. - Manage multiple scope items simultaneously, accurately estimating efforts and setting priorities. - Design and implement semantic layers in Snowflake to integrate data from multiple SAP environments and other enterprise systems. - Develop ad-hoc reports in Snowflake/Power BI by consolidating data from various domain systems and third-party tools. - Build and maintain domain-specific dashboards using Power BI, focusing on KPIs and operational metrics. - Write clear functional and technical specifications for new datasets, collaborating closely with data engineers and architects. - Conduct System Integration Testing (SIT) and support User Acceptance Testing (UAT) to validate data flows, transformations, and dashboard outputs. - Support the deployment of data governance practices to ensure data quality, lineage, and compliance within the M&S domain. Required Skills & Qualifications: - Deep understanding of Manufacturing, Maintenance, External Manufacturing, and Product Portfolio business processes. - Familiarity with key Manufacturing, Maintenance, and Product Portfolio KPIs. - Proven experience in designing data models following best practices and understanding of ETL/ELT processes. - Strong functional and technical knowledge of SAP Manufacturing modules like SAP MM, SAP PP, SAP PM, and SAP PLM. - Experience with MES systems, preferably Tulip, and expertise in SAP Analytics/BW in manufacturing and supply chain. - Expert-level experience in developing interactive dashboards and reports in Power BI. - Proficient in querying and working with Snowflake for designing semantic layers. - Demonstrated ability to collaborate with data engineers and architects to translate business requirements into scalable data pipelines. - Experience in conducting system integration testing and supporting UAT for data and analytics solutions. About The Company: Opella is the self-care challenger with a pure and diverse portfolio in the OTC & VMS market globally. With a mission to bring health into people's hands by simplifying self-care, Opella boasts 100 loved brands, 11,000-strong global team, 13 best-in-class manufacturing sites, and 4 specialized science and innovation development centers. As a globally certified B Corp company, Opella is dedicated to healthier people and planet. Join Opella on its mission to make self-care simple and thrive in a bold, collaborative, and inclusive culture. Note: Additional details about the company are available at www.opella.com.,