Lead Snowflake Data Engineer

Role: Lead Snowflake Data Engineer Location: Richardson, TX-Hybrid 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.