Principal Data Platform Architect (Hybrid)

Constant Contact; Waltham (MA); Hybrid; USD 138,000 - 172,000; Full time

Job summary

Constant Contact is seeking a Principal Data Engineer to lead the Enterprise Data Platform, shaping data strategies and building scalable data pipelines that empower customer insights. You will bridge business stakeholders and technical teams, driving architectural decisions across cloud platforms including AWS and GCP.

The role emphasizes leading multi-team platform architecture, mentoring engineers, and delivering end-to-end data solutions in a fast-paced environment.

Qualifications

• 12+ years of experience with data, SQL, Python, Snowflake, AWS, software engineering or database development.
• Ideal candidate has led platform architecture for a multi-team data organization.
• Experience developing end-to-end data pipelines to transform and process data for reporting layer.
• Production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark.
• Full grasp of continuous integration and delivery, including branching strategies, automated deployment and functional automation within CI and CD Pipelines.

Responsibilities

• Architect large-scale data intelligence solutions, evaluating Snowflake Data Warehouse and/or Google BigQuery.
• Design and evolve an open lakehouse on AWS: S3 with Iceberg/Delta formats, medallion architecture, and Trino federation.
• Develop data ingestion pipelines using AWS EMR, Snowpipe, AWS DMS, etc.
• Own orchestration patterns in Dagster: asset-based pipelines, code-location design, lineage, sensors and schedules.
• Set dbt standards for enterprise data model and CI for model changes.
• Hands-on building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python.
• Tune Trino for performance and cost: catalog, resource groups, Kubernetes scaling.
• Set technical direction and write architecture decision records; mentor engineers across teams.

Skills

SQL development

Python

Snowflake

AWS

Dagster

dbt

Spark

Kubernetes

ETL pipelines

BigQuery

Education

Bachelor/Master in CS/IT

Tools

Dagster

Airflow

dbt

Spark

Trino

Iceberg/Delta

Kubernetes

Terraform

CDK

Glue/Hive

Job description

Constant Contact is seeking a Principal Data Engineer to lead the Enterprise Data Platform, shaping data strategies and building scalable data pipelines that empower customer insights. You will bridge business stakeholders and technical teams, driving architectural decisions across cloud platforms including AWS and GCP.

The role emphasizes leading multi-team platform architecture, mentoring engineers, and delivering end-to-end data solutions in a fast-paced environment.