Cloud Data Architect | Snowflake & AWS Lead with DBT

Overture Partners; Edison (NJ); On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical (choice of 3 plans)

401(k) starting on day one

Variety of voluntary benefits including life and disability insurance

Sick time if required by law

Job summary

Overture Partners is seeking a skilled Data Architect to lead the design and evolution of its modern data ecosystem. The ideal candidate will have 5-6 years of experience in data architecture and a strong background in AWS-based services, Snowflake, and DBT. The role requires collaboration with cross-functional teams to translate business requirements into scalable data solutions, ensuring reliable data access for analytics and reporting. Eligible W2 employees will receive comprehensive benefits including medical plans and a 401(k) starting on day one.

Qualifications

• 5-6 years of experience in data architecture, data engineering, or analytics roles.
• Strong expertise in cloud data platforms, particularly AWS-based services.
• Proven experience designing and managing data warehouses using Snowflake.
• Hands-on experience with DBT for data modeling and transformation workflows.
• Proficiency in SQL and experience with complex data modeling techniques.

Responsibilities

• Design and implement scalable data warehouse architectures to support business intelligence and analytics needs.
• Develop and optimize data models using modern transformation frameworks.
• Build and manage automated data pipelines to ensure consistent and reliable data ingestion.
• Collaborate with data engineers, analysts, and business stakeholders to define data solutions.

Skills

Data architecture

Cloud data platforms (AWS)

Snowflake

DBT

SQL

ETL/ELT pipelines

Python

Data governance

Job description

Overture Partners is seeking a skilled Data Architect to lead the design and evolution of its modern data ecosystem. The ideal candidate will have 5-6 years of experience in data architecture and a strong background in AWS-based services, Snowflake, and DBT. The role requires collaboration with cross-functional teams to translate business requirements into scalable data solutions, ensuring reliable data access for analytics and reporting. Eligible W2 employees will receive comprehensive benefits including medical plans and a 401(k) starting on day one.