Systems analyst jobs in Rochester, MN

JobID: 31778 JobSchedule: Full time JobShift: Pay Ranges: $86,500-$121,200 STAFF BUSINESS INTELLIGENCE ANALYST - PLM (PRODUCT LIFE CYCLE) - (AUSTIN, MN OR EDEN PRAIRIE, MN) To save time applying, Hormel Foods does not offer sponsorship of job applicants for employment-based visas for this position at this time. Hormel Foods Corporation ABOUT HORMEL FOODS - Inspired People. Inspired Food. Hormel Foods Corporation, based in Austin, Minnesota, is a global branded food company with approximately $12 billion in annual revenue across more than 80 countries worldwide. Its brands include Planters, Skippy, SPAM, Hormel Natural Choice, Applegate, Justin's, Wholly, Hormel Black Label, Columbus, Jennie-O and more than 30 other beloved brands. The company is a member of the S&P 500 Index and the S&P 500 Dividend Aristocrats, was named one of the best companies to work for by U.S. News & World Report, one of America's most responsible companies by Newsweek, recognized by TIME magazine as one of the World's Best Companies, and has received numerous other awards and accolades for its corporate responsibility and community service efforts. The company lives by its purpose statement - Inspired People. Inspired Food. - to bring some of the world's most trusted and iconic brands to tables across the globe. For more information, visit ******************** Summary: We are looking for a Staff BI Analyst focused on Product Lifecyle Management (PLM) within the Operational Reporting function as part of our Data and Analytics team. This is an exciting opportunity to help transform PLM capabilities at Hormel Foods! The ideal candidate will have strong communication skills and the ability to collaborate across multiple levels of the organization. You will 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. This role will contribute directly to enhancing visibility and automation for critical PLM processes including product development, change management, and product data governance. Specific competencies include: * Reports and Dashboards: Enables effective decision-making by retrieving and aggregating data into a digestible format. Gathers requirements, designs, and develops reports and dashboards within business intelligence platforms for operational, transactional, or strategic data. Leverages interactive reporting components to build drill-through or ad-hoc reports. * Business Knowledge and Analysis: Establishes understanding of business processes and concepts in assigned areas to create reporting solutions that meet business' operational, transactional, or strategic analysis goals and objectives and communicating progress. * PLM Data Expertise: Understands the structure and flow of product data across Oracle Cloud PLM modules, including item master, bills of materials (BOMs), engineering change orders (ECOs), and product attributes. * Data Queries and Models: Deeply understands core tables within the data models available and connects data with queries on small to medium size data sets. Reads, writes, and analyzes queries in query language for analysis and report development purposes. * Data Performance and Automation: Achieves acceptable report solution performance through any means within the transactional, operational, or analytical systems. Takes into consideration automation for reducing human intervention through automated report delivery or process automation. Responsibilities: * Collaborate with Oracle PLM functional team members to understand product lifecycle business processes and gather reporting requirements. * Engage stakeholders through iterative development and reviews to ensure the reports meet business needs prior to production deployment. * Take ownership of PLM reporting initiatives, proactively identifying opportunities to improve visibility, data quality, and decision-making across the product lifecycle. * Troubleshoot and resolve issues with existing PLM-related reports, coordinating fixes with stakeholders and migrating validated changes to production. * Maintain and enhance existing Oracle PLM reports based on evolving business needs and ensure proper testing and user acceptance. * Manage project work for offshore or contract developers, ensuring alignment with business objectives and technical standards. * Typical development tasks include: * OTBI - Oracle Transactional Business Intelligence * 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. * BI Publisher * 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. * Configure bursting and scheduling options for automated or event-driven delivery of reports. * Optimize performance of PLM reporting solutions. Required Qualifications: * Bachelor's degree in computer science, MIS, or related area and consistent experience with business intelligence, data engineering and data modeling. * 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. * Proven ability to gather detailed technical requirements to design and develop business intelligence report solutions from beginning to end. * Experience leading meetings, groups of people, or overseeing processes to achieve established goals. * Excellent organizational and time management skills. * Tested problem-solving and decision-making skills. * A strong pattern of initiative. * Excellent written and verbal communication skills. * Highly developed interpersonal and leadership skills. * 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. Preferred Qualifications * 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.. LOCATION: Austin, MN - Global Headquarters (Preferred). Secondary location Eden Prairie, MN TRAVEL REQUIREMENTS: Travel may be necessary 10% of the time. BENEFITS: Hormel Foods offers an excellent benefits package. Competitive base salary plus target incentive, discretionary annual merit increase, annual performance review, medical, dental, vision, non-contributory pension, profit sharing, 401(k), stock purchase plan, paid personal time off (PTO), FREE two-year community or technical college tuition for children of employees, relocation assistance and more. On-the-job training, certifications and opportunities to expand skill sets. At Hormel Foods, base pay is one part of our total compensation package and is determined within a range. The base hiring pay range for this role is between $86,500-$121,200 per year, and your actual base pay within that range will depend upon a variety of factors including, but not limited to, job-related knowledge, skill set, level of experience, and geographic market location. At Hormel we invite difference and diversity in all aspects. We offer a space of support, understanding, and community. We are committed to the journey! Learn more about our progress here: ********************************************************** Hormel Foods provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.