Senior Snowflake Data Architect – AWS Cloud, Data Modeling

Capco Group; United States; On-site; USD 85,000 - 121,000; Full time

Job summary

Capco seeks a Senior Data Architect in Jersey City, NJ to design and maintain scalable cloud data platforms using Snowflake.

You will define how data is stored, integrated, secured, and used to support analytics, reporting, and strategic decisions. Collaborate with data engineers, developers, product managers, and business stakeholders to drive enterprise data models and architecture standards.

Qualifications

• Extensive experience designing and implementing enterprise data platforms and data warehouses.
• Snowflake architecture expertise including data modelling, performance optimisation, and cost management.
• Experience with dimensional modelling: Star Schema, Snowflake Schema, Data Vault 2.0.
• Advanced SQL skills for data transformation and complex modelling.
• Knowledge of enterprise data warehousing, analytics architecture, and integration patterns.
• Hands-on dbt for production pipelines and data transformation.
• Experience with workflow orchestration and tools like Airflow or Dagster.
• AWS cloud services familiarity and cloud data platform architecture.

Responsibilities

• Design and implement scalable, secure, high‑performing enterprise data architectures using Snowflake and AWS.
• Define enterprise data models, schemas, and standards (Star/Snowflake/Data Vault 2.0).
• Architect data ingestion, integration, and transformation with ETL/ELT tools (dbt, Airflow, Kafka).
• Ensure scalability, reliability, and cost efficiency of data platforms.
• Establish data governance, security, and access controls.

Skills

Advanced SQL

Enterprise data architecture

Data modelling

Stakeholder collaboration

Education

Bachelor's or Master's in Computer Science or Data Engineering

Tools

Snowflake

AWS

dbt

Airflow

Kafka

Sigma

Qlik

Job description

Capco seeks a Senior Data Architect in Jersey City, NJ to design and maintain scalable cloud data platforms using Snowflake.

You will define how data is stored, integrated, secured, and used to support analytics, reporting, and strategic decisions. Collaborate with data engineers, developers, product managers, and business stakeholders to drive enterprise data models and architecture standards.