Snowflake Data Architect – Governance & Performance

Brite Systems; United States; Hybrid; USD 140,000 - 210,000; Full time

Job summary

Brite Systems, Inc. in the United States is seeking a Database Architect to govern Snowflake data foundations, data modeling, and security. You will set standards used by Data Engineers and Data Scientists to keep the platform secure, performant, and cost-conscious as data volumes grow.

This role demands design of multi-source architectures, governance controls, and efficient data pipelines using Snowpipe, dbt, and Streams and Tasks, with exposure to MuleSoft and AWS encryption patterns.

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 SP 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.
• 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 Integration Engineers on Snowpark in-platform transformation to minimize 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

Data architecture

Security governance

Snowflake

DBT

Snowpipe

Streams and Tasks

MuleSoft

KMS encryption

Regulatory compliance

Education

Bachelor’s degree in Computer Science or related field

SnowPro Core Certification

SnowPro Advanced Architect Certification

Tools

Snowflake

dbt

Snowpipe

Streams and Tasks

MuleSoft

AWS KMS

Job description

Brite Systems, Inc. in the United States is seeking a Database Architect to govern Snowflake data foundations, data modeling, and security. You will set standards used by Data Engineers and Data Scientists to keep the platform secure, performant, and cost-conscious as data volumes grow.

This role demands design of multi-source architectures, governance controls, and efficient data pipelines using Snowpipe, dbt, and Streams and Tasks, with exposure to MuleSoft and AWS encryption patterns.