Job Title

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 Senior Data Engineer to our WinField United Advanced Analytics & Insights team. The Lead data engineer will design & execute solutions and work with a team of engineers to ensure consistent, reliable, efficient and sustainable solutions are delivered. The data engineer will also contribute towards improving data management processes that result in 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 - 7+ years of experience with SQL & data engineering techniques. - 7+ years of experience building data integration solutions using tools like Informatica, Talend, Mulesoft, Qlik, etc. - 3+ years of experience leading engineering resources - 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 solid 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. - Collaborate with data analysts, data scientists, and product teams to understand data strategy for Business outcomes. - 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 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 - Ability to monitor the overall data landscape: meta data, processing patterns, and data quality - 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 - Ability to proactively communicate and manage technology and projects risks - Troubleshooting skills, ability to determine impacts, ability to resolve complex issues, and ability to exercise sound judgment and initiative in challenging situations - Establish platform-wide standards - Perform root cause analysis when there are issues - Ability to proactively communicate and manage technology and projects risks - 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 Qlik technologies (Replicate and Compose) - Experience with any scripting languages, preferably Python - Experience working using agile methodologies - Experience in Manufacturing, Retail or Agriculture industryPreferred Competencies / Skills:- Ability to work closely with business partners to influence decisions on technology investments - Ability to provide technical leadership to evangelize best practices/proven patterns and promote the use of Corporate IT standards - Working knowledge of data privacy regulations including GDPR and CCPA as well as how to design solutions to drive compliance