Skip to content
Brillio 2 Company logo on Dataaxy
Brillio 2

Principal Architect

Original listing title: Principal Architect - R01571497

Data Engineering
Austin, Texas, United StatesHybridEmployee

About this role

Principal Architect

Primary 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

Specialization

  • Snowflake Engineering: Principal Data Architect

Job requirements

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

 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)

    •  

     

    Explore related Data & AI jobs

    Compare this role with data engineer jobs and open roles at Brillio 2.

    You can also browse all Data & AI jobs to find similar openings by category, seniority, remote setup, and location.

    © Dataaxy. All rights reserved.Job data is gathered from publicly available sources or contributed by users.