You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Constant Contact

Principal Data Engineer

  • Remote
  • 6+ years

Salary

$137,800 - 172,250/ year

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

The company helps business owners, entrepreneurs, non-profits and individuals grow online by giving them the tools they need to succeed.

The Enterprise Data Platform team is hiring a Principal Data Engineer to reshape how customer insights are built and delivered, a role that matters to the company's future growth.

You will promote the platform across the company, so you need a real understanding of the business alongside strong technical skills. You will bridge business stakeholders and technical data teams. The ideal person works independently, solves problems creatively and adapts quickly in a fast-moving setting.

Responsibilities

  • Architect large-scale data intelligence solutions, run architecture assessments, and write options and analysis covering Snowflake Data Warehouse and/or Google BigQuery.
  • Design and evolve an open lakehouse on AWS, using S3 with Apache Iceberg or Delta table formats, a bronze, silver and gold medallion layout, and Trino as the federated query engine.
  • Settle on the preferred solution with IT and business stakeholders, then build ingestion pipelines with tools such as AWS EMR, Snowpipe and AWS DMS.
  • Build ETL pipelines that move data into and out of the warehouse using Python, Scala, SnowSQL and similar tools.
  • Own Dagster orchestration: asset-based pipelines, code-location design, cross-asset lineage, sensors and schedules, and partitioning with backfills.
  • Define dbt standards for the enterprise data model, covering layering (staging, intermediate and marts), testing, documentation and CI for model changes.
  • Tune Trino for speed and cost, including query planning, catalog setup (Glue, Hive or REST), resource groups and scaling on Kubernetes.
  • Set technical direction and write architecture decision records for peer and leadership review.
  • Mentor engineers in the US and India, and raise quality through code and design reviews.

Requirements

  • Have 12+ years of experience with data through SQL development, shell scripting, Python, Snowflake, AWS, software engineering or database development.
  • Bring professional knowledge of cloud platforms such as AWS and GCP.
  • Ideally, you have led platform architecture for a data organization spanning several teams.
  • Have built end-to-end data pipelines that transform and process data for a reporting layer.
  • Have worked with large-scale structured and unstructured data sets.
  • Have production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark.
  • Have a thorough grasp of continuous integration and delivery, including branching strategies, automated deployment and functional test automation in CI/CD pipelines.
  • Communicate clearly with both business and technical audiences.
  • Model data well: dimensional (Kimball) design, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants.
  • Have experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services.
  • Hold a Bachelor's or Master's degree in Computer Science, Information Technology or an equivalent field.
  • Have a solid understanding of data warehouse and ODS design, and of ETL concepts and modeling structures.
  • Work well in an agile team that runs with a high degree of self-direction.
  • Nice to have: semantic layers (Cube, dbt Semantic Layer), data catalogs, ML or identity resolution, marketing or ad-tech data, and big data.
  • Experience with billing data and systems is a big plus.

Conditions

Base pay ranges from $137,800 to $172,250 USD, depending on experience, education and work location.

Some roles may also be eligible for on-target commission or a bonus.

The role is hybrid: you combine remote work with time in a company office for in-person collaboration, live training and team time.

The application window is 30 days, and the company may close the posting earlier once a candidate is selected.

The role sits within an affiliate company in the same group of brands.

The company is an equal opportunity employer, and it is unlawful in Massachusetts to require a lie detector test as a condition of employment.

Benefits

  • Generous paid time off.
  • A competitive benefits package covering health and well-being for you and your family, including health and welfare benefits and paid leave.
  • Chances to grow your career through learning other parts of the business, stretch assignments, coaching and professional development.

Where you’d work

Fully remote

You can work from

  • United States
  • Canada

About the company

Constant Contact

  • Industry: SaaS

Also hiring in MA, United States

4 of their 5 open roles are remote

Your chances

We've checked whether it's still hiring and how crowded it is.

  • 21 checks run
  • 0 red flags

Still hiring?

14 checks

No red flags

How crowded?

7 checks

No red flags

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details12 facts · Role, Location, Compensation, Employment, Company
Tech stack
  • Python
  • SQL
  • AWS
  • Kubernetes
  • dbt
  • Spark
  • Snowflake
  • Airflow
  • BigQuery
Seniority
Principal
Type
Contract
Industry
SaaS
Specialty
Data Engineering
Region
United States
Show 6 more factsShow less

Role

Category
Data & Analytics
Specialty
Data Engineering
Seniority
Principal
Experience
12+ years
Tech stack
  • Python
  • SQL
  • AWS
  • Kubernetes
  • dbt
  • Spark
  • Snowflake
  • Airflow
  • BigQuery

Location

Work model
Remote
Region
United States
Remote from
  • United States
  • Canada

Compensation

Salary
$137,800 - 172,250 / year
Pay period
Annual

Employment

Type
Contract

Company

Industry
SaaS

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason