Senior Snowflake Data Architect

Position Overview

We are seeking an exceptional Senior Snowflake Data Architect with 10+ years of experience. This role requires deep expertise in Snowflake optimization, extensive knowledge of enterprise data platforms, and proven ability to design and implement cost-effective, high-performance data solutions at scale. The ideal candidate will have hands-on experience with multiple data technologies and a track record of optimizing Snowflake consumption and performance.

Key Responsibilities

Snowflake Architecture & Optimization

  • Design and implement enterprise-scale Snowflake architectures with focus on performance and cost optimization
  • Optimize Snowflake warehouse configurations, including sizing, clustering, auto-suspend, and auto-resume strategies
  • Implement advanced performance tuning through query optimization, materialized views, and result caching strategies
  • Monitor and reduce Snowflake consumption costs through warehouse optimization and resource monitoring
  • Design multi-cluster warehouse strategies and workload management policies
  • Implement data sharing, secure views, and row-level security policies

Data Pipeline Development & Optimization

  • Architect and optimize end-to-end data pipelines for maximum efficiency and minimum latency
  • Redesign existing pipelines to reduce processing time and Snowflake compute consumption
  • Implement streaming and batch data ingestion patterns using Snowpipe and Kafka connectors
  • Design data transformation workflows using SQL, Python, and modern ETL/ELT patterns
  • Establish data quality frameworks and monitoring systems

Technical Leadership

  • Provide architectural guidance for data platform modernization initiatives
  • Lead migration efforts from legacy platforms (Oracle, Teradata, Netezza) to Snowflake
  • Define and enforce data architecture standards and best practices
  • Collaborate with stakeholders to align data architecture with business objectives
  • Mentor team members on Snowflake optimization techniques and best practices

Required Qualifications

Experience

  • 10+ years of progressive experience in data architecture and engineering roles
  • 5+ years of hands-on Snowflake experience with focus on optimization and performance tuning
  • Proven experience with at least 2-3 of the following platforms: Oracle, Teradata, Netezza, MS SQL Server, PostgreSQL
  • Demonstrated expertise in migrating from legacy data platforms to Snowflake
  • Experience with ETL/ELT tools including Informatica, Talend, and/or Matillion

Technical Skills

Snowflake Expertise:

  • Deep understanding of Snowflake architecture, including virtual warehouses, storage layer, and cloud services layer
  • Advanced knowledge of warehouse sizing, clustering keys, and partitioning strategies
  • Expertise in query optimization, execution plans, and performance profiling
  • Proficiency with Snowflake features: Time Travel, Zero-Copy Cloning, Data Sharing, Secure Functions
  • Experience with Snowflake cost monitoring and optimization tools

Programming & Query Languages:

  • Strong SQL skills - Expert-level proficiency in complex SQL, including window functions, CTEs, recursive queries, and performance tuning
  • Good Python experience - Proficiency in Python for data manipulation, automation, and pipeline development
  • Experience with stored procedures, UDFs, and dynamic SQL

Data Technologies:

  • Strong understanding of dimensional modeling and data warehouse design patterns
  • Experience with real-time data streaming and CDC (Change Data Capture) patterns
  • Knowledge of data governance, lineage, and catalog tools
  • Understanding of cloud platforms (AWS, Azure, or GCP) and their data services

Nice to Have

  • Experience with dbt (data build tool) for transformation workflows and data modeling
  • Snowflake certifications (SnowPro Core, SnowPro Advanced Architect)
  • Experience with Snowpark for advanced data processing
  • Knowledge of Infrastructure as Code (Terraform, CloudFormation)
  • Experience with BI tools (Tableau, Power BI, Looker) integration with Snowflake
  • Background in financial services, healthcare, or retail industries

Key Competencies

  • Optimization Mindset: Proven ability to identify and implement performance improvements that reduce costs and improve efficiency
  • Analytical Excellence: Strong problem-solving skills with ability to analyze complex data challenges
  • Communication: Ability to explain technical concepts to both technical and non-technical stakeholders
  • Strategic Thinking: Ability to align technical solutions with business objectives
  • Continuous Learning: Stays current with Snowflake features and data technology trends

What We Offer

  • Opportunity to architect and optimize enterprise-scale data platforms
  • Work with cutting-edge cloud data technologies
  • Competitive compensation package commensurate with experience
  • Professional development opportunities and certification support
  • Collaborative environment with focus on innovation

Application Requirements

Qualified candidates should submit:

  • Detailed resume highlighting Snowflake optimization experience and relevant platform expertise
  • Cover letter describing your approach to Snowflake cost optimization and performance tuning
  • Examples of successful optimization projects with quantifiable results (if available)

Equal Opportunity Employer

Apply Now
Apply Now

Job Details

Company
Mphasis
Location
United Kingdom, UK
Posted