Data Engineer

Company:
Location: Austin, MN 55912

*** Mention DataYoshi when applying ***

Data Engineer

Hormel Foods Corporation

ABOUT HORMEL FOODS - Inspired People. Inspired Food.™

Hormel Foods Corporation, based in Austin, Minn., is a global branded food company with over $9 billion in annual revenue across more than 80 countries worldwide. Its brands include SKIPPY®, SPAM®, Hormel® Natural Choice®, Applegate®, Justin's®, Wholly®, Hormel® Black Label®, Columbus® and 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 on the Global 2000 World's Best Employers list by Forbes magazine for three straight years, is one of Fortune magazine's most admired companies, has appeared on Corporate Responsibility Magazine's The 100 Best Corporate Citizens list for the 12th year in a row, 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 world's most trusted and iconic brands to tables across the globe. For more information, visit www.hormelfoods.com and http://csr.hormelfoods.com/.

SUMMARY:
The Data Engineer, works within our Data Engineering team, part of a broader IT Analytics team, to gather requirements, engineer, and scale our custom Oracle Enterprise Data Warehouse using Informatica ETL, data modeling and SQL. Additionally, the Data Engineer will engineer reports, dashboards and visualizations within our enterprise business intelligence platform (OBIEE - Oracle Business Intelligence Enterprise Edition).

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, 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. Walks the business through definitions of data.

RESPONSIBILITIES:
  • Works directly with business units to understand their analytics use cases and gather requirements for an analytics solution
  • Engineers data models for dimensions and facts within the staging and warehouse layer of our enterprise data warehouse
  • Engineers and performance tunes Informatica ETLs to move data from a variety of source systems and file types to fit into dimensional data models
  • Utilizes advanced SQL within Informatica ETLs or Oracle SQL Views when necessary to achieve proper metric calculations or derive dimension attributes
  • Engineers schedule and orchestration for batch and near-real time data loads into the enterprise data warehouse
  • Provide issue resolution and maintenance for a large variety of business unit solutions already existing in the enterprise data warehouse
  • Engineers 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)
  • Engineers dashboards within the enterprise business intelligence platform containing reports and visualization that have intelligent user interface design and flow for the business including adequate performance

QUALIFICATIONS:

Required:
  • A bachelor's degree in Computer Science, MIS, or related area and significant experience with business intelligence design and development.
  • 4+ years of experience with reading and writing SQL.
  • 4+ years of experience engineering within a data warehouse or related experience with dimensional data modeling.
  • 4+ years of experience designing and developing ETLs with tools like Informatica, Microsoft SSIS (SQL Server Integration Services), Oracle Data Integrator (ODI), Python.
  • Excellent written and verbal communication skills.
  • Proven ability to gather detailed technical requirements to design and develop 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 the authorization to work in the United States.
  • Applicants must not now, or any time in the future, require sponsorship for an employment visa.

Preferred:
  • Experience designing and developing within a business intelligence/reporting tool like OBIEE (Oracle Business Intelligence Enterprise Edition) or OTBI (Oracle Transactional Business Intelligence).
  • Experience with Oracle SQL including advanced functions like analytical functions.
  • Experience with business processes or core database tables within Oracle Cloud Supply Chain and Finance modules.
  • Experience working with Informatica ETL tools
  • Experience tuning SQL and ETLs.
  • Experience working with Oracle Analytics Cloud, Oracle Data Visualization or Oracle Autonomous Data Warehouse

LOCATION:

Austin, MN.

TRAVEL REQUIREMENTS: Travel may be necessary 10% of the time.

BENEFITS:

Hormel Foods offers an excellent benefits package. Competitive base salary plus bonus, annual merit increase performance reviews, medical, dental, vision, non-contributory pension, profit sharing, 401(k), stock purchase plan, relocation assistance, paid vacation.

For immediate consideration, send apply online at: www.hormelfoods.com/careers

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: https://www.hormelfoods.com/about/diversity-and-inclusion/

Hormel Foods Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

*** Mention DataYoshi when applying ***

Offers you may like...

  • inovex GmbH

    Data Engineer / Machine Learning Engineer*
    Home Office
  • XOi Technologies

    Data Engineer (Analytics)
    Nashville, TN
  • Cepheid

    Sr Data Engineer
    New York, NY 10001
  • Pacific Biosciences

    Engineer II, Software Data Engineer
    Remote
  • Health Catalyst

    Data Engineer (Life Sciences)
    Remote