Principal Architect - R01571497

Brillio • Austin, TX

5d

About The Position

We are seeking a highly skilled Principal Architect with extensive expertise in Snowflake and modern data platforms. This role involves designing, developing, and optimizing scalable, secure, and high-performance data solutions to drive enterprise data initiatives. You will lead the modeling and structuring of complex data warehouses, implement robust ETL pipelines, and mentor junior team members. This is an opportunity to work with cutting-edge data technologies and contribute to critical business objectives.

Requirements

• 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
• 15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms

Nice To Haves

• 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

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Principal