What are the responsibilities and job description for the Snowflake Architect position at HR Pundits Inc?
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