Data Engineer

ANSR is hiring for one of its clients:

About Land O'Lakes:

Land O'Lakes, Inc. is a 100-year-old farmer-owned cooperative originally formed with the purpose of working together to create new market opportunities for dairy producers. Our journey began in 1921, when 320 dairy farmers met in St. Paul, Minnesota, to form the Minnesota Cooperative Creameries Association. Their idea was simple: join together to effectively market and distribute members dairy production across the country. Today, our four businesses give us a farmer-to-fork view of agriculture. Paired with our co-op ownership model, we're uniquely qualified to fulfill our purpose of feeding human progress. We're looking for big thinkers and big dreamers to help us imagine the future of food and agriculture.

Be a part of a Fortune 500, $17 billion farmer-owned cooperative that is actively shaping the food and agriculture industry for the better. Join us in solving some of the world's most important food challenges.

Summary:

Land O'Lakes is looking to add a Data Engineer to our WinField United Advanced Analytics & Insights team. The Data engineer will design & execute solutions and work with a team of engineers to ensure consistent, reliable, efficient and sustainable solutions are delivered. This role involves working closely with product owners, data architects, analysts and business stakeholders to deliver highly accurate and trusted data assets for use in WinField United and across the organization.

Required Education and Experience:

• Bachelor's degree in Computer Science, MIS, or related field.
• 3+ years of experience with SQL & data engineering techniques.
• 2-3 years of experience building data integration solutions using ETL tools.
• Design, develop and maintain ETL/ELT pipelines for structured and semi-structured data.
• Experience in working with Cloud data warehouse like Snowflake with strong expertise in SQL, managing data ingestions and curations for reporting.
• Experience with Azure data lake storage (ADLS Gen2) and good understanding of ELT design patterns.
• Proficiency in Python for data processing and automation. Experience with Databricks is preferable.
• Ensure data quality, reliability, governance across pipelines using RBAC, masking policies and row level security.
• Experience with CI/CD for data pipelines using Azure Devops or GitHub actions.
• Knowledge of ETL/ELT tools such as Azure Data Factory, FiveTran, DBT, Informatica etc.
• Experience in working with Agile methodology and scrum delivery models.
• Familiarity with data governance tools such as Alation, Purview or others.

Required Competencies/skills:

• Ability to obtain a clear understanding of business needs and value, mapping out the solution, and working on its implementation.
• Ability to collaborate across all levels and areas of the product & business team as well as perform hands-on implementation.
• Excellent communication, presentation, and documentation skills, including the ability to distill highly technical concepts and communicate them effectively to non-technical stakeholders
• Capable of using agile methodology and implementing Continuous Integration/Continuous Delivery (CI/CD) pipelines
• Exposure to data vault method, model, and architecture is preferable.
• Ability to work closely with developers and data analysts to design and optimize data access, query, reporting and analysis strategies to solve complex business problems
• Troubleshooting skills, ability to determine impacts, ability to resolve complex issues, and ability to exercise sound judgment and initiative in challenging situations.

Preferred Education and Experience:

• Bachelor's or Master's degree in Business Analytics, Computer Science, Mathematics, Statistics, or a related discipline; or an equivalent combination of demonstrated skills and experience.
• Experience working with Snowflake Cloud platform.
• Experience with any scripting languages, preferably Python.
• Experience working using agile methodologies.
• Experience in Manufacturing, Retail or Agriculture industry.

Preferred Competencies/Skills:

• Ability to work closely with business partners to influence decisions on value adds/Innovations.
• Ability to adapt to project scope changes, time management and team collaboration.
• Working knowledge of data privacy and data governance processes to handle highly confidential sensitive data on integrations.