Senior Data Engineer - R01572077

Lever, Inc.; Pune District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Lever, Inc. is seeking a Senior Data Engineer in Pune (India) to design and optimize data pipelines in Snowflake. You will work on AI-powered data processing using Cortex AI Functions and handle both structured and unstructured data for ingestion, transformation, and quality checks.

The role demands 2–4 years of Snowflake engineering and advanced SQL capabilities, with a focus on performance, cost optimization, and collaboration with analytics teams.

Qualifications

• 2–4 years of hands-on Snowflake engineering experience.
• Advanced SQL development with complex queries, joins, CTEs, views and stored procedures.
• Handling structured and unstructured data in Snowflake for ingestion and transformation.
• Familiarity with Generative AI use cases and AI-powered data processing.
• Data validation and quality checks to ensure reliability.

Responsibilities

• Develop complex SQL queries, joins, CTEs, views, and procedures in Snowflake.
• Leverage Snowflake Cortex AI Functions to build AI-powered data processing solutions.
• Work with structured and unstructured data in Snowflake for ingestion and transformation.
• Perform rigorous data validation and troubleshooting to ensure data integrity.
• Optimize Snowflake workloads for performance and cost efficiency.
• Support Generative AI use cases including summarization and information extraction.
• Collaborate with engineers, analysts, and business teams to deliver Snowflake solutions.

Skills

DataStream

ETL Fundamentals

SQL

Python

Data Warehousing

Time Travel & Fail Safe

Snowpipe

SnowSQL

Modern Data Platform

PLSQL

T-SQL

Stored Procedures

Education

Bachelor's degree in Computer Science/IT/Engineering

Snowflake SnowPro Core Certification

Certification in SQL (e.g., MS SQL)

Tools

Snowflake

Cortex AI Functions

Job description

Senior Data Engineer

Primary Skills

• DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures

Specialization

• Snowflake Engineering: Data Engineer

Job requirements

• Experience Range: 2 to 4 years of hands-on experience in Snowflake engineering and advanced SQL development Key Responsibilities: 1. Develop complex SQL queries, joins, common table expressions (CTEs), views, stored procedures, and data transformations within Snowflake 2. Leverage Snowflake Cortex AI Functions such as AI_COMPLETE, AI_CLASSIFY, AI_EXTRACT, AI_SENTIMENT, AI_EMBED, and AI_SUMMARIZE_AGG to build AI-powered data processing and analytics solutions 3. Work with structured and unstructured data in Snowflake, ensuring efficient data ingestion, transformation, and management 4. Perform rigorous data validation, quality checks, and troubleshooting to maintain data integrity and reliability 5. Optimize SQL queries and Snowflake workloads for enhanced performance and reduced cost 6. Support development and deployment of Generative AI use cases, including summarization, classification, information extraction, and semantic search 7. Collaborate with data engineers, analysts, and business teams to gather requirements and deliver tailored Snowflake solutions Required Skills: 1. Advanced SQL skills, including joins, CTEs, views, and stored procedures 2. Strong understanding of Snowflake architecture and data warehousing concepts 3. Experience with Snowflake Cortex AI Functions 4. Knowledge of data transformation techniques within Snowflake 5. Ability to work with structured and unstructured data in Snowflake Preferred Skills: 1. Experience implementing generative AI use cases such as semantic search or information extraction in Snowflake 2. Familiarity with optimizing Snowflake workloads for analytics 3. Knowledge of data security and governance in cloud data platforms 4. Certification in Snowflake or cloud data engineering Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline 2. Snowflake SnowPro Core Certification 3. Relevant certification in SQL (e.g., Microsoft Certified: SQL Database Specialist)