Senior Snowflake Architect - Hybrid Pittsburgh

Confidential; Pittsburgh (Allegheny County); Hybrid; USD 70,000 - 80,000; Full time

Job summary

A leading technology firm is seeking a Snowflake Architect in Pittsburgh, PA. The role requires 12+ years of experience in Snowflake architecture, with expertise in developing data pipelines and optimizing performance. Candidates should have proficiency in Oracle PLSQL and familiarization with tools like DBT and Apache Airflow. This position offers a hybrid work format and a competitive salary ranging between $70.00 to $80.00 per year.

Qualifications

• 12+ years of experience in design and implementation of scalable secure and high performance Snowflake architectures.
• Strong hands-on experience in developing and managing end to end data pipelines with Snowflake and DBT.
• Extensive experience and deep understanding of Oracle PLSQL, including performance tuning.

Responsibilities

• Perform architecture reviews and assess system design for scalability, maintainability, and performance.
• Analyze and optimize the performance of Snowflake stored procedures, queries, and overall workload.
• Ensure adherence to Snowflake best practices in data modeling, storage, and transformation.

Skills

Snowflake architecture design

End-to-end data pipelines with Snowflake

DBT Data Build Tool

Oracle PLSQL performance tuning

Apache Airflow development

Job description

A leading technology firm is seeking a Snowflake Architect in Pittsburgh, PA. The role requires 12+ years of experience in Snowflake architecture, with expertise in developing data pipelines and optimizing performance. Candidates should have proficiency in Oracle PLSQL and familiarization with tools like DBT and Apache Airflow. This position offers a hybrid work format and a competitive salary ranging between $70.00 to $80.00 per year.