Snowflake Data Architect

PB Consulting

Spring, TX

Posted On: Sep 13, 2024

Posted On: Sep 13, 2024

Job Overview

Job Type

Contract - Independent, Contract - W2, Contract - Corp-to-Corp

Experience

5 - 10 Years

Salary

$62 - $66 Per Hour

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • Snowflake Architecture
  • SQL
  • Data warehousing
  • Data modeling
Job Description
Role and Responsibilities
  • The Snowflake Architect Should Develop analytics based solutions that produce quantitative and qualitative business insights
  • Work with partners as necessary to integrate systems and data quickly and effectively regardless of technical challenges or business environments
  • Lead effort to design build n configure applications acting as primary POC
  • Own end to end RFP or RFI or Proactive proposals client presentations n solution workshop Contribute in area ie estimation building PoVs offerings development training and capability building
  • Client facing role in term of running solution workshops client visits handled large RFP pursuits n managed multiple stakeholders
  • Deploy fully operational data warehouse solutions into production on Snowflake
  • Perform project management activities including project documentation business requirements and project tracking
  • Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix Python etc to do Extract Load and Transform data

 

Required Qualifications
  • Snowflake Architecture experience in designing and architecting Snowflake projects.
  • Expertise in Snowflake Data Modeling ELT using Snowflake SQL implementing stored procedures and standard DWHETL concepts
  • Clear understanding of Snowflakes advanced concepts like virtual warehouses query performance using micro partitions and pruning zero copy clone time travel resource monitors and security control methods including network data role based etc
  • Proficient with data platform architecture design data dictionaries multidimensional models objects star and snowflake schemas as well as structures for data lakes data science and data warehouses using Snowflake
  • Have a solid understanding of delivery methodology and lead teams in the implementation of the solution according to the design architecture
  • Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel Optimizer Metadata Manager data sharing and stored procedures
  • Experience in Data warehousing OLTP OLAP Dimensions Facts and Data modeling

Job ID: PC240378


Posted By

Naincy

Recruiter