Similar Jobs
See allWhat 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.