What are the responsibilities and job description for the Snowflake Architect position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Akrivis Solutions, is seeking the following. Apply via Dice today!
Role: Snowflake Architect - W2
Location: Mount Juliet, TN (Only Local Candidates located within a 50-mile radius of the job location, Relocation will not work)
Duration: 6 Months (Contract)
Work Mode: Onsite
Qualifications:
Role: Snowflake Architect - W2
Location: Mount Juliet, TN (Only Local Candidates located within a 50-mile radius of the job location, Relocation will not work)
Duration: 6 Months (Contract)
Work Mode: Onsite
Qualifications:
- 7 years of experience in data engineering with strong hands-on expertise in Snowflake and Power BI
- Proven ability to design analytics-ready data models and enterprise BI solutions
- Deep understanding of ELT/ETL patterns, data warehousing concepts, and performance tuning
- Strong experience in Snowflake architecture design, including multi-cluster warehouses, workload isolation, and scaling strategies
- Expertise in designing layered data architectures (Bronze/Silver/Gold or Medallion) within Snowflake
- Hands-on experience with Snowflake features such as Snowpipe, Streams, Tasks, Time Travel, and Zero-Copy Cloning
- Strong knowledge of micro-partitioning, clustering, and pruning optimization for large-scale datasets
- Experience implementing data governance, RBAC, masking policies, row-level security, and secure data sharing in Snowflake
- Proven ability to optimize query performance and manage cost efficiency using warehouse sizing, caching, and query tuning techniques
- Experience 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 enrichment
- Familiarity with Snowpark and Snowflake-native application development for advanced data processing and ML workloads
- Exposure to Snowflake Native Apps / Snowlit (Snowflake app framework) for building and deploying data applications within the Snowflake ecosystem
- Understanding 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 calculations
- Proficiency in SQL and Python for data transformation and automation
- Experience with Azure Data Factory and cloud-based data ecosystems