Immediate Start: Lead Data Engineer

About Land O LakesLand OLakes 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 were uniquely qualified to fulfill our purpose of feeding human progress Were 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 worlds most important food challenges About ANSR Land O Lakes has partnered with ANSR to setup their GCC in India You will be employed by ANSR until Land O Lakes GCC is operationally ready The transition from ANSR to Land O Lakes GCC is targeted to be completed within the next two years About our Client Land O Lakes For over 100 years Land O Lakes while primarily known for its contributions to the dairy industry has also embraced technology to enhance its agricultural operations From utilizing advanced analytics for crop management to implementing precision farming techniques Land O Lakes integrates technology into various aspects of its operations Moreover the cooperative invests in innovative solutions such as digital tools and artificial intelligence to optimize production processes and improve efficiency across its supply chain Land O Lakes is looking for big thinkers and big dreamers to help them imagine the future of food and agriculture Summary Role Data EngineerThe Sr data engineer will design solutions and work with a team of engineers to ensure accurate consistent reliable and sustainable solutions are delivered The data engineer will also influence data engineering processes that result in highly accurate and trusted data assets for use in Truterra and across the organization Additionally the lead data engineer influences stakeholders to ensure investments in data driven solutions are centered on optimizing clearly defined and quantified business outcomes Required Education and Experience Bachelors degree in computer science MIS or related field with 7 years of experience Applicable experience is characterized as advanced SQL data engineering data modeling techniques 7 years of experience building data integration solutions using tools like Informatica Talend Mulesoft Qlik etc Strong experience building out data warehouse and or data lake 3 years of experience leading engineering resources 2 years of experience working with cloud-native data solutions on Microsoft Azure AWS or Google Cloud platform Strong experience leading full lifecycle large complex reporting or data engineering efforts Strong experience in working with heterogeneous datasets in building and optimizing data pipelines pipeline architectures and integrated datasets using various data integration technologies ETL ELT data replication CDC message-oriented data movement API design etc Experience with DevOps CI CD pipelines and automated testing Required Competencies skills Implement data structures using standards and best practices in data modeling ETL ELT processes SQL database and other technologies Advanced working SQL knowledge and experience working with relational databases query authoring SQL as well as working familiarity with a variety of databases Thorough experience building and optimizing data pipelines and data sets Deep knowledge of the data vault method model and architecture Ability to manage the overall data landscape meta data processing patterns and data quality A successful history of manipulating processing and extracting value from large datasets Strong working knowledge of message queuing stream processing and highly scalable data stores Ability to obtain a clear understanding of business needs and value developing a detailed vision for the initiative mapping out the solution and guiding its implementation Develop test-driven solutions that can be deployed quickly and in an automated fashion Ability to obtain a clear understanding of business needs and value developing a detailed vision for the initiative mapping out the solution and guiding its implementation Demonstrated ability to collaborate across all levels Engineers Management Architects etc across all skill sets Data scientists Data visualization developers Salesforce developers etc particularly in a Product-oriented culture Excellent communication presentation and documentation skills including the ability to distill highly technical concepts and communicate them effectively to non-technical stakeholders Ability to function as a technical lead working closely with developers and data analysts as well as hands-on implementation Demonstrated ability to develop and maintain trusted-advisor status to technology and business stakeholders at various levels Capable of using agile methodology and implementing Continuous Integration Continuous Delivery CI CD pipelines 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 Bachelors or Masters degree in Business Analytics Computer Science Mathematics Statistics or a related discipline or an equivalent combination of demonstrated skills and experience Experience working with Databricks or Spark Qlik technologies Replicate and Compose Experience with any scripting languages preferably Python Experience working with BI Tools Power BI Tableau etc to create dashboards and reports Experience with Snowflake Experience working using agile methodologies Experience in Manufacturing or Agriculture industry Preferred 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 Disclaimer Land O Lakes is a client of ANSR All employees will initially be employed by ANSR with the intent to transition to Land O Lakes within the next two years