About this role
Staff BI Analyst focusing on Product Lifecycle Management (PLM) within Hormel Foods; responsible for PLM operational dashboards and reports using OTBI, BI Publisher, and SQL. Collaborates with Oracle PLM teams to enhance visibility and automation of PLM processes.
Key Responsibilities
- Collaborate with Oracle PLM team to gather requirements; Develop OTBI and BI Publisher analyses; Create PLM dashboards; Build data models with SQL across PLM/ERP; Schedule and deliver dashboards
Technical Overview
Technical scope includes OTBI, BI Publisher, OBIEE, OAS, OAC, SQL, and PLM data structures; builds dashboards and data models across PLM modules.
Ideal Candidate
The ideal candidate is a senior BI/PLM analytics professional with 4+ years of SQL and BI tool experience (OTBI, BI Publisher, OBIEE, OAS/OAC), plus deep PLM knowledge. They should be able to translate product lifecycle processes into robust PLM dashboards and drive data-driven decisions.
Must-Have Skills
Bachelor's degree in computer scienceMISor related area4+ years of experience with reading and writing SQL4+ years of experience designing and developing within OTBI (Oracle Transactional BI)BI PublisherOBIEE (Oracle BI Enterprise Edition)OAS (Oracle Analytics Server)or OAC (Oracle Analytics Cloud)4+ years of experience understanding and developing solutions for Product Lifecycle Management (PLM) business processesProven ability to gather detailed technical requirements to design and develop BI report solutions from beginning to endExperience leading meetingsgroups of peopleor overseeing processes to achieve established goalsExcellent organizational and time management skillsTested problem-solving and decision-making skillsA strong pattern of initiativeExcellent written and verbal communication skillsApplicants must not nowor at any time in the futurerequire employer sponsorship for a work visaApplicants must be authorized to work in the United States for any employer
Nice-to-Have Skills
Prior experience with Oracle SQL including advanced functionsPrior experience with Oracle Cloud PLM modules (e.g.Product DevelopmentProduct HubInnovation Management)Prior experience tuning SQLUnderstanding of data governance and MDM principles
Required Skills
Bachelor's degree in computer scienceMISor related area; 4+ years SQL; 4+ years OTBI/BI Publisher/OBIEE/OAS/OAC; 4+ years PLM processes; requirements gathering; leadership; communication; visa sponsorship not offered; U.S. work authorization
Hard Skills
Oracle Transactional Business Intelligence (OTBI)OTBIBI PublisherBI PublisherOBIEE (Oracle Business Intelligence Enterprise Edition)OBIEEOracle Analytics Server (OAS)Oracle Analytics Cloud (OAC)SQLPLM data structuresPLM dashboardsPLM subject areasOracle PLMPLM
Soft Skills
Strong communicationCollaborationStakeholder managementRequirements gatheringTime managementAnalytical thinking
Keywords for Your Resume
staff bi analystplmproduct lifecycle managementotbibi publisherobieeoasoacsqloracle plmplm dashboardsplm data structuresplm subject areasoracle cloud plmdata queriesdata modelingsupply chainprocess improvementreportinganalyticsoracle transaction BI
Deal Breakers
Must be authorized to work in the United States for any employer, Must not require sponsorship
Get matched to jobs like this
Luna finds roles that fit your skills and career goals — no endless scrolling required.
Create a Free Profile