10 years of experience in data architecture, analytics, design, and development
Expertise in Snowflake DW architecture and design
Proficient in data management including Governance and Metadata Management
Strong analytical and problem-solving skills
Proficient in SQL scripting and data modelling
Experience in Agile methodologies and client-facing roles
Responsibilities
Architect and design Snowflake DW on AWS, Azure, or GCP
Lead technical decisions on Snowflake features
Develop data management architectures for batch and real-time streaming
Design and maintain data architecture and models for integration projects
Automate data pipelines with modern methodologies
Document data architecture, flows, and models
Propose solutions for data pipeline issues
Benefits
Opportunities for professional development and training
Collaborative work environment with interdisciplinary teams
Exposure to cutting-edge cloud technologies
Engagement with diverse data integration and warehousing projects
Involvement in client-facing roles and consulting opportunities
Full Job Description
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.
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
