Database Architect (Snowflake)

Brite; Washington (District of Columbia); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Brite Systems Inc. is seeking a Database Architect to own the Snowflake data foundation, data modeling, governance, and performance engineering.

You will set standards used by Data Engineers and Data Scientists to keep the platform secure, scalable, and cost-efficient as data workloads grow. The role requires 8+ years in enterprise data architecture with Snowflake focus, and strong experience with governance controls and dbt, Snowpipe, Streams and Tasks.

Qualifications

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

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, cataloging aligned to FISMA/NIST SP 800-53.
• Lead performance and cost engineering: warehouse right-sizing, clustering, materialized views, workload isolation.
• Set standards and review designs for multi-source ingestion pipelines (Snowpipe, Streams and Tasks, dbt).
• Partner on Snowpark in-platform transformation to minimize data movement.
• Design MuleSoft ingestion patterns using Snowpipe, Streams & Tasks and staging tables.
• Implement Secure Data Sharing, External Functions and REST API enablement for MuleSoft.
• Design secure views, Dynamic Data Masking and Row-Level Security.

Skills

Snowflake

Governance & Security

dbt

Security controls

Education

Bachelor's degree in Computer Science / Data Engineering

SnowPro Core certification

SnowPro Advanced Architect certification

Tools

dbt

Snowpipe

Streams & Tasks

S3 External Stages

AWS KMS

Job description

Brite Systems Inc. is a U.S.-based, AI-led digital transformation company. Since 2006, we have helped government and nonprofit organizations modernize their technology, improve operations, and deliver better outcomes for the communities they serve.

Headquartered in Indianapolis, Brite brings together expertise across Salesforce, AWS, MuleSoft, AI, and our proprietary Enlite Accelerator to solve complex challenges and create meaningful impact.

At Brite, you’ll be part of a collaborative, people-first team where innovation, continuous learning, and meaningful work come together. We’re proud to be recognized among Indiana’s fastest-growing companies, named to the Inc. 5000 list of America’s fastest-growing private companies, and recognized as a Great Place to Work in Indiana for seven years.

Join Brite to build innovative technology, grow your career, and make a difference.

Job Description

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.

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.

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

Work Type

Remote / Hybrid (mostly work remote with occasional in-person meetings)

Brite Systems is an Equal Employment Opportunity and Affidiative Action Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender perception or identity, national origin, age, marital status, protected veteran status, or disability status.