Data Engineer Supply Chain Planning - IT - Hormel Foods (Austin, MN)

DATA ENGINEER SUPPLY CHAIN PLANNING – IT - CORPORATE OFFICE (AUSTIN, 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 www.hormelfoods.com.

Summary:
We are looking for a Data Engineer specializing in supply chain planning within our Data and Analytics team.  This is an exciting opportunity to help grow and modernize analytics at Hormel Foods!  Individuals interested in this position will need strong communication skills, communicating up, down and across the organization.  You will be responsible for managing simultaneous initiatives that require innovative problem solving. 

 

You will use tools such as Google Cloud Platform, SQL, Python, Incorta, Oracle Business Intelligence, Tableau, and Informatica ETL to engineer data pipelines and data models to enhance enterprise reporting and analytics.  Additionally, you will engineer reports, dashboards and visualizations using enterprise business intelligence tools (Oracle and Tableau). 

 

Specific competencies include:

Data Structures and Models - Designs and develops the overall database/data warehouse structure based on functional and technical requirements.  Designs and develops data collection frameworks for structured and unstructured data.
 

Data Pipelines and ELT - Designs and applies data extraction, loading and transformation techniques in order to connect large data sets from a variety of sources.
 

Data Performance - Troubleshoots and fixes for data performance issues that come with querying and combining large volumes of data.  Adjusts performance for solution accordingly during initial development.
 

Visualizations and Dashboards - Gathers requirements, designs and develops reports and dashboards with multiple sources that meet business needs.  Leverages visualizations when possible to increase speed to identifying an insight.  Walks business through definitions of data.
 

Responsibilities:

• Works closely with Supply Chain Planning functions, data scientists, BI analysts, and other stakeholders to understand data needs and deliver solutions.
• Engineers physical and logical data models for dimensions and facts within the staging, warehouse and semantic layer of our enterprise data warehouses and platforms
• Engineers and performance tunes SQL, Python, Incorta or Informatica ETLs and pipelines as well as Google BigQuery Dataprocs to move data from a variety of source systems and file types to fit into dimensional data models
• Utilizes SQL within Google BigQuery, Informatica ETLs, Incorta pipelines or Oracle SQL Views when necessary to achieve proper metric calculations or derive dimension attributes
• Engineers schedule and orchestration for batch and mini-batch data loads into the enterprise data warehouses and platforms
• Provide issue resolution and maintenance for a variety of business unit solutions already existing in the enterprise data warehouses and platforms
• Use tools such as SQL, Oracle Business Intelligence, Tableau, Google Cloud Platform, Python, Incorta and Informatica ETL to engineer data pipelines and data models to enhance enterprise reporting and analytics
• Engineers dashboards within the enterprise business intelligence platforms containing reports and visualization that have intelligent user interface design and flow for the business including adequate performance

Required Qualifications:

• A bachelor's degree in Computer Science, MIS, or related area and signi