Senior Snowflake Data Architect - Hybrid

Capgemini; New Jersey; Hybrid; USD 111,000 - 131,000; Full time

Job summary

Capgemini in Whippany, NJ is seeking a seasoned Snowflake data architect to design and implement scalable data platform architectures across AWS/Azure/GCP. You will lead data modeling, ETL/ELT design, and governance to deliver enterprise-grade data solutions.

You will collaborate with stakeholders, mentor teams, and ensure secure, cost-efficient Snowflake deployments from Day 1, with onsite/hybrid work as required.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or a related field.
• 8+ years of experience in data warehousing, data architecture, and cloud data platforms.
• 5+ years of hands‑on experience with Snowflake architecture, administration, and implementation.
• Strong expertise in data modeling, ETL/ELT processes, and large‑scale data integration.
• Experience designing enterprise data solutions on AWS, Azure, or Google Cloud Platform.
• Strong knowledge of SQL, performance optimization, and data engineering best practices.
• Experience with Infrastructure as Code (Terraform, CloudFormation, ARM Templates, or equivalent).
• Familiarity with DevOps practices, CI/CD pipelines, and automated deployment frameworks.
• Excellent communication, leadership, and stakeholder management skills.

Responsibilities

• Design and implement scalable Snowflake data platform architectures.
• Define data warehousing standards, best practices, and governance frameworks.
• Architect ETL/ELT pipelines and data ingestion frameworks.
• Implement Snowpipe, Streams, Tasks, Dynamic Tables, and Data Sharing solutions.
• Integrate Snowflake with cloud platforms (AWS, Azure, GCP), data lakes, APIs, and enterprise applications.
• Optimize platform performance, workload management, and cost efficiency.
• Implement security controls including RBAC, data masking, and row-level security.
• Establish data quality, metadata, lineage, and governance practices.
• Provide technical leadership, mentor teams, and collaborate with stakeholders to deliver business-driven data solutions.

Skills

Snowflake data platform

Data modeling

ETL/ELT

SQL

Cloud data platforms

Governance

Leadership

Stakeholder management

Education

Bachelor's or Master's in CS/IT/Data Eng

Tools

Terraform

CloudFormation

ARM Templates

CI/CD pipelines

Job description

Capgemini in Whippany, NJ is seeking a seasoned Snowflake data architect to design and implement scalable data platform architectures across AWS/Azure/GCP. You will lead data modeling, ETL/ELT design, and governance to deliver enterprise-grade data solutions.

You will collaborate with stakeholders, mentor teams, and ensure secure, cost-efficient Snowflake deployments from Day 1, with onsite/hybrid work as required.