We are seeking a highly experienced Senior Snowflake Data Architect with strong expertise in enterprise data architecture, analytics, data modeling, and modern cloud data platforms. The ideal candidate will have hands-on experience with Snowflake, advanced SQL, dimensional data modeling, ELT pipelines, BI enablement, and enterprise data integration.
Experience with Snowflake Cortex AI and modern AI/ML capabilities within the Snowflake platform is highly desirable. The architect will work closely with technical leaders and engineering teams to design scalable, analytics-ready data solutions and support the onboarding of enterprise data sources and business domains into Snowflake.
Primary Responsibilities
- Serve as a senior technical subject matter expert for Snowflake data architecture and enterprise analytics platforms.
- Design scalable and secure Snowflake architectures aligned with enterprise data and analytics requirements.
- Lead the onboarding and integration of enterprise systems and business domains into Snowflake.
- Design analytics-ready data models, dimensional models, semantic layers, and reusable data structures.
- Develop and optimize SQL queries, data transformations, views, and data processing workflows.
- Design and support ELT-based data pipelines for ingestion and transformation of enterprise data.
- Enable data consumption and reporting through BI platforms such as Power BI and Sigma.
- Develop semantic views and curated datasets to support analytics, reporting, and self-service BI.
- Integrate data from enterprise SaaS applications and other operational data sources.
- Evaluate architectural options, identify technical risks, and communicate key trade-offs to senior technical stakeholders.
- Establish and promote data architecture, modeling, governance, and development standards.
- Collaborate with data engineers, BI developers, platform architects, application teams, and other technical stakeholders.
- Evaluate and support emerging Snowflake AI capabilities, including Snowflake Cortex, where applicable.
- Contribute to technical documentation, architecture diagrams, data models, standards, and implementation guidelines.
Required Qualifications
- 7–10 years of experience in data engineering, data architecture, analytics, or related disciplines.
- 3+ years of hands-on experience working with Snowflake in enterprise environments.
- Strong expertise in Snowflake architecture, SQL, and cloud data warehousing.
- Strong understanding of relational data warehouse concepts and modern data architecture.
- Proven experience designing dimensional data models and semantic data layers.
- Experience designing and supporting ELT-based data pipelines.
- Experience integrating enterprise applications and SaaS data sources into analytics platforms.
- Experience enabling BI and analytics platforms such as Power BI or Sigma.
- Strong understanding of data integration, transformation, data quality, and analytics enablement.
- Strong analytical, problem-solving, communication, and collaboration skills.
Preferred Qualifications
- Hands-on experience with Snowflake Cortex AI and related Snowflake AI/ML capabilities.
- Experience with Salesforce Data Cloud / Data 360 and Salesforce data models.
- Experience with enterprise-scale Snowflake implementations involving multiple teams and business domains.
- Knowledge of modern data governance, data security, and data management practices.
- Experience with Snowflake performance optimization and cost management.
- Familiarity with modern data engineering and orchestration tools.
- SnowPro Core, SnowPro Advanced Architect, or other relevant Snowflake certifications.