Database Architect (Snowflake).

About Brite Systems

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)

Equal Employment
Opportunity

Brite Systems is an
Equal Employment Opportunity and Affirmative 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.

Recruitment Fraud
Alert! There has been an increase in fraud that targets job seekers. Scammers
may present themselves to job seekers as Brite Systems employees or recruiters.
Please be aware that Brite Systems does not request sensitive personal data from
applicants via text/instant message or any unsecured method; does not promise
any advance payment for work equipment set-up; and does not use recruitment or
job-sourcing agencies that charge candidates an advance fee of any kind. We
encourage you to review and apply to our available job openings at Brite
Systems website. For more information on avoiding and reporting scams, please
visit the Federal Trade Commissions job scams website.