Position: Snowflake Architect.Location: 100% Remote.Duration: Long Term.About the Job:As the
Snowflake Architect, you will be responsible for architecting, designing, and overseeing the implementation of a Snowflake DW on AWS, Azure or GCP. You will lead technical decisions on all aspects of Snowflake features. Additionally, you will develop data management architectures involving batch, micro-batch, and real-time streaming of data in both cloud and on-premises solutions; and own the architecture and design of Big Data Pipelines.
Responsibilities:- Deploy a fully operational data solution into production on Snowflake DW with technologies such as Microsoft Azure, Azure DevOps, Azure Data Factory, Azure Monitor, AWS, AWS S3, AWS Glue, AWS Kinesis.
- Utilize SnowSQL for command line, DDL, DML, and query syntax.
- Build modern approaches to automating data pipelines.
- Leverage code repositories and continuous integration tools.
- Work in interdisciplinary teams that combine technical, business and data science competencies.
- Be responsible for designing, developing and maintaining the data architecture, data models and standards for various Data Integration & Data Warehousing projects in Snowflake, combined with other technologies.
- Model new features and subject areas and integrate them with existing structures to provide a consistent solution as well as develop and maintain documentation of the data architecture, data flows and data models.
- Take ownership of technical solutions from design and architecture perspective, ensure the right direction and propose resolution to potential data pipeline-related problems.
Minimum Job Qualifications:- Snowflake DW Architecture and Design.
- 10 total years in data architecture, analytics, design, and development.
- Data Management experience including Data Governance, Master Data Management, Reference Data Management, and Metadata Management.
- Customer-facing experience in a consulting or delivery capacity.
- Analytical and problem-solving skills.
- Acute attention to detail.
- Experience with gathering end user requirements and writing technical documentation.
- Time management and multitasking skills to effectively meet challenging deadlines.
- Ability to suggest innovative solutions based on new technologies and latest trends.
- Proficiency in data modelling, very good understanding of data management concepts such as 3NF, Dimensional and their specific applications.
- Ability to write complex SQL scripts.
- Understanding troubleshooting aspects
- Understanding of data security and data access controls and design aspects
- Experience in Agile development methodologies.
- Excellent client facing and team player skills.
Nice to have:- NoSQL/Key-value, Data Vault 2.0 concepts knowledge
- Snowflake certification
