Data Engineer

Agri-Mark/Cabot Creamery•Waitsfield, VT

1d•Hybrid

About The Position

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.

Requirements

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.

Responsibilities

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.