Job Summary:
Seeking a highly experienced, hands-on Data Engineer with strong expertise in Snowflake to design, develop, optimize, and support enterprise data pipelines and dimensional data warehouse solutions. The ideal candidate will have practical experience building production-grade Snowflake solutions and a deep understanding of data warehousing fundamentals, stored procedures, Slowly Changing Dimensions (SCD Type 2), data quality, transaction management, and performance optimization. This is a hands-on development role requiring the ability to independently build, troubleshoot, and deliver production-quality data engineering solutions.
Key Responsibilities:
• Design, develop, and maintain enterprise data pipelines and transformations in Snowflake.
• Develop complex SQL queries and Snowflake stored procedures.
• Implement dimensional data models, including star schemas and Snowflake schemas.
• Develop and maintain Slowly Changing Dimensions (SCD Type 2).
• Build data loading logic to handle inserts, updates, unchanged records, and historical data tracking.
• Implement data quality checks, validation, and reconciliation processes.
• Develop exception handling, transaction management, rollback, and recovery processes.
• Analyze Snowflake query profiles and troubleshoot performance bottlenecks.
• Optimize Snowflake queries, data loads, warehouse utilization, and consumption costs.
• Perform unit testing and support Quality Assurance (QA) and User Acceptance Testing (UAT) activities.
• Troubleshoot production data issues and determine appropriate remediation strategies.
• Work independently after initial onboarding while collaborating with technical leads.
• Demonstrate the ability to explain and support personally developed production solutions, including SCD Type 2 implementation, stored procedures, query optimization, data quality checks, and failed data load handling.
Required Qualifications:
• Deep hands-on experience in Snowflake data engineering.
• Advanced SQL development skills.
• Hands-on experience developing Snowflake stored procedures.
• Strong understanding of exception handling, transaction management, and rollback mechanisms.
• Deep knowledge of dimensional data warehousing concepts.
• Hands-on experience implementing SCD Type 2, including change detection, historical record management, and effective dates.
• Experience with star schemas and Snowflake schemas.
• Experience developing and maintaining production data pipelines.
• Experience implementing data quality checks, validation, and reconciliation processes.
• Experience with Snowflake query profiling and performance optimization.
• Experience optimizing warehouse utilization, query runtime, and operational costs.
• Strong troubleshooting and production support experience.
• Ability to independently develop, troubleshoot, and deliver production-quality solutions with minimal guidance.
• Ability to explain specific production solutions personally developed and demonstrate practical technical knowledge.
Preferred Qualifications:
• Experience with AI-assisted coding tools such as Snowflake Cortex Code, Claude Code, or GitHub Copilot.
• Experience migrating workloads from Databricks to Snowflake.
• Knowledge of data lineage and data governance.