Data Engineer

How would we describe a career with Agri-Mark/McCadam/Cabot Creamery? More than 100 years of: Farmers, Family, Mission, Purpose, Sustainability, Respect, Integrity, Work Ethic, Teamwork, Pride in Award Winning Products, and Agriculture. Cabot Creamery achieved B Corp certification in 2012 and became the world's first dairy co-op to do so. This certification demonstrates our commitment to transforming the global economy to benefit all people, communities, and the planet. The salary range for this position is $90-95k We offer a hybrid workplace with three days onsite in our corporate office (Tuesday - Thursday) in Waitsfield, VT. Join a collaborative team that values innovation and continuous learning, with opportunities to lead modernization efforts and shape the future of our analytics platform. As a Data Engineer, you'll play a pivotal role in driving the transformation of our data ecosystem, working on cutting-edge projects that empower business decision-making and support organizational growth. In this dynamic role, you will design, develop, and maintain scalable data pipelines and architectures that empower our organization to harness the full potential of data. Your expertise will enable seamless integration of diverse data sources, optimize data workflows, and support advanced analytics initiatives. We are looking for talent to modernize our data stack as we continue to grow our analytics. If you are passionate about transforming raw data into actionable insights and driving the company towards new opportunities, then this is the position for you. What you'll be doing: Drive the development, implementation, and optimization of scalable ETL (Extract, Transform, Load) processes to ensure seamless data flow across systems. Utilize SSIS to extract data from diverse sources, transform it for business needs, and load it into modern data warehouses. Lead the creation and maintenance of data models using SSAS to support dynamic business intelligence and reporting initiatives. Design and write advanced SQL queries and stored procedures to extract, manipulate, and deliver actionable insights from our data warehouse and other sources. Champion the building and management of complex SQL databases using Microsoft SQL Server and other relational systems, ensuring top performance, security, and reliability. Lead cross-functional collaborations to deliver impactful data solutions, translating business requirements into effective data strategies. Conduct thorough data analysis to identify trends, anomalies, and valuable insights that inform strategic business decisions. Monitor, optimize, and enhance data pipelines and warehouse performance to maximize data accuracy and availability. Develop and maintain comprehensive documentation for data models, ETL processes, and data flows to support knowledge sharing and continuous improvement. Support model training and analytical activities by providing clean, well-structured datasets and contributing to the ongoing refinement of data models through iterative testing. Champion data quality initiatives across the organization and participate in Agile development cycles to rapidly deliver high-impact solutions with thorough documentation for ongoing maintenance.

What we are seeking:

Bachelor's degree in Computer Science, Software Engineering, Information Systems, or a related field. 3+ years of hands-on experience in data engineering or a related discipline. Proficiency in

SSIS, SSAS, SQL

Server, and Azure. Strong SQL programming skills with expertise in developing complex queries and stored procedures. Extensive knowledge of SQL databases including Microsoft SQL Server, with experience in Data Warehouse concepts. Ability to design efficient database schemas, optimize query performance, and interpret complex datasets with precision. Familiar with core data engineering concepts: orchestration, idempotency, ETL/ELT. Experience working with Git repositories. Proficient in Python. Experience with dbt and Snowflake. Strong analytical and problem-solving mindset. Outstanding communication and collaboration abilities. Proven ability to work independently and thrive in team environments. Enthusiasm for exploring new technologies and data sets. Meticulous attention to detail, with a commitment to data accuracy and quality. Agri-Mark is an equal opportunity employer. The company is committed to the fundamental principle of equal opportunity and equal treatment for every qualified prospective and current employee. The company does not discriminate or allow discrimination on the basis of race (including traits historically associated with race including hair texture and protective hairstyles), color, religion, ancestry, national origin, citizenship, genetic information, sex (including pregnancy or pregnancy-related conditions), sexual orientation, gender identity, place of birth, crime victim status, age, physical or mental disability, a positive result from an HIV-related blood test, military or veteran status, or any other classification protected under applicable federal and/or state law. Agri-Mark complies with all federal, state, and local laws and regulations.