Principal Data Engineer
Remote, US or Remote, Ontario, Canada
$138k–$172k a yearRemoteLead & above
Job details
- Remote, US or Remote, Ontario, Canada
- Remote
- $138k–$172k a year (posted by the company)
- Full-time · Lead & above
- 334 Data Intelligence
- Posted 5 days ago
Sponsorship history
Past filings by Constant Contact in public government data. Not a promise of sponsorship.
- Filed 3 H-1B LCAs in FY2025
Full job description
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.
