Principal Architect - R01571497

Lever, Inc.; Austin (TX); Sur place; USD 180 000 - 240 000; Plein temps

Résumé du poste

Lever, Inc. is seeking a Principal Architect to lead Snowflake data platform design and implementation. You will architect scalable, secure data solutions, define standards, and mentor the team.

You will collaborate with cross-functional partners, optimize performance and cost, and drive enterprise data initiatives using Snowflake, Python, SQL, and modern ETL pipelines.

Qualifications

• 15–18 years of experience in data architecture and engineering
• Expertise in Snowflake architecture and engineering
• Advanced SQL proficiency and Python for data processing
• Hands-on experience with Snowflake Streams and Snowpipe
• Experience designing scalable, secure Snowflake data warehouses

Responsabilités

• Design and architect scalable, secure Snowflake data solutions
• Develop and implement robust ETL pipelines with Python and SQL
• Optimize Snowflake for performance and cost using Time Travel, Fail Safe, and Snowpipe
• Lead data warehouse modeling and architecture for large-scale data platforms
• Configure SnowSQL scripts to automate data processing
• Collaborate with cross-functional teams to align data platform with business goals
• Troubleshoot and resolve Snowflake architecture and data pipeline issues
• Mentor junior architects and engineers on Snowflake best practices

Connaissances

Snowflake architecture

SQL

Python for data processing

ETL pipelines

Snowflake Streams

Time Travel

Fail Safe

Snowpipe

SnowSQL

Data modeling

Formation

Bachelor's degree in CS/IT/Data Eng

SnowPro Advanced Architect certification

Outils

dbt

Apache Airflow

Description du poste

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

• Experience Range: 15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms Key Responsibilities: 1. Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives 2. Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation 3. Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe 4. Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability 5. Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows 6. Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives 7. Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime 8. Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals Required Skills: 1. Expertise in Snowflake architecture and engineering 2. Advanced proficiency in SQL 3. Strong experience with Python for data processing and automation 4. Deep understanding of ETL pipeline development 5. Hands-on experience with Snowflake Streams for real-time data ingestion 6. Proficiency in Time Travel and Fail Safe features within Snowflake 7. Implementation and management of Snowpipe for automated data loading 8. Skilled in SnowSQL for scripting and data management 9. Experience in Snowflake-specific data modeling and warehouse design 10. Expertise in developing and managing Snowflake stored procedures Preferred Skills: 1. Experience integrating Snowflake with cloud platforms such as AWS or Azure 2. Expertise in advanced data security and governance practices 3. Knowledge of performance tuning and optimization for large-scale Snowflake workloads 4. Familiarity with emerging data engineering technologies and frameworks 5. Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt) 6. Hands-on experience with real-time analytics and streaming data solutions Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline 2. Snowflake SnowPro Advanced Architect certification or equivalent 3. Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate) Additional Information: Immediate joiner required