Principal Architect - R01571497

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

Principal Architect

15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms

Core Technical Skills

• DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
• Snowflake Engineering: Principal Data Architect

Key Responsibilities

• Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives.
• Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation.
• Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe.
• Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability.
• Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows.
• Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives.
• Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime.
• Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals.

Required Skills

• Expertise in Snowflake architecture and engineering
• Advanced proficiency in SQL
• Strong experience with Python for data processing and automation
• Deep understanding of ETL pipeline development
• Hands-on experience with Snowflake Streams for real-time data ingestion
• Proficiency in Time Travel and Fail Safe features within Snowflake
• Implementation and management of Snowpipe for automated data loading
• Skilled in SnowSQL for scripting and data management
• Experience in Snowflake-specific data modeling and warehouse design
• Expertise in developing and managing Snowflake stored procedures

Preferred Skills

• Experience integrating Snowflake with cloud platforms such as AWS or Azure
• Expertise in advanced data security and governance practices
• Knowledge of performance tuning and optimization for large-scale Snowflake workloads
• Familiarity with emerging data engineering technologies and frameworks
• Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)
• Hands-on experience with real-time analytics and streaming data solutions

Desired Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
• Snowflake SnowPro Advanced Architect certification or equivalent
• Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)