LEAD DATA ENGINEER - Snowflake

Job Description Senior Snowflake Data Engineer (Retail Domain) Experience: 10+ Years Domain: Retail Job Summary We are seeking a highly experienced Senior Snowflake Data Engineer to lead the design, development, and optimization of enterprise-scale cloud data platforms. The ideal candidate should have deep expertise in Snowflake, AWS, Apache Airflow, and Data Warehousing , along with hands-on experience in Python-based ETL development and Agile Scrum delivery . The candidate will also be expected to serve as a Scrum Master , facilitating Agile ceremonies, removing delivery impediments, mentoring the team, and driving continuous improvement while providing technical leadership. Primary Skills Snowflake Advanced SQL Stored Procedures Complex Data Transformations Role-Based Access Control (RBAC) Dynamic Data Masking Data Governance Query and Warehouse Performance Optimization Snowflake Architecture and Best Practices AWS Amazon S3 Amazon EMR (Elastic MapReduce) Apache Airflow Workflow Orchestration DAG Design, Development, and Scheduling Monitoring and Troubleshooting GitHub Source Code Management Branching Strategy Version Control Code Reviews Data Warehousing Enterprise Data Warehouse Design Dimensional Modeling Star and Snowflake Schemas Fact and Dimension Tables Types of Facts (Transactional, Snapshot, Accumulating Snapshot) Secondary Skills / Knowledge GitHub Actions for CI/CD Python for ETL Development Data Extraction from MySQL and other source systems Snowpark Open Table Formats (Apache Iceberg, Delta Lake, Apache Hudi) Data Pipeline Automation Query Performance Tuning Cloud Data Architecture Agile Delivery Practices Scrum Master Experience 2+ years of experience performing Scrum Master responsibilities. Facilitate Scrum ceremonies including Sprint Planning, Daily Stand-ups, Sprint Reviews, and Retrospectives. Track sprint progress and ensure timely delivery of committed work. Identify and remove team impediments to improve delivery efficiency. Collaborate with Product Owners to prioritize and refine the product backlog. Coach and mentor teams on Agile principles, Scrum practices, and continuous improvement. Monitor Agile metrics such as velocity, sprint burndown, and team capacity. Foster collaboration across cross-functional teams and stakeholders. Support release planning and dependency management. Key Responsibilities Lead the design, development, and optimization of scalable data solutions using Snowflake. Architect enterprise data warehouse solutions and implement efficient ETL/ELT pipelines. Design and manage Apache Airflow workflows for enterprise data orchestration. Implement and enforce data governance, RBAC, Dynamic Data Masking, and security best practices. Optimize SQL queries, stored procedures, and Snowflake warehouse performance. Build and manage data ingestion pipelines using AWS S3 and EMR. Collaborate with business stakeholders, architects, analysts, and development teams to deliver high-quality analytics solutions. Mentor junior and mid-level data engineers through technical guidance and code reviews. Manage source code and CI/CD processes using GitHub and GitHub Actions. Ensure data quality, platform reliability, scalability, and operational excellence. Act as Scrum Master by facilitating Agile ceremonies, resolving delivery impediments, and driving continuous improvement. Coordinate sprint execution, stakeholder communication, and release planning. Contribute to architectural decisions and technology roadmaps for the enterprise data platform. Preferred Qualifications 10+ years of experience in Data Engineering with strong expertise in Snowflake. 2+ years of Scrum Master experience in Agile software development teams. Experience working in the Retail domain. Strong understanding of modern cloud data architectures and enterprise data platforms. Experience with Snowpark and Open Table Formats (Apache Iceberg, Delta Lake, Apache Hudi). Scrum Master certification (CSM, PSM I/II, or SAFe Scrum Master) is preferred. Excellent communication, stakeholder management, mentoring, and leadership skills. Experience working in Agile/Scrum environments with distributed teams. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.