Back to jobs

Principal Data Engineer

Remote, US or Remote, Ontario, Canada

Actively hiring, first seen by us 5 hours ago
Pay
USD 137,800–172,250/yearAnnual period assumed — pay source
Pay Transparency - All Full Time Employees $137,800—$172,250 USD Why You’ll Love Us:
Read the full posting
Work setting
Remote — work setting source
Listed location: Remote, US or Remote, Ontario, Canada
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Architect large-scale data solutions on Snowflake and/or Google BigQuery

  • Design an open lakehouse on AWS with Iceberg/Delta tables and Trino

  • Build ingestion and ETL pipelines using Python, Scala, Spark and SnowSQL

  • Own Dagster orchestration, lineage, schedules and backfills

  • Set dbt standards for layering, testing, documentation and CI

From the employer’s posting
Architecting large-scale data intelligence solutions, performing architectural assessments
Design and evolve an open lakehouse on AWS: S3 with Apache Iceberg/Delta table formats
Developing ETL pipelines in and out of data the warehouse using but not limited to Python, Scala,SnowSQL, etc.
Own orchestration patterns in Dagster: asset-based pipelines, code-location design, cross-asset lineage
Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.

What you’ll bring

All qualifications

Core experience

  • 12+ years of experience working with data in the following ways: SQL development, Shell Scripting, Python, Snowflake, AWS, software engineering or database development
  • Experience developing end-to-end data pipelines to transform and process data for reporting layer
  • Experience with large-scale data sets using both structured and unstructured data
  • Strong communication skills across both business and technical communities
  • Strong data modeling: dimensional/Kimball, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants
  • Experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services
Qualification wording
12+ years of experience working with data in the following ways: SQL development, Shell Scripting, Python, Snowflake, AWS, software engineering or database development
Experience developing end-to-end data pipelines to transform and process data for reporting layer
Experience with large-scale data sets using both structured and unstructured data
Strong communication skills across both business and technical communities
Strong data modeling: dimensional/Kimball, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants
Experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services
Education & alternatives
- Experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services - Bachelor or Master’s degree in Computer Science, Information Technology or Equivalent - Performing in an agile, self-directed team environment
Apply at Constant Contact

Posting record

Report an error

Actively hiringFirst seen by us today, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 11, 2026today
Recorded sightings
1

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 0

Early. Similar jobs usually come down between day 6 and day 55.

At Constant Contact, jobs usually come down by about day 48.

From 12,766 similar postings that came down, and 7 of Constant Contact’s. Coming down is not always a hire.

Constant Contact is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Java
  • Python
  • Scala
  • SQL
  • AWS
  • BigQuery
  • dbt
  • Delta Lake
  • GCP
  • Hive
  • Iceberg
  • Kubernetes
  • S3
  • Snowflake
  • Spark
  • Terraform
  • Trino
  • Airflow
  • Dagster
Where the posting names them
- Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes. - Hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python - In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
- Need to have professional knowledge of cloud platforms like AWS, GCP, etc. - Developing ETL pipelines in and out of data the warehouse using but not limited to Python, Scala,SnowSQL, etc. - Own orchestration patterns in Dagster: asset-based pipelines, code-location design, cross-asset lineage, sensors and schedules, partitioning and backfills.
Who you are: - 12+ years of experience working with data in the following ways: SQL development, Shell Scripting, Python, Snowflake, AWS, software engineering or database development - Ideal candidate has led platform architecture for a multi-team data organization
- Architecting 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. - Finalize preferred solution alternative working with IT and Business stakeholders to build data ingestion pipeline using tools like AWS EMR, Snowpipe, AWS DMS, etc.etc
- 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. - Finalize preferred solution alternative working with IT and Business stakeholders to build data ingestion pipeline using tools like AWS EMR, Snowpipe, AWS DMS, etc.etc - Need to have professional knowledge of cloud platforms like AWS, GCP, etc.
- Finalize preferred solution alternative working with IT and Business stakeholders to build data ingestion pipeline using tools like AWS EMR, Snowpipe, AWS DMS, etc.etc - Need to have professional knowledge of cloud platforms like AWS, GCP, etc. - Developing ETL pipelines in and out of data the warehouse using but not limited to Python, Scala,SnowSQL, etc.
What you'll do: - Architecting 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.
- Own orchestration patterns in Dagster: asset-based pipelines, code-location design, cross-asset lineage, sensors and schedules, partitioning and backfills. - Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes. - Hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python
- Experience with large-scale data sets using both structured and unstructured data - 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
- Performing in an agile, self-directed team environment - Nice to have: experience with semantic layers (Cube, dbt Semantic Layer), data catalogs, ML/identity resolution, marketing or ad-tech data, and big data - Experience with billing data and systems is a big plus
- In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles - Tune Trino for performance and cost: query planning, catalog configuration (Glue/Hive/REST), resource groups, and scaling on Kubernetes. - Set technical direction and write architecture decision records for review by peers and leadership.
- Strong data modeling: dimensional/Kimball, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants - Experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services - Bachelor or Master’s degree in Computer Science, Information Technology or Equivalent
- Developing ETL pipelines in and out of data the warehouse using but not limited to Python, Scala,SnowSQL, etc. - Own orchestration patterns in Dagster: asset-based pipelines, code-location design, cross-asset lineage, sensors and schedules, partitioning and backfills. - Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.

Your next step

Complete your application on job-boards.greenhouse.io. The employer’s form will show what is required.

Applying through Greenhouse

  • No account needed: the form is one page, with an “Autofill my application” option that reads your resume.
  • Greenhouse doesn’t read resumes over 2.5 MB, or details placed in a header, footer, text box, table or second column. The file still attaches, but a recruiter has to type you in by hand.

Already applied? Track this application

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 7% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 2. The fewest in a week was 834, the most 1,323, and the latest week had 1,323.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Job description

View original posting ↗

At Constant Contact, we are seriously awesome people who take ownership and make an impact by operating with the mindset, integrity and courage of a small business owner. There’s something so profoundly rewarding about knowing that your work is empowering people everywhere to pursue their dreams.  Here, we all play an integral part in helping business owners, entrepreneurs, non-profits and individuals to succeed by giving them all the help and tools they need to grow online. We’re energized by new challenges and new possibilities-and we’re just getting started!

The Enterprise Data Platform team is looking for a Principal Data Engineer to help revolutionize how we think about and deliver customer insights, playing an important role in the future success of the company.

The ideal candidate will be a platform evangelist, having a deep appreciation for the business as well as strong technical skills. You should be self-directed, a creative problem solver, and able to adjust to a fast-paced environment.  This position plays the important role of bridging the gap between our business stakeholders and our technical data teams.

What you'll do:

  • Architecting 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.
  • Finalize preferred solution alternative working with IT and Business stakeholders to build data ingestion pipeline using tools like AWS EMR, Snowpipe, AWS DMS, etc.etc
  • Need to have professional knowledge of cloud platforms like AWS, GCP, etc.
  • Developing ETL pipelines in and out of data the warehouse using but not limited to Python, Scala,SnowSQL, etc.
  • Own orchestration patterns in Dagster: asset-based pipelines, code-location design, cross-asset lineage, sensors and schedules, partitioning and backfills.
  • Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.
  • Hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python
  • In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles
  • Tune Trino for performance and cost: query planning, catalog configuration (Glue/Hive/REST), resource groups, and scaling on Kubernetes.
  • Set technical direction and write architecture decision records for review by peers and leadership.
  • Mentor engineers across distributed teams in the US and India, and raise the bar through code and design reviews.

Who you are:

  • 12+ years of experience working with data in the following ways: SQL development, Shell Scripting, 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
  • Experience with large-scale data sets using both structured and unstructured data
  • 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
  • Strong communication skills across both business and technical communities
  • Strong data modeling: dimensional/Kimball, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants
  • Experience with Kubernetes (EKS), infrastructure as code (Terraform/CDK), and containerized data services
  • Bachelor or Master’s degree in Computer Science, Information Technology or Equivalent
  • Performing in an agile, self-directed team environment
  • Nice to have: experience with semantic layers (Cube, dbt Semantic Layer), data catalogs, ML/identity resolution, marketing or ad-tech data, and big data
  • Experience with billing data and systems is a big plus

#LI-HK1 #LI-Remote

The specific salary offered to a candidate may be influenced by a variety of factors including the candidate’s experience, their education and work location. In addition, some roles may be eligible for additional on target commission pay or bonus. The compensation package includes health and welfare benefits including paid leave.

Pay Transparency - All Full Time Employees
$137,800—$172,250 USD

Why You’ll Love Us:

  • We celebrate one another’s differences. We are proud of our culture of diversity and inclusion, and we're always working hard to strengthen and improve this culture. We have programs in place that bring us together on important issues and provide educational opportunities for all employees. 
  • Join the experts. If you're passionate about supporting businesses and organizations, you won’t find a better spot to share your talent. We’re dedicated to improving the quality of our product from a customer standpoint and have a true desire to enable the success of businesses, non-profit organizations, and community groups.
  • You’ll have opportunities to grow your career. We encourage and support our team members to learn different aspects of the business, take on stretch assignments, seek coaching opportunities and professional development opportunities.
  • A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family

At Constant Contact, we’re all about work flexibility and are proud to serve our customers as a hybrid workforce. Our hybrid work model combines the convenience of remote work with access to our great office locations to collaborate in-person, participate in live trainings, and socialize with colleagues.

Application Deadline: 30 days. We may fill this job opening prior to the deadline if a candidate is selected by us.

Vision6 Pty Limited is an affiliate of Constant Contact, Inc. and a part of the Constant Contact group of brands.

Constant Contact is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, gender, gender identity, national origin, citizenship, age, disability, sexual orientation, genetic information, veteran status or any other status protected under applicable law. If you require accessibility assistance applying for open positions, please contact talentacquisition@constantcontact.com.

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Notice to Recruiters and Staffing Agencies:

Constant Contact has an internal talent acquisition department and designated career site for individuals looking to join our team. Constant Contact will not accept unsolicited resumes from any external recruiters, staffing firms, search agencies or any fee-based referrals. Any unsolicited resumes sent to directly to Constant Contact, in any capacity will be considered property of Constant Contact. Constant Contact will not pay a fee for any placement resulting from the receipt of an unsolicited resume.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Pay Transparency - All Full Time Employees $137,800—$172,250 USD Why You’ll Love Us:
Location & working pattern

Remote, US or Remote, Ontario, Canada

- Experience with billing data and systems is a big plus #LI-HK1 #LI-Remote The specific salary offered to a candidate may be influenced by a variety of factors including the candidate’s experience, their education and work location. In addition, some roles may be eligible for additional on target commission pay or bonus. The compensation package includes health and welfare benefits including paid leave.
More source context
- A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family At Constant Contact, we’re all about work flexibility and are proud to serve our customers as a hybrid workforce. Our hybrid work model combines the convenience of remote work with access to our great office locations to collaborate in-person, participate in live trainings, and socialize with colleagues. Application Deadline: 30 days. We may fill this job opening prior to the deadline if a candidate is selected by us.
Work authorization

This passage needs a closer read in the full description.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.