snowflake Solution Architect
Posted Updated
Description
Job Title: Senior Snowflake Solution Architect
Experience: 12+ Years
Location: Memphis TN
Employment Type: Full-Time
Experience: 12+ Years
Location: Memphis TN
Employment Type: Full-Time
Job Summary
We are looking for an experienced Senior Snowflake Solution Architect to lead the design, architecture, and implementation of enterprise-scale cloud data solutions using Snowflake. The ideal candidate will have strong expertise in Snowflake architecture, data warehousing, cloud data platforms, data integration, and modern data engineering practices.
The candidate will be responsible for defining enterprise data architecture, developing scalable and secure data solutions, optimizing Snowflake performance, and providing technical leadership across data engineering and analytics initiatives.
Key Responsibilities
- Design and implement scalable, high-performance data warehouse solutions using Snowflake.
- Define enterprise data architecture, technical standards, and best practices.
- Lead Snowflake implementation, migration, modernization, and integration initiatives.
- Design and optimize complex data models, including Star Schema, Snowflake Schema, and dimensional modeling.
- Develop and oversee ELT/ETL pipelines for integrating data from multiple enterprise sources.
- Implement Snowflake features such as Virtual Warehouses, Streams, Tasks, Snowpipe, Dynamic Tables, and Time Travel.
- Establish data security, governance, access controls, RBAC, and data-sharing strategies.
- Perform query optimization, workload management, performance tuning, and cost optimization.
- Integrate Snowflake with cloud platforms such as AWS, Azure, or Google Cloud Platform.
- Collaborate with business stakeholders, data engineers, BI developers, and enterprise architects.
- Provide technical guidance, architecture reviews, and mentorship to development teams.
- Ensure data quality, reliability, scalability, and availability across enterprise data platforms.
Required Technical Skills
- Extensive experience with Snowflake architecture and enterprise data warehousing.
- Strong expertise in SQL, advanced SQL, and database performance tuning.
- Hands-on experience with Snowflake administration and optimization.
- Strong knowledge of ETL/ELT pipelines and data integration.
- Experience with dimensional modeling, data modeling, and data warehouse design.
- Knowledge of cloud platforms – AWS, Azure, or Google Cloud Platform.
- Experience with Python and data engineering frameworks.
- Strong understanding of data governance, security, RBAC, and data access management.
- Experience with Snowflake migration and modernization projects.
Preferred Skills
- Experience with Snowflake and Databricks integration.
- Knowledge of dbt, Informatica, Matillion, Fivetran, or similar data integration tools.
- Experience with Power BI, Tableau, or other BI platforms.
- Knowledge of CI/CD, Git, and DevOps practices.
- Experience with enterprise MDM and data governance.
- SnowPro Advanced or SnowPro Core certification.
Skills
Sign in to read and join the discussion.