Sr Snowflake Architect/Administrator

Sr Snowflake Architect/Administrator –financial services to join our  team in Charlotte, NC/ Jersey City , NJ/New York City, NY Duration long term.
Snowflake Architect/Administrator who will be responsible for planning, designing, developing, and maintaining the snowflake data architecture, data models and standards for various Data Integration Data Warehouse projects in snowflake. Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse. Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling. This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project.
• Design, develop and manage multiple snowflake accounts, complex technical projects and create high-level design and architecture of the solution, and infrastructure diagrams.
• Look out for newer and/or enhancements to existing features & capabilities in snowflake space, perform value-vs risk-based assessment, bring them into the company, incorporate into company’s systems and processes, and drive adoption.
• Establish Snowflake best practices for managing load operations and performance.
• Establish standards, dashboards and monitor snowflake accounts for user activities, credits consumptions, warehouses utilization, workloads etc.
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
• Review the architectural/ technological solutions for ongoing projects and ensure the right choice of solution(s) is implemented.
• Work closely with business teams to understand their business, capture requirements, identify pain areas, propose an ideal solution, and implement.
• Gather end user requirements, convert them into technical requirements and documentation.

Required:
• Must have at least 5+ years of experience working as a Snowflake Data Architect and 10+ years of experience in Data Warehouse, ETL, and BI projects area.
• Must have prior experience in end-to-end implementation of multi account Snowflake architecture, including deployment model.
• Data governance expertise in snowflake, including column-level data security, and dynamic data masking features.
• Expertise in design and development of secure access to objects in Snowflake with Role-Based Access Control (RBAC), including data access and functional roles.
• Expertise in deploying Snowflake features such as data sharing, zero copy cloning, streamlit, Snowpark, Stored procedures, materialized views etc.
• Expertise in recovery methods and agile development with Time Travel & Cloning.
• Experience in establishing CICD pipeline automation to deploy and manage snowflake code/objects using GitHub, Schema Change etc.
• Experience is setting up monitoring of snowflake accounts, including user activities, credits consumption, warehouses utilization, workloads etc.
• Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
• Experience in re-clustering of the data in Snowflake with good understanding of micro-Partitions.
• Experience in Data Migration from on premise RDBMS to Snowflake cloud data warehouse.
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling).
• Experience with AWS data storage and management technologies such as S3, EC2, Lambda, Redshift, RDS.
• Certified Snowflake Architect (Desirable).
• Should be able to troubleshoot problems across infrastructure, platform, and applications.
• Must have experience of Agile development methodologies.
• Strong verbal and written communication skills.