Hormel Foods is looking to transform its Product Lifecycle Management (PLM) capabilities by enhancing visibility and automation for critical PLM processes, including product development, change management, and product data governance, through improved operational and transactional dashboards and reports.
Requirements
- 4+ years of experience with reading and writing SQL.
- 4+ years of experience designing and developing within a business intelligence/reporting tool like OTBI (Oracle Transactional Business Intelligence), BI Publisher, OBIEE (Oracle Business Intelligence Enterprise Edition), OAS (Oracle Analytics Server), or OAC (Oracle Analytics Cloud).
- 4+ years of experience understanding and developing solutions for Product Lifecycle Management business processes.
- Prior experience with Oracle SQL including advanced functions like analytical functions.
- Prior experience with Oracle Cloud PLM modules and their underlying data structures (e.g., Product Development, Product Hub, Innovation Management).
- Prior experience tuning SQL.
- Understanding of data governance and master data management (MDM) principles.
Responsibilities
- Gather requirements, design, develop and test Product Lifecycle Management (PLM) operational and transactional dashboards and reports using Oracle Cloud business intelligence tools - Oracle Transactional Business Intelligence (OTBI), Business Intelligence Publisher (BI Publisher) and SQL.
- Perform issue resolution and maintenance for existing dashboards and reports.
- Develop OTBI analyses and dashboards using PLM subject areas, with attention to performance, usability, and data accuracy.
- Create intuitive prompts, filters, and dashboard layouts that support PLM-related decision-making processes.
- Develop agents to schedule and deliver PLM analyses as needed.
- Build and tune BI Publisher data models using advanced SQL across Oracle PLM and ERP schemas.
- Develop and format reports that accurately reflect business requirements related to product data, changes, and development cycles.
Other
- The ideal candidate will have strong communication skills and the ability to collaborate across multiple levels of the organization.
- Applicants must not now, or at any time in the future, require employer sponsorship for a work visa.
- Applicants must be authorized to work in the United States for any employer.
- Experience leading meetings, groups of people, or overseeing processes to achieve established goals.
- Excellent organizational and time management skills.
