Snowflake Data Architect (Remote)

Cloud Brite Systems India Private Limited; United States; Hybrid; USD 140,000 - 210,000; Full time

Job summary

Cloud Brite Systems India Private Limited seeks a Database Architect to lead Snowflake data foundation design and governance. You will set standards for architecture, data modeling, security, and cost efficiency as data volumes grow.

The role focuses on building robust, scalable Snowflake environments, implementing secure data sharing, pipelines with Snowpipe/Streams/Tasks, and collaborating with data engineers and MuleSoft teams to deliver compliant solutions.

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, or a related field.
• 8+ years of enterprise data architecture experience, including 3+ years focused specifically on Snowflake.
• SnowPro Core certification required; SnowPro Advanced Architect certification strongly preferred.
• Demonstrated experience implementing governance and security controls in a regulated environment (FISMA/NIST 800-53).
• Hands-on experience with dbt, Snowpipe, and Streams and Tasks for pipeline orchestration.
• Federal contracting experience preferred.

Responsibilities

• Design the target-state Snowflake architecture and data model for consolidating on-premise and cloud data sources.
• Define and enforce governance and security controls: RBAC, dynamic data masking, row-level security, data lineage, and cataloging aligned to FISMA/NIST 800-53.
• Lead performance and cost engineering: warehouse right-sizing, clustering, materialized views, and workload isolation.
• Set standards and review designs for multi-source ingestion pipelines (Snowpipe, Streams and Tasks, dbt).
• Partner with the Integration Engineers on the Snowpark in-platform transformation approach that eliminates redundant data movement.
• Serve as designated Key Personnel and be available for interview prior to award.
• Design MuleSoft ingestion patterns using Snowpipe, Streams & Tasks and staging tables.
• Implement Secure Data Sharing, External Functions and REST API enablement for MuleSoft consumption.
• Implement secure views, Dynamic Data Masking and Row-Level Security.
• Design S3 External Stages and AWS KMS encryption patterns.
• Define staging formats including Parquet, JSON and ORC.

Skills

Snowflake architecture

dbt

Snowpipe

MuleSoft

Data governance

Security controls

KMS encryption

FISMA/NIST controls

Education

Bachelor's degree in Computer Science / Data Engineering

Tools

Snowflake

Snowpipe

Streams & Tasks

dbt

S3

AWS

KMS

Job description

Cloud Brite Systems India Private Limited seeks a Database Architect to lead Snowflake data foundation design and governance. You will set standards for architecture, data modeling, security, and cost efficiency as data volumes grow.

The role focuses on building robust, scalable Snowflake environments, implementing secure data sharing, pipelines with Snowpipe/Streams/Tasks, and collaborating with data engineers and MuleSoft teams to deliver compliant solutions.