Similar Jobs

See all

What You'll Do:

  • Architect 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.
  • Set dbt standards for the enterprise data model: layering (staging/intermediate/marts), testing, documentation, and CI for model changes.

Who You Are:

  • 12+ years of experience working with data in SQL, Shell Scripting, Python, Snowflake, AWS, software engineering or database development.
  • Production experience with at least two of: Trino/Presto, Iceberg/Delta/Hudi, Dagster/Airflow, dbt, Spark.
  • Strong data modeling skills: dimensional/Kimball, conformed dimensions, slowly changing dimensions (SCDs), and modeling for multiple brands or tenants.

Why You’ll Love Us:

  • We celebrate one another’s differences and are proud of our culture of diversity and inclusion.
  • We offer opportunities to grow your career with stretch assignments, coaching, and professional development.
  • A generous paid time off policy and a competitive benefits package that supports the health and well-being of you and your family.

Constant Contact

Constant Contact empowers small businesses, entrepreneurs, and nonprofits to grow online with tools and support. With a culture of ownership and courage, the company values diversity and inclusion, offering a generous PTO policy and competitive benefits.

Apply for This Position