Principal Data Engineer (Fully Remote)

Constant Contact; United States; Remote; USD 150,000 - 190,000; Full time

Benefits offered by this job

Generous PTO

Competitive benefits

Career development opportunities

Job summary

Constant Contact is seeking a senior data architect to lead the design and implementation of large-scale data intelligence solutions. You will shape architectural options around Snowflake and related platforms, and drive standards for data models and ETL development.

In this role, you will define a cross-organization data strategy, build scalable lakehouse patterns on AWS, mentor teams, and ensure robust data governance and CI for data workflows.

Qualifications

• 12+ years of experience working with data in SQL, Shell Scripting, Python, Snowflake, AWS, software engineering or database development.
• Production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark.

Responsibilities

• Architect large-scale data intelligence solutions, performing architectural assessments, crafting architectural options and analysis around Snowflake Data Warehouse and/or Google BigQuery.
• Design and evolve an open lakehouse on AWS: S3 with Apache Iceberg/Delta table formats, a medallion architecture (bronze → silver → gold), and Trino as the federated query engine.
• Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.

Skills

SQL

Shell scripting

Python

Data warehousing

Software engineering

Database development

Tools

Snowflake

AWS

Trino/Presto

Iceberg/Delta/Hudi

dbt

Dagster/Airflow

Spark

Job description

• Architect large-scale data intelligence solutions, performing architectural assessments, crafting architectural options and analysis around Snowflake Data Warehouse and/or Google BigQuery.
• Design and evolve an open lakehouse on AWS: S3 with Apache Iceberg/Delta table formats, a medallion architecture (bronze → silver → gold), and Trino as the federated query engine.
• Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.

Who You Are:

• 12+ years of experience working with data in SQL, Shell Scripting, Python, Snowflake, AWS, software engineering or database development.
• Production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark.

Why You'll Love Us:

• We celebrate one another's differences and are proud of our culture of diversity and inclusion.
• We offer opportunities to grow your career with stretch assignments, coaching, and professional development.
• A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family.

Constant Contact empowers small businesses, entrepreneurs, and nonprofits to grow online with tools and support. With a culture of ownership and courage, the company values diversity and inclusion, offering a generous PTO policy and competitive benefits.