Apply on Employer Site

Hormel Foods · 1 day ago

Data Engineer Supply Chain Planning

Austin, MN

Full-time

Onsite

Senior Level

$98K/yr - $137K/yr

5+ years exp

Hormel Foods Corporation, based in Austin, Minnesota, is a global branded food company. They are seeking a Data Engineer specializing in supply chain planning to join their Data and Analytics team, responsible for managing data pipelines and enhancing enterprise reporting and analytics.

Food ProcessingManufacturingMeat and Poultry

No H1B

U.S. Citizen Only

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

Qualification

SQLPythonData WarehousingETL DevelopmentGoogle Cloud PlatformInformatica ETLTableauData ModelingCommunication SkillsProblem-SolvingOrganizational SkillsLeadership Skills

Required

A bachelor's degree in Computer Science, MIS, or related area and significant experience with business intelligence, data engineering and data modeling

5+ years of experience with reading and writing SQL

5+ years of experience engineering within a data warehouse or related experience with dimensional data modeling

5+ years of experience designing and developing ETLs/pipelines in Python, Google BigQuery Dataprocs and/or Informatica ETL

3+ years of experience with data enablement for a Supply Chain Planning platform, preferably o9 solutions

Excellent written and verbal communication skills

Proven ability to gather detailed technical requirements to design and develop data structures supporting business intelligence report solutions from beginning to end

Excellent organizational and time management skills

Tested problem-solving and decision-making skills

A strong pattern of initiative

Highly developed interpersonal and leadership skills

Must be a Citizen or National of the United States, a lawful, permanent resident, or have authorization to work in the United States

Applicants must not now, or in the future, require sponsorship for an employment visa

Preferred

Experience with Supply Chain data, including logistics, inventory, procurement, and manufacturing

Familiarity with ERP systems and supply chain planning tools

3+ years of experience designing and developing within a business intelligence/reporting tool like Oracle Business Intelligence, Tableau or Google Cloud Platform

Experience with Incorta Data Delivery Platform connecting to Oracle Fusion Cloud applications

Experience working within Google Cloud Platform with services like Dataflow, Datafusion, Pub/Sub, Cloud SQL, Cloud Storage

Experience with Oracle SQL including advanced functions like analytical functions

Experience tuning SQL and ETLs

Experience within a core metadata model (RPD) including the physical, logical and presentation layers for the enterprise business intelligence platform (OBIEE – Oracle Business Intelligence Enterprise Edition.)