Snowflake Architect

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

Overview

Title: Snowflake Architect

Location: Pittsburgh, PA (Hybrid)

Open for: C2C, 1099 and W2

Base pay range

$70.00/yr - $80.00/yr

Job Description

12+ years experience in design and implementation of scalable secure and high performance snowflake architectures

Strong handson experience in developing and managing end to end data pipelines with Snowflake and dbt

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 modelling storage and transformation

Strong proficiency in dbt Data Build Tool for transformation and modelling

Extensive experience and deep understanding of Oracle PLSQL including performance tuning indexing stored procedures packages and triggers

Good to have development experience with Apache Airflow

Qualifications

• 12+ years experience in design and implementation of scalable secure and high performance snowflake architectures


• Strong handson experience in developing and managing end to end data pipelines with Snowflake and dbt


• 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 modelling storage and transformation


• Strong proficiency in dbt Data Build Tool for transformation and modelling


• Extensive experience and deep understanding of Oracle PLSQL including performance tuning indexing stored procedures packages and triggers


• Good to have development experience with Apache Airflow

Get notified about new Architect jobs in Pittsburgh, PA.