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…