Snowflake Data Architect — Cloud Data Platform Lead

Capgemini; New York (NY); Hybrid; USD 111,000 - 131,000; Full time

Benefits offered by this job

401(k) plan

Paid time off

Medical, dental, vision insurance

Life and disability insurance

Retirement savings plans

Job summary

Capgemini is seeking an accomplished data platform architect to design and implement scalable Snowflake architectures in a hybrid US environment. You will define standards, governance, and best practices while guiding ETL/ELT pipelines and data ingestion frameworks across AWS, Azure, and GCP.

You'll mentor teams, collaborate with stakeholders, and optimize performance, cost, and security across the data platform, enabling data-driven business outcomes.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or 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.

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 architecture

Data warehousing

SQL

ETL/ELT

Cloud platforms

Infrastructure as Code

DevOps / CI/CD

Leadership / Stakeholder mgmt

Education

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

Tools

Terraform

CI/CD pipelines

Snowflake

AWS/Azure/GCP

Job description

Capgemini is seeking an accomplished data platform architect to design and implement scalable Snowflake architectures in a hybrid US environment. You will define standards, governance, and best practices while guiding ETL/ELT pipelines and data ingestion frameworks across AWS, Azure, and GCP.

You'll mentor teams, collaborate with stakeholders, and optimize performance, cost, and security across the data platform, enabling data-driven business outcomes.