Snowflake Data Engineer

Job Summary: We are seeking a Senior Snowflake Data Engineer with deep expertise in Snowflake, SQL, and modern ELT/ETL frameworks to design, build, optimize, and productionize enterprise-scale data pipelines and analytics data products. The role focuses on developing high-performance data solutions, implementing strong data governance, and ensuring scalable architecture within Snowflake. The candidate will collaborate with Data Architects, Product Owners, Analytics Engineers, and Platform teams to deliver secure, reliable, and cost-optimized data solutions. Key ResponsibilitiesSnowflake Data EngineeringDesign, build, and maintain enterprise data pipelines and data products on SnowflakeConfigure and manage Snowflake warehouses, databases, schemas, roles, and grants (RBAC)Implement data ingestion using Stages, File Formats, COPY INTO, Snowpipe, Streams, and TasksLeverage Time Travel, Zero-Copy Cloning, and Fail-safe capabilities for data recovery and lifecycle management. Data Pipeline & ELT DevelopmentDevelop high-performance SQL-based transformations for large-scale data processingBuild scalable ELT/ETL pipelines supporting enterprise analytics workloads. Implement orchestration workflows using Airflow or other scheduling frameworksSupport integration with enterprise data platforms and analytics tools. Performance & Cost OptimizationOptimize Snowflake workloads using clustering keys, micro-partition pruning, caching, and query tuningManage compute and storage resources to ensure cost-efficient data processingImplement materialized views, dynamic tables, and semantic views for improved performance. Data Governance & SecurityImplement secure data sharing, masking policies, tagging, and governance frameworksConfigure RBAC, storage integrations, and parameter management for secure data access. Ensure compliance with enterprise data governance and security standardsCollaboration & Data ModelingCollaborate with Product Owners, Data Architects, and Analytics Engineers to design data models. Implement dimensional models (Star, Snowflake, 3NF) and SCD Type 1/2 strategiesSupport enterprise analytics and reporting initiatives with reliable data structures. Required Skills & Experience10+ years of experience in Data Engineering or Data Platform developmentStrong hands-on expertise with Snowflake architecture and platform featuresAdvanced SQL development for large-scale transformationsExperience with Snowflake ingestion tools (COPY INTO, Snowpipe, Streams & Tasks)Strong knowledge of query performance tuning and Snowflake optimization techniquesExperience implementing secure data sharing, masking policies, tagging, and governance controlsPreferred SkillsPython programming for ELT frameworks, utilities, and data quality checks. Experience with dbt (data build tool) for transformation-as-code. Workflow orchestration with Apache Airflow, ADF, Glue, or Cloud ComposerExperience with cloud platforms (AWS, Azure, or GCP) including storage and IAM. Experience with CI/CD pipelines, Git workflows, and automated deploymentsData quality frameworks such as dbt tests or Great ExpectationsCompetenciesExpertise in Snowflake Data Platform and DevOps practicesStrong data modeling and architecture knowledgeExcellent problem-solving and analytical abilitiesStrong communication and stakeholder collaboration skills