Role : Snowflake Architect Location : Remote Duration : Long Term Contract Job Summary: Experience Required: 8+ years in Data Engineering / Architecture Job Summary: We are seeking an experienced Snowflake Architect to lead the design, development, and optimization of data architecture solutions using Snowflake. The ideal candidate will have deep expertise in Snowflake Architecture and experience re-architecting legacy systems for cloud data platforms. You will also be responsible for building scalable ETL/ELT pipelines and ensuring seamless data migration from various sources to Snowflake. Key Responsibilities: 1. Snowflake Architecture & Design • Design and implement Snowflake architecture for scalable and secure data solutions. • Define and maintain the overall Snowflake platform strategy, including best practices for development, optimization, security, and cost management. • Lead Snowflake performance tuning, clustering, partitioning, and workload management. 1. Architectural Frameworks • Develop and apply data architecture frameworks and patterns to guide solution design and delivery. • Align architectural decisions with enterprise data strategy and business goals. • Create documentation for architectural decisions, technical standards, and data governance. 1. Snowflake Design & Modelling • Design data models (Dimensional, Star Schema, Snowflake Schema) tailored to business requirements. • Implement role-based access control (RBAC) and data masking policies in Snowflake. • Optimize storage, compute, and query performance using caching, materialized views, and clustering. 1. Data Migration • Lead end-to-end migration efforts from traditional data warehouses (e.g., Teradata, Oracle, SQL Server) or cloud platforms (e.g., Redshift, BigQuery) to Snowflake. • Plan and execute data validation, data profiling, and transformation logic as part of migration. • Automate data load processes and data quality checks post-migration. 1. Medallion / Delta Lake Pattern Implementation is Plus • Architect and implement Medallion architecture (Bronze, Silver, Gold layers) for data lakehouses using Snowflake or Delta Lake concepts. • Ensure data integrity, quality, and lineage across ingestion, transformation, and presentation layers. • Design streaming and batch ingestion pipelines that follow DataOps and Lakehouse principles. 1. Snowflake Re-Architecture • Evaluate current Snowflake implementations and propose re-architecture strategies to address scalability, cost, and performance bottlenecks. • Modernize legacy data pipelines, consolidate data marts, and refactor data models. • Lead re-platforming efforts with a focus on automation, modularity, and reusability. 1. ETL / ELT Data Pipelines • Design, build, and maintain ETL/ELT pipelines using tools like DBT, Talend, Matillion, Airflow, or native Snowflake features (Streams, Tasks, Snowpipe). • Integrate data from multiple sources including APIs, flat files, and streaming platforms. • Monitor, troubleshoot, and optimize pipeline performance and data latency. Preferred Qualifications: • Snowflake Architect Certification. • Experience with Delta Lake or Databricks ecosystem. • Knowledge of Python or Scala for data engineering tasks. • Familiarity with BI tools like Power BI, Tableau, or Looker.