Overview
On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - Contract
Skills
sql
BEST PRACTICES
ORACLE
ANSI
Stored Procedures
Data Pipelines
GCP
Performance Tuning
MS SQL Server
Apache Airflow
Dimensional Data
ODS
ER Studio
Erwin
Job Details
Job Title: Snowflake Architect
Job Location: Pittsburgh, PA
Job Type: Contract
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
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.