Enterprise Solutions Inc

Snowflake DATA Architect

Spring Valley, TX 77024

Posted: 09/18/2024 Job Number: z5G7h3l6a1kMvyS65NP3c6xocgPL46Yr_qcOfURoroI= Pay Rate: 70-85 Hourly USD

Job Description


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

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

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

Clear understanding of Snowflakes advanced concepts like virtual warehouses query performance using micro partitions and pruning zero copy clone time travel resource monitors n security control methods including network data role based etc

He should be 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 Responsibilities will also include technical delivery review resolution of architecture issues and for the migration of the existing onpremises application to AWSAzure Snowflake platform

Demonstrate expertise in Snowflake data modeling and ELT using Snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts

Deploy fully operational data warehouse solutions into production on Snowflake

Have a solid understanding of delivery methodology and lead teams in the implementation of the solution according to the designarchitecture

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

Handson experience with Snowflake utilities such as SnowSQL SnowPipe Python Tasks Streams Time travel Optimizer Metadata Manager data sharing and stored procedures

Indepth understanding of Data WarehouseODS ETL concept and modeling structure principles

Experience in Data warehousing OLTP OLAP Dimensions Facts and Data modeling

Experience gathering and analyzing system requirements

Good working knowledge of any ETL tool

Ability to effectively function in a cross teams environment

Skills

Snowflake Architecture
Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Spring Valley, TX

Ready to take your career to new heights in Spring Valley, Texas? Named after its lush greenery and scenic views, Spring Valley offers a charming blend of suburban tranquility and urban convenience, making it an ideal place to live and work. With close proximity to Houston's vibrant culture, renowned museums like the Museum of Fine Arts, top-notch restaurants serving authentic Tex-Mex cuisine, and the energizing atmosphere of live performances at the Alley Theatre, this area has something for everyone. Join us in exploring job opportunities in this thriving community and discover the unique charm and endless growth possibilities that Spring Valley has to offer.