Snowflake Architect - Pittsburgh, PA - Hybrid

  • Pittsburgh, PA
  • Posted 5 days ago | Updated 5 days ago

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

snowflake
DBT
ERWIN
ODS
Redshift
GCP Bigquery

Job Details

Hi,

Position: Snowflake Architect

Location: Pittsburgh, PA

Duration: Long Term

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

Desirable

Good to have development experience with Apache Airflow

Skills

Mandatory Skills : ERWIN,MS SQL Server, TOAD Data Modeler, Data Vault (ODS) Modelling, ANSI-SQL, Dimensional Data Modelling, ER Studio, Microsoft Fabric, Google Cloud Platform Big Query, Redshift, Snowflake, Databricks, TOAD Snowflake dbt Oracle PLSQL

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.