Snowflake Architect

Role: Snowflake ArchitectLocation: Mount Juliet, TNDuration: 6 Months (Contract)Qualifications:7+ years of experience in data engineering with strong hands-on expertise in Snowflake and Power BIProven ability to design analytics-ready data models and enterprise BI solutionsDeep understanding of ELT/ETL patterns, data warehousing concepts, and performance tuningStrong experience in Snowflake architecture design , including multi-cluster warehouses, workload isolation, and scaling strategiesExpertise in designing layered data architectures (Bronze/Silver/Gold or Medallion) within SnowflakeHands-on experience with Snowflake features such as Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy CloningStrong knowledge of micro-partitioning, clustering, and pruning optimization for large-scale datasetsExperience implementing data governance, RBAC, masking policies, row-level security, and secure data sharing in SnowflakeProven ability to optimize query performance and manage cost efficiency using warehouse sizing, caching, and query tuning techniquesExperience with Snowflake Cortex / AI & "super intelligence" capabilities for enabling AI-driven data applications, including use of built-in LLM functions, vectorized data access, and intelligent data enrichmentFamiliarity with Snowpark and Snowflake-native application development for advanced data processing and ML workloadsExposure to Snowflake Native Apps / Snowlit (Snowflake app framework) for building and deploying data applications within the Snowflake ecosystemUnderstanding of unstructured data handling and AI/ML integrations within Snowflake (e.g., document processing, embeddings, vector search)Experience building and optimizing Power BI dashboards, semantic models, and DAX calculationsProficiency in SQL and Python for data transformation and automationExperience with Azure Data Factory and cloud-based data ecosystemsAbility to translate business requirements into scalable data models and actionable insights