snowflake Solution Architect

LIVEMINDZ SERVICES INC
Memphis, TN, United States
1 day ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Business Intelligence Development Cloud Computing Continuous Integration Data Architecture Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Security Data Sharing
+20 more
Data Warehousing DevOps Dimensional Modeling Python (Programming Language) Performance Tuning Query Optimization Role-Based Access Control Power BI Cloud Services SQL Databases Tableau (Software) Enterprise Data Management Google Cloud Sql Optimization Snowflake Database Optimization Git Star Schema Data Pipelines Databricks

Job description

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., * 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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…