Database Architect (Snowflake)

Cloud Brite Systems India Private Limited•Indianapolis, IN

3d•Hybrid

About The Position

The Database Architect is the technical authority for Snowflake data foundation: architecture, data modeling, governance, and performance engineering. This role sets the standards that the Data Engineer and Data Scientist roles build against, ensuring the platform stays secure, performant, and cost-disciplined as data volumes and use cases grow.

Requirements

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 or federal environment (FISMA/NIST 800-53).
Hands-on experience with dbt, Snowpipe, and Streams and Tasks for pipeline orchestration.

Nice To Haves

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: role-based access control, dynamic data masking, row-level security, data lineage, and cataloging aligned to FISMA and NIST SP 800-53.
Lead performance and cost engineering: warehouse right-sizing, clustering, materialized views, and workload isolation.
Set standards and review designs for the multi-source ingestion pipelines (Snowpipe, Streams and Tasks, dbt) built by the Data Engineering team.
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.