Hormel Foods is looking to modernize its analytics capabilities within the Sales and Marketing domain by hiring a Staff Data Engineer to grow and enhance enterprise reporting and analytics.
Requirements
- 4+ years of experience with reading and writing SQL.
- 3+ years of experience engineering within a data warehouse or related experience with dimensional data modeling.
- 3+ 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 Point of Sale or Syndicated Consumption platforms. Preferably, Circana.
- Ability to gather detailed technical requirements to design and develop data structures supporting business intelligence report solutions from beginning to end.
- Advanced SQL reading and writing skills.
- Experience developing data pipelines and queries within Google Cloud Platform (Google BigQuery) and/or Oracle Databases.
Responsibilities
- Develops the overall database/data warehouse structure based on functional and technical requirements.
- Applies data extraction, loading and transformation techniques in order to connect medium to large data sets from a variety of sources.
- With minimal guidance, troubleshoots and fixes for data performance issues that come with querying and combining medium to large volumes of data.
- Designs and develops reports and dashboards that meet business needs.
- Engineer physical and logical data models for dimensions and facts within the staging, warehouse, and semantic layers of enterprise data warehouses and platforms.
- Performance tune SQL, Python, Incorta, or Informatica ETL pipelines, as well as Google BigQuery Dataprocs to move data from various source systems and file types into dimensional data models.
- Engineer dashboards within enterprise business intelligence platforms containing reports and visualizations with intelligent user interface design and flow for the business, ensuring adequate performance.
Other
- The ideal candidate will have strong communication skills and the ability to collaborate across multiple levels of the organization.
- You will manage multiple initiatives that require creative problem-solving.
- Excellent written and verbal communication skills.
- Excellent organizational and time management skills.
- Applicants must not now, or at any time in the future, require employer sponsorship for a work visa.
