Data Architect

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

Job Overview

An organization is seeking a skilled Data Architect to lead the design and evolution of its modern data ecosystem. This role is critical in shaping scalable data strategies, optimizing cloud-based architectures, and enabling advanced analytics. Candidates with strong hands‑on experience across cloud platforms and data tooling will be prioritized for immediate consideration.

Must Haves

• 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
• Experience building and maintaining ETL/ELT pipelines and data integration processes
• Strong programming skills in Python for automation, scripting, or analytics
• Familiarity with data governance, data quality standards, and regulatory compliance frameworks

What the Client Needs You to Do

In this role, you will serve as a technical leader responsible for architecting and optimizing a robust, cloud‑based data environment. You will partner with cross‑functional teams to translate business requirements into scalable data solutions, ensuring reliable data access for analytics and reporting. Success in this role requires a balance of hands‑on development, strategic thinking, and collaboration with stakeholders across engineering and business teams.

Key Responsibilities

• Design and implement scalable data warehouse architectures to support business intelligence and analytics needs
• Develop and optimize data models using modern transformation frameworks to improve performance and usability
• Build and manage automated data pipelines to ensure consistent and reliable data ingestion from multiple sources
• Leverage cloud-based tools to perform data integration, transformation, and cataloging activities
• Collaborate with data engineers, analysts, and business stakeholders to define and deliver data solutions
• Establish and enforce data governance policies, including data quality, security, and compliance standards
• Monitor system health and performance, identifying opportunities for optimization and cost efficiency
• Support advanced analytics and machine learning initiatives through data preparation and infrastructure design
• Perform data migration and integration tasks across various database platforms as needed
• Stay informed on emerging trends and best practices in cloud data architecture and analytics technologies

Must have strong Data Lake, Snowflake Administration and ability to populate the Data Lake.

W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked‑in state/locality.

#25471