Hormel Foods is looking to grow and modernize analytics within the Sales and Marketing domain by hiring a Staff Data Engineer to enhance enterprise reporting and analytics.
Requirements
4+ years of experience with reading and writing SQL.
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.
Experience engineering within a data warehouse or related experience with dimensional data modeling.
Experience tuning SQL and ETLs.
Proven ability to gather detailed technical requirements to design and develop business intelligence report solutions from beginning to end.
Responsibilities
Develop the overall database/data warehouse structure based on functional and technical requirements.
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.
Utilize SQL within Google BigQuery, Informatica ETLs, Incorta pipelines, or Oracle SQL Views to achieve proper metric calculations or derive dimension attributes.
Engineer schedule and orchestration for batch and mini-batch data loads into enterprise data warehouses and platforms.
Provide issue resolution and maintenance for various business unit solutions existing in 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 models to enhance enterprise reporting and analytics.
Other
Strong communication skills and the ability to collaborate across multiple levels of the organization.
Manage multiple initiatives that require creative problem-solving.
Excellent written and verbal communication skills.
Excellent organizational and time management skills.
Tested problem-solving and decision-making skills.
