Data AnalystAssociate Data Engineer IT (Austin, MNWillmar, MNEden Prairie, MN)

DATA ANALYST/ASSOCIATE DATA ENGINEER IT (AUSTIN MN/WILLMAR MN/EDEN PRAIRIE MN)

HORMEL FOODS CORPORATION

To save time applying Hormel Foods does not offer sponsorship of job applicants for employment-based visas for this position at this time.

ABOUT HORMEL FOODS

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 includePlantersSkippySPAMHormelNatural Choice Applegate Wholly HormelBlack Label ColumbusJennie-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. For more information visit.

SUMMARY:

Individuals interested in this position will support a dedicated business domain: our Data Engineering team within the Data and Analytics Office and will require strong initiative communication and interpersonal skills.

Specific competencies include:

• Data Structures and Models- Performs enhancements to modeling techniques with direct supervision. Special analysis may be conducted using standard statistical and/or data visualization techniques.

• Data Pipelines and ELT- Collates and analyzes data. Transforming database requirements into logical data models. Developing physical data models to define the database structure.

• Data Performance- Collects and reports management data to support decisions on day-to-day operations and specific business performance issues. Compiles sorts and organizes data in preparation for subsequent analysis. Helps to identify and resolve any data quality issues through allocated data cleaning and testing tasks.

• Visualizations and Dashboards- Uses a limited range of BI and data analysis tools to provide visualizations and reports within a comparatively structured reporting framework. Collaborates with internal clients and other team members to understand business requirements and support the development of routine and ad-hoc reports and dashboards in line with these requirements.

Level of position determined based on qualifications and experience.

RESPONSIBILITIES:

• Collaborates with business and technical team members data scientists BI analysts and other stakeholders to understand data needs and deliver solutions.

• Translates functional requirements into data model and pipeline needs.

• Provides issue resolution and maintenance of existing business unit solutions in the enterprise data warehouses.

• Engineers data models for dimensions and facts within the staging and warehouse layers ensuring grain keys and source-to-target mappings follow established patterns.

• Supports development in the semantic/presentation layers used by enterprise BI tools.

• Engineers and performancetunes basic data pipelines moving data from various source systems and file types into dimensional models.

• Utilizes SQL within Python Informatica Google BigQuery and Oracle SQL Views to perform metric calculations or derive dimension attributes.

• Develops scheduling and orchestration for batch full and incremental loads into enterprise data warehouse platforms following established standards and patterns.

• Develops components within the core metadata modelphysical logical and presentation layersused by enterprise BI platforms.

• Engineers dashboards and visualizations that apply simple intuitive UI designs and support core Supply Chain reporting needs.

QUALIFICATIONS:

Required:

• Bachelors degree in computer science Data Analytics MIS or related field and experience in

  business intelligence and data warehouse development.

• 2 years of SQL experience (reading and writing SQL for analysis or transformation).

• 2 years of experience working in a business intelligence/reporting tool such as Tableau PowerBI or OBIEE.

• 1 year of experience developing ETLs or integrations using tools such as Python Informatica SSIS.

• Proficient written and verbal communication skills.

• Proficient organizational and timemanagement skills.

• Demonstrated problemsolving ability.

• Strong initiative and interpersonal skills.

• Applicants must not now or at any time in the future require sponsorship for a work visa.

• Applicants must be authorized to work in the United States for any employer.

Preferred:

• Proficient SQL skills.

• Experience developing data pipelines and queries within Google Cloud Platform (BigQuery) and/or Oracle databases.

• Experience engineering within a data warehouse or handson dimensional modeling experience.

• Experience tuning SQL and ETLs.

• Proven ability to gather detailed requirements and deliver BI/reporting solutions endtoend.

LOCATION:Austin MN / Willmar MN / Eden Prairie MN

A comprehensive relocation package to the above areas will be offered if required.

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 the Data Analyst/Associate Data Engineer role is between$70900 - $104050 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.

BENEFITS:Other components of Hormel Foods total compensation package includes comprehensive medical dental and vision coveragediscretionary annual merit increases bonuses and profit sharing 401(k) with employer match stock purchase plan relocation assistance paid time off free two-year community/technical college tuition for children of employees and more.

TRAVEL REQUIREMENTS:10% of the time

For immediate consideration apply online 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 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.