Snowflake Architect

Snowflake Architect

Raleigh, NC

USC & GC Only

Need 10 Years experienced consultants

Must Have Skills

1: Snowflake

2: Datawarehouse Concepts

3: Azure Cloud

4: Data Pipelines and ETL/ELT pipelines

Job Description

• Strong experience in building data warehouse, data lake, and data mart end-to-end implementation experience focusing on large enterprise scale implementations & Snowflake implementations on Azure Components.
• Able to create high level and low-level design documents based on the requirement of snowflake
• Strong experience with building productionized data ingestion and processing data pipelines in Snowflake.
• Strong experience on cloud data warehouses like Databrick platform, Azure synapse etc.
• Proficiency in data warehouse and Insights design patterns on cloud, consulting ability and solution design experience.
• Deep technical knowledge on Snowflake migration Strategy, automation of migration from other source system to Snowflake and provide optimal solution approaches customer requirements.
• Prior experience in interactions with Customer Architects and Team/Delivery leaders and vendor teams.
• Independently create the design and data modelling. Implementing network policy and data security, cost optimization, resource monitoring by applying Snowflake best practices.
• Have experience performing some DBA activities in Snowflake like user management, virtual warehouse management etc.
• Snowflake SnowPro Advanced Architect or Core Certification will be an added advantage.

Responsibilities

• Total exp should be 10 Years & 3-5 years of practical Snowflake experience as Architect.
• Strong understanding on Business and technical problem, Analyzing and end-to-end technical architecture including solution strategy & design covering large scale data transformation and performance and other non-functional needs.
• Strong knowledge, proficiency in Snowflake features, analytical processing, ETL/ELT tools (Azure Synapse & ADF) frameworks and data models.
• Familiarity/experience in any one of the programming languages Python.
• Familiarity with data warehouse concepts like Identity and access management
• Scheduling/orchestration, logging/monitoring, data security & encryption.
• Fair understanding of agile and DevOps concepts/methodology, processes like CI/CD Thought leadership in realm of cloud data services.
• Create POCs, roadmaps, solution architecture, estimations & implementation plan
• Experience for Snowflake integrations with other data processing
• Mentoring team for Snowflake skillsets
• Familiarity/experience in Data Governance