Associate Business Intelligence Analyst - Supply Chain - IT - Corporate Office (Austin, MN)

Associate Business Intelligence Analyst - Supply Chain - IT

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.

Responsibilities:

Requirements gathering, designing, developing, and testing Supply Chain Management operational and transactional dashboards and reports using analytics tools including but not limited to: Oracle Transactional Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher). Perform issue resolution and maintenance for existing dashboards and reports. Focus on understanding the Supply Chain business processes to advance integrated solutions for operational reporting that improve business efficiency and accuracy.

The person in this position will:

• Work with Oracle Cloud Supply Chain team members to understand business processes to document and develop requirements for prioritized transactional and operational reporting use cases.
• Enhance and grow operational reporting capabilities surrounding the Order to Cash initiative.
• Troubleshoot issues with existing reports and work with the business to resolve, test, and migrate fixes to Production environment.
• Maintain and enhance existing reports based on business input and lead business through acceptance of changes and testing before migrating to Production environment.
• Manage project work for offshore development resources to carry out report development when necessary.
• Tune reports and data models when necessary.
• Typical development tasks would be done within analytics tools like Oracle Transactional Business Intelligence (OTBI), Oracle Business Intelligence Publisher (BI Publisher), or similar tools and may include:
• Creating solutions by researching Supply Chain and ERP data models that can fulfill the report requirements including analytics that can handle multiple data sets or sources of data.
• Creating dashboards and dashboard pages that have intelligent user interface design and flow for the business including good performance.
• Delivering data through automated processes.

Technical Competencies

• Reports and Dashboards: Enables effective decision-making by retrieving and aggregating data into a digestible format. Gather 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.
• 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.

Qualifications:

• Bachelor's degree or master's degree in management information systems, Computer Information Systems, Data Analytics, Physics, Statistics, Math, Engineering, Data Science, or related field.
• Excellent written and verbal communication skills.
• 3+ years of experience with reading and writing SQL.
• 3+ years of experience designing and developing within a business intelligence/reporting tool like OTBI (Oracle Transactional Business Intelligence), BI Publisher (Oracle Business Intelligence Publisher), OBIEE (Oracle Business Intelligence Enterprise Edition) / HDS, Tableau, or Microsoft Power BI.
• 3+ years of experience understanding and developing solutions for Supply Chain 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.
• 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:

• Prior experience with Oracle SQL including advanced functions like analytical functions
• Prior experience with business processes or core database tables within Oracle Cloud Supply Chain and Finance modules.
• Prior experience tuning SQL.

Location: Austin, MN Global Headquarters (preferred); Eden Prairie, MN (office location)

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 $74,300-$104,000 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.

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.