Snowflake Architect

**Snowflake Architect - R01520465**:
**About Brillio**:
**Snowflake Architect**

**Primary Skills**:

- SQL, Snowflake

**Job requirements**:

- ** Key Accountability**:

- Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence, and deployment infrastructure diagrams
- Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects
- Experience with gathering end user requirements and writing technical documentation.
- Time management and multitasking skills to effectively meet deadlines under time-to-market pressure.
- Suggest innovative solutions based on new technologies and latest trends to sales team.
- Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution.
- Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution and win business.
- ** Key Competencies**:

- Must have total 12+ yrs. in IT and 3+ years’ experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects.
- Must have experience at least two end-to-end implementation of Snowflake cloud data warehouse.
- Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored procedures and standard DWH and ETL concepts.
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features.
- Expertise in deploying Snowflake features such as data sharing, events, and lake-house patterns.
- Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python.
- Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling)
- Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.
- Experience with data security and data access controls and design
- Experience with Azure data storage and management technologies such as ADLS
- Build processes supporting data transformation, data structures, metadata, dependency and workload management.
- Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot.
- Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
- Must have expertise in Azure Platform as a Service (PAAS)
- Certified Snowflake cloud data warehouse Architect (Desirable)
- Must have experience of Agile development methodologies.
- Strong written and communication skills.
- Effective and persuasive in both written and oral communication.
- ** Nice to have skills**:

- Architect level certification from AWS / Azure / GCP
- Experience being part of Snowflake Practice/COE
- Data Science / AI ML implementation

Know what it’s like to work and grow at Brillio: Click here