Principal Architect
at Brillio 2
Austin, Texas, United States, hybrid, senior, full time, 15–18 years
seen 32d ago
- T-SQL
- Azure
- SnowSQL
- Snowflake Streams
- Snowpipe
- SQL
- Apache Airflow
- PL/SQL
- Stored Procedures
- Snowflake
- dbt
- Data Warehousing
- ETL
- AWS
- Python
About the role
Austin, Texas, United States
AI & Data Engineering – AI & Data Engineering : Data Engineering /
Employee /
Hybrid
apply for this job
Principal Architect
What they are looking for
* 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
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.
* 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
Read from jobs.lever.co, last seen 5d ago.