Senior Data Architect: Lakehouse, Snowflake & BigQuery

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

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.