Snowflake Data Engineer

Role: Snowflake Data Engineer

Location: Richardson, TX-Hybrid

Type: W2 Contract

Need local to Dallas, TX who can attend In-Person interview

Job Summary

We are looking for a Snowflake Data Engineer to support a large-scale enterprise data modernization initiative focused on PostgreSQL to Snowflake migration, data platform stabilization, reporting enablement, and performance optimization.

The ideal candidate should have strong hands-on expertise in Snowflake, SQL optimization, ETL/ELT pipeline development, dimensional data modeling, and enterprise data platform support.

This role will primarily focus on building and stabilizing the end-to-end Snowflake environment, optimizing workloads, supporting analytics/reporting use cases, and ensuring the platform is production-ready and scalable.

The candidate will work closely with migration teams, architects, BI/reporting teams, and business stakeholders to support enterprise analytics and operational data requirements.

Responsibilities

• Support ongoing PostgreSQL to Snowflake migration activities and post-migration stabilization efforts.
• Build, support, and optimize Snowflake-based enterprise data platforms.
• Design and implement scalable dimensional data models including Star Schema and Snowflake Schema for analytics and reporting.
• Develop and maintain robust ETL/ELT pipelines for data ingestion, transformation, and loading.
• Analyze and optimize SQL queries, Snowflake workloads, and warehouse performance for scalability and cost efficiency.
• Fine-tune Snowflake virtual warehouses, clustering strategies, caching, and resource utilization.
• Support reporting and BI teams by preparing curated, clean, and reliable datasets for dashboards and analytics.
• Establish and maintain data governance, security, RBAC, and data quality standards.
• Monitor, troubleshoot, and resolve production issues, pipeline failures, and performance bottlenecks.
• Support batch and incremental data processing workflows across enterprise systems.
• Collaborate with architects, data engineers, reporting teams, and business stakeholders to resolve data-related issues and improve platform performance.
• Participate in production support, release management, operational enhancements, and environment stabilization activities.
• Ensure the platform is production-ready with proper monitoring, observability, scalability, and operational best practices.
• Support evaluation of graph-based data relationships and connected-data use cases using technologies such as Neo4j and GraphDB.

Required Skills

• Strong hands-on experience with Snowflake Data Warehouse.
• Expertise in SQL query optimization, performance tuning, and workload management.
• Strong experience in ETL/ELT pipeline development and support.
• Strong understanding of Snowflake architecture including:
• Virtual Warehouses
• Micro-partitions
• Clustering
• Caching
• Resource Monitors
• Cost Optimization
• Experience with orchestration and pipeline tools such as:
• Airflow
• DBT
• Informatica
• Matillion
• Azure Data Factory (ADF)
• Similar enterprise ETL tools
• Strong understanding of dimensional modeling concepts:
• Star Schema
• Snowflake Schema
• Fact and Dimension modeling
• Experience supporting analytics/reporting ecosystems and BI integrations.
• Experience with data governance, RBAC/security, monitoring, and production support.
• Strong troubleshooting, analytical, and problem-solving skills.
• Exposure to PostgreSQL and migration support activities.
• Ability to work in a collaborative enterprise environment with multiple stakeholders.

Qualifications

• Experience supporting post-migration enterprise environments.
• Exposure to graph database technologies such as Neo4j or GraphDB.
• Experience with AWS, Azure, or GCP cloud ecosystems.
• Knowledge of CI/CD and DevOps practices for data engineering platforms.
• Experience supporting large-scale enterprise analytics and reporting environments.