Snowflake Data Engineer

Candidate will be working CST time zone.

We are seeking a highly experienced Senior Data Engineer with deep expertise in Snowflake Data Platform, Enterprise Databases, Data Warehousing, and Database Performance Optimization . The ideal candidate will bring a strong foundation as a Senior Database Engineer/Architect and possess hands-on experience in designing, optimizing, modernizing, and governing large-scale enterprise data platforms.

This role requires extensive experience in Snowflake architecture, database optimization, SQL performance tuning, cloud-based data engineering, data modeling, ETL/ELT frameworks, and enterprise data migrations. The candidate will lead strategic initiatives focused on data platform modernization, workload optimization, scalability, reliability, and cost efficiency.

Key Responsibilities

Snowflake Data Engineering

• Design, develop, and maintain enterprise-grade data platforms using Snowflake.
• Architect scalable ELT/ETL frameworks supporting structured and semi-structured data.
• Implement advanced Snowflake capabilities including:
• Snowpipe
• Streams & Tasks
• Time Travel
• Zero-Copy Cloning
• Data Sharing
• Materialized Views
• Snowpark
• Design data ingestion frameworks for batch, micro-batch, and real-time processing.
• Build reusable data pipelines supporting analytics, reporting, AI, and machine learning workloads.

Database Engineering & Optimization

• Serve as the SME for enterprise database architecture and optimization.
• Design and optimize large-scale OLTP, OLAP, Data Warehouse, and Data Lake solutions.
• Lead database modernization and migration initiatives from:
• Oracle
• SQL Server
• Teradata
• PostgreSQL
• Redshift
• Legacy Data Warehouses to Snowflake cloud platforms. (JD-Snowfla...e and Qlik | Word), (Snowflake_...a_Engineer | Word)
• Drive:
• Query performance tuning
• Execution plan analysis
• Index optimization
• Warehouse sizing
• Data partitioning strategies
• Cluster optimization
• Resource utilization optimization
• Cost optimization initiatives
• Perform root cause analysis for platform bottlenecks and recommend optimization strategies.

One Plan Optimization & Capacity Planning

• Define and implement One Plan-based optimization strategies for enterprise data platforms.
• Perform demand forecasting, capacity planning, workload balancing, and platform utilization analysis.
• Optimize compute consumption across Snowflake virtual warehouses.
• Drive platform efficiency through:
• Workload management
• Query prioritization
• Resource governance
• Cost-performance optimization
• Storage lifecycle management
• Develop data-driven recommendations to improve ROI and reduce operational costs.

Data Architecture & Governance

• Design:
• Enterprise Data Models
• Star Schema
• Snowflake Schema
• Data Vault Models
• Dimensional Models
• Establish enterprise standards for:
• Data quality
• Metadata management
• Data lineage
• Security
• Compliance
• Data governance
• Implement CDC frameworks and master data integration strategies.

Leadership Responsibilities

• Provide technical leadership to Data Engineers and Database Engineers.
• Conduct architecture reviews and performance assessments.
• Define engineering best practices and coding standards.
• Support pre-sales, solutioning, estimations, and client workshops.
• Mentor junior engineers and lead optimization initiatives across portfolios.

Mandatory Technical Skills

Snowflake

• Snowflake Architecture
• SnowSQL
• Streams & Tasks
• Snowpipe
• Time Travel
• Cloning
• Data Sharing
• Secure Data Exchange
• Warehouse Optimization
• Performance Tuning
• Snowpark
• Query Profiling
• Cost Optimization

Database Expertise

• Oracle
• SQL Server
• PostgreSQL
• Redshift
• Teradata
• Database Administration Concepts
• Query Optimization
• Execution Plan Tuning
• Indexing Strategies
• Partitioning
• Replication
• Backup & Recovery
• High Availability Design

Data Engineering

• ETL / ELT
• Data Warehousing
• Data Lakes
• CDC
• Data Modeling
• Data Migration
• Data Governance
• Metadata Management

Programming

• Advanced SQL
• Python
• Shell Scripting
• Java/JavaScript (preferred)

Cloud Platforms

• AWS
• Azure
• Snowflake Cloud Native Architecture

Tools

• Azure Data Factory
• Informatica IICS
• Airflow
• DBT
• Databricks
• Git
• CI/CD Pipelines

Preferred Qualifications

• Snow Pro Core Certification.
• Experience leading enterprise data transformation programs.
• Experience supporting large AMS/Data Platform engagements.
• Knowledge of Power BI, Tableau, Qlik, and enterprise reporting ecosystems.
• Experience with AI/ML data platforms and modern analytics architectures.

Ideal Candidate Profile

A seasoned Senior Data Engineer with deep Snowflake expertise and extensive experience as a Senior Database Engineer , capable of owning end-to-end data platform architecture, enterprise database optimization, workload planning, One Plan optimization, and large-scale cloud migration programs. The individual should be comfortable engaging with CIOs, Data Architects, and business stakeholders while delivering measurable improvements in platform performance, scalability, reliability, and cost efficiency.

Desired Industry Exposure

• Oil & Gas
• Manufacturing
• Retail
• Life Sciences
• Supply Chain
• Enterprise Shared Services

Experience Level

12+ years overall experience with at least:

• 5+ years of Snowflake Data…