Snowflake Data Architect

Snowflake Architect

As a 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 include:

• Deployed 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.
• Utilized Snow SQL for command line, DDL, DML, and query syntax.
• Built modern approaches to automating data pipelines.
• Leveraged code repositories and continuous integration tools.
• Demonstrated experience with predictive analytics.
• 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.

Desired Experience:

• 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