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.