Senior Snowflake Architect — Data Platform Leader

Brillio 2; Austin (TX); On-site; USD 180,000 - 240,000; Full time

Job summary

Brillio 2 is seeking a Principal Architect to design and lead Snowflake data architectures and modern data platforms in Austin, TX. The role emphasizes scalable, high‑performance, secure data solutions that align with enterprise goals.

You will set standards for data quality, security, and governance across platforms. You will guide ETL development with Snowflake Streams, Snowpipe, Python and SQL, mentor junior engineers, and collaborate with cross‑functional teams to transform data into

Qualifications

• Snowflake architecture and engineering expertise.
• Advanced SQL proficiency.
• Strong Python for data processing and automation.
• Deep ETL pipeline development experience.
• Hands-on Snowflake Streams for real-time ingestion.
• Time Travel and Fail Safe features knowledge.
• Snowpipe for automated data loading.
• SnowSQL scripting and data management.
• Snowflake data modeling and warehouse design.
• Stored procedures development in Snowflake.

Responsibilities

• Design scalable Snowflake data solutions for enterprise data initiatives.
• Develop ETL pipelines using Snowflake Streams, Python, and SQL.
• Optimize Snowflake performance, cost, and reliability.
• Model and structure complex Snowflake data warehouses.
• Configure and manage SnowSQL and advanced SQL scripts.
• Collaborate with teams to define data platform requirements.
• Troubleshoot architectural and operational Snowflake issues.
• Mentor junior architects and engineers in Snowflake best practices.

Skills

Snowflake architecture

SQL

Python

ETL development

Data modelling

Time Travel & Fail Safe

Snowpipe

SnowSQL

Data Warehousing

Stored procedures

Education

Bachelor's degree in CS/IT/Data Engineering

Snowflake SnowPro Advanced Architect

Cloud data platform certifications (AWS/Azure)

Tools

Snowflake

Snowflake Streams

Snowpipe

SnowSQL

Apache Airflow

dbt

ETL tools

Job description

Brillio 2 is seeking a Principal Architect to design and lead Snowflake data architectures and modern data platforms in Austin, TX. The role emphasizes scalable, high‑performance, secure data solutions that align with enterprise goals.

You will set standards for data quality, security, and governance across platforms. You will guide ETL development with Snowflake Streams, Snowpipe, Python and SQL, mentor junior engineers, and collaborate with cross‑functional teams to transform data into