Snowflake Architect

Role: Snowflake Architect

Location: Mount Juliet, TN

Duration: 6 Months (Contract)

Qualifications:

• 7+ years of experience in data engineering with strong hands-on expertise inSnowflake and Power BI
• Proven ability to designanalytics-ready data models and enterprise BI solutions
• Deep understanding ofELT/ETL patterns, data warehousing concepts, and performance tuning
• Strong experience inSnowflake architecture design, including multi-cluster warehouses, workload isolation, and scaling strategies
• Expertise in designinglayered data architectures (Bronze/Silver/Gold or Medallion) within Snowflake
• Hands-on experience withSnowflake features such as Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning
• Strong knowledge ofmicro-partitioning, clustering, and pruning optimization for large-scale datasets
• Experience implementingdata governance, RBAC, masking policies, row-level security, and secure data sharing in Snowflake
• Proven ability tooptimize query performance and manage cost efficiency using warehouse sizing, caching, and query tuning techniques
• Experience withSnowflake Cortex / AI & "super intelligence” capabilities for enabling AI-driven data applications, including use of built-in LLM functions, vectorized data access, and intelligent data enrichment
• Familiarity withSnowpark and Snowflake-native application development for advanced data processing and ML workloads
• Exposure toSnowflake Native Apps / Snowlit (Snowflake app framework) for building and deploying data applications within the Snowflake ecosystem
• Understanding ofunstructured data handling and AI/ML integrations within Snowflake (e.g., document processing, embeddings, vector search)
• Experience building and optimizingPower BI dashboards, semantic models, and DAX calculations
• Proficiency inSQL and Python for data transformation and automation
• Experience withAzure Data Factory and cloud-based data ecosystems
• Ability to translate business requirements intoscalable data models and actionable insights