Description 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 includePlanters SkippySPAMHormelNatural Choice Applegate Justins Wholly HormelBlack Label Columbus Jennie-Oand 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 Americas most responsible companies by Newsweek recognized by TIME magazine as one of the Worlds 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 worlds most trusted and iconic brands to tables across the globe. For more information visit. 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 bachelors 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 Qualifications: • 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.) LOCATION: Austin MN Global Headquarters 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 $96400-$135000 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: Foods Corporation is an equal opportunity qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or veteran status.
See More Details >>Embarking on a career in the mechanical trade in Austin, MN, typically begins with an apprenticeship, blending hands-on experience with classroom learning, allowing individuals to earn while they learn. Apprenticeships last about three to four years, requiring extensive training under licensed professionals. According to the U.S. Bureau of Labor Statistics, there are approximately 503,000 mechanical trade professionals nationwide, with wages averaging around $754 per week in Austin, MN. The job outlook is promising, with an expected 11% growth from 2023 to 2033. Trade schools, unions, and platforms like HireLevel help aspiring mechanical professionals find apprenticeship opportunities, leading to a career with strong earning potential—often exceeding $954 per week for experienced professionals.
