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.

OnePlan Optimization & Capacity Planning Define and implement OnePlan-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 SnowPro 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, OnePlan 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 Engineering 8+ years of Database Engineering/Optimization 3+ years of Cloud Data Platform Architecture Proven delivery of large-scale data modernization programs.