Senior ETL Data Engineer — Snowflake & Matillion Expert

The Paper Store; Acton (MA); On-site; USD 80,000 - 120,000; Full time

Job summary

The Paper Store in Acton, MA is seeking an experienced Data Engineer to own and optimize end-to-end data pipelines in a Snowflake environment. This hands-on role focuses on production-grade ETL using Matillion and SSIS, building scalable data models, and ensuring data quality and reliability.

You will collaborate with data analysts and engineers, monitor performance, implement data security, and guide junior team members as needed.

Qualifications

• 2+ years of data engineering experience.
• Hands-on experience with Matillion is required.
• Hands-on experience with Snowflake is required.
• Experience with SSIS or similar ETL tools is required.
• Strong SQL skills; production ETL pipelines experience.
• Proficiency in data modeling, warehousing, and governance.
• Team player with good documentation and communication.

Responsibilities

• Own and optimize end-to-end ETL pipelines in Snowflake.
• Design, develop, and maintain production-grade ETL using Matillion and SSIS.
• Build and maintain data models within Snowflake.
• Ensure data quality, validation, and data governance.
• Monitor performance, reliability, and operational visibility.
• Collaborate with analysts, engineers, and stakeholders.
• Guide junior team members and support data-driven decisions.

Skills

SQL

Python/Java

Data modeling

Data warehousing

Cloud platforms

Data governance

Documentation

Team player

Tools

Matillion

Snowflake

SSIS

Job description

The Paper Store in Acton, MA is seeking an experienced Data Engineer to own and optimize end-to-end data pipelines in a Snowflake environment. This hands-on role focuses on production-grade ETL using Matillion and SSIS, building scalable data models, and ensuring data quality and reliability.

You will collaborate with data analysts and engineers, monitor performance, implement data security, and guide junior team members as needed.