Constant Contact
More roles at Constant ContactPrincipal Data Engineer
Remote work allowed only within certain countries or regions.
Employer listed it 8 days ago · Added 6 days ago
First listed 8 days ago and still open.
Salary
$137,800 to $172,250
Location
Timezone
US East
Contract
Full-time
Experience
Lead
Category
Data
Stated by the employer in the job description
What the advert says
Quoted word for word from the employer's advert. Where it says nothing, we say so.
- Working hours
- Not mentioned in the advert
- Where you can work from
At Constant Contact, we’re all about work flexibility and are proud to serve our customers as a hybrid workforce.
- Contract
Pay Transparency - All Full Time Employees
- Experience asked for
12+ years of experience working with data in the following ways: SQL development, Shell Scripting, Python, Snowflake, AWS, software engineering or database development
- Pay
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.
Remote flexibility
Region Restricted
Remote work is allowed, but only for candidates based in United States, Canada.
What the employer says
- Source listing states candidate location: "Remote, US or Remote, Ontario, Canada, Remote - Ontario, Remote - US"
- Job description states: "US and India, and raise the bar th"
What Nomaders makes of it
- Timezone overlap with the listed area is often expected
The quotes above are the employer's own words; the reading is ours. Always check the original listing and employment terms before working from another country.
Before you apply
Experience: employer states
Written as a requirement
- “Production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark”
Written as a nice-to-have
- “Nice to have: experience with semantic layers (Cube, dbt Semantic Layer), data catalogs, ML/identity resolution, marketing or ad-tech data, and big data”
Produced automatically from this advert's text; not reviewed by a person. The employer's own page is the final word.
About the role
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
Requirements
- ·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
Benefits
No benefits package published with this listing. Ask about it at first interview.
How to apply
- 1Check the flexibility label above, region restricted, matches where you plan to live and work.
- 2Tailor your CV to the role at Constant Contact, mentioning your remote working experience and working hours (US East).
- 3Apply directly on the employer's careers page using the button below. Nomaders never handles your application.
Found 7d ago. Last checked 17 Nov. Always confirm the details on the original posting, salary and location can change after publication.
Listing sourced from Company boards.
Similar roles
Other open data roles with comparable remote rules.
$137,800 to $172,250 · You'll be taken to the employer's careers page.