Overview
Location: Noida
Experience: 7+ Years
About the Role:
We are looking for an experienced Senior Snowflake Data Engineer to design, develop, and optimize scalable data solutions within enterprise environments. The role is hands-on and focuses on building reliable data pipelines, modernizing data workloads, and improving Snowflake performance and cost efficiency.
The ideal candidate will have strong expertise in Snowflake, advanced SQL, Python, Snowpark, and modern data engineering practices, along with experience working in cloud-based enterprise environments.
Responsibilities
Key Responsibilities:
- Design, develop, and maintain scalable data pipelines and ELT/ETL workflows within Snowflake.
- Build data solutions using SQL, Python, Snowpark, dbt, and Snowflake-native capabilities.
- Modernize existing pipelines using set-based processing, incremental loading, and reusable engineering patterns.
- Develop solutions using Dynamic Tables, Streams, Tasks, and stored procedures.
- Optimize Snowflake performance and costs through query tuning, warehouse sizing, clustering, workload management, and auto-suspend/resume.
- Develop orchestration, dependency management, monitoring, error handling, and recovery mechanisms.
- Design and maintain dimensional, relational, and domain-oriented data models.
- Implement data-quality checks, testing, observability, lineage, and documentation.
- Integrate batch and real-time data using tools such as Fivetran, Kafka, Airflow, or similar technologies.
- Collaborate with architects, DevOps teams, analysts, and stakeholders to deliver production-ready solutions.
- Participate in code reviews, technical design discussions, estimation, and Agile delivery.
Qualifications
Required Qualifications:
- 7+ years of experience in Data Engineering, including significant hands-on Snowflake experience.
- Advanced SQL skills, including complex transformations, query optimization, and stored procedures.
- Strong Python development experience for data processing and automation.
- Hands-on experience with Snowpark, Dynamic Tables, Streams, and Tasks.
- Proven experience building and supporting production-grade ELT/ETL pipelines.
- Strong understanding of Snowflake performance and cost optimization.
- Experience with data modeling, incremental processing, orchestration, and dependency management.
- Experience with dbt or a comparable data transformation framework.
- Experience with at least one major cloud platform: AWS, Azure, or GCP.
- Experience with Git, CI/CD, automated testing, and modern software development practices.
- Strong analytical, troubleshooting, communication, and problem-solving skills.
Preferred Qualifications:
- Experience with Fivetran, Kafka, Airflow, or similar tools.
- Familiarity with Terraform or Infrastructure-as-Code.
- Experience with Snowflake Iceberg Tables or modern lakehouse architectures.
- Exposure to Snowflake Cortex, including Cortex Analyst, Cortex Search, or Cortex LLM functions.
- Experience with business continuity and disaster recovery strategies.
- SnowPro Core or SnowPro Advanced certification.
If you are passionate about building scalable, high-performance data platforms and have strong Snowflake expertise, we encourage you to apply.
#ibexphtalentmobility
Work Location: Hybrid remote in Noida, Uttar Pradesh