Senior Data Engineer - R01572077

Brillio 2; Pune District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Brillio 2 is seeking a Senior Data Engineer in Pune, India to advance Snowflake-based data engineering and AI-enabled analytics. The role focuses on building scalable data pipelines, complex SQL, and AI-powered data processing using Snowflake Cortex AI Functions.

You will work with structured and unstructured data, ensure data quality, and optimize performance and costs. Ideal candidates will have 2–4 years of hands-on Snowflake engineering and advanced SQL development, along with a relevant

Qualifications

• Bachelor's degree in Computer Science, IT, Engineering or closely related field
• Snowflake SnowPro Core Certification preferred
• SQL certification (e.g., Microsoft SQL) desirable

Responsibilities

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

Skills

SQL (Advanced)

Snowflake

Python

ETL Fundamentals

Data Warehousing

CTEs/Stored Procedures

Snowflake Cortex AI

Snowpipe

SnowSQL

Data Transformation

Structured Data

Education

Bachelor's degree in Computer Science/IT/Engineering

Snowflake SnowPro Core Certification

SQL Certification (e.g., MS SQL)

Tools

Snowflake Cortex AI Functions

Snowflake SQL

Job description

Senior Data Engineer

• 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
• Snowflake Engineering: Data Engineer

Experience Range: 2 to 4 years of hands‑on experience in Snowflake engineering and advanced SQL development

Key Responsibilities:

• Develop complex SQL queries, joins, common table expressions (CTEs), views, stored procedures, and data transformations within Snowflake
• 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
• Work with structured and unstructured data in Snowflake, ensuring efficient data ingestion, transformation, and management
• Perform rigorous data validation, quality checks, and troubleshooting to maintain data integrity and reliability
• Optimize SQL queries and Snowflake workloads for enhanced performance and reduced cost
• Support development and deployment of Generative AI use cases, including summarization, classification, information extraction, and semantic search
• Collaborate with data engineers, analysts, and business teams to gather requirements and deliver tailored Snowflake solutions

Required Skills:

• Advanced SQL skills, including joins, CTEs, views, and stored procedures
• Strong understanding of Snowflake architecture and data warehousing concepts
• Experience with Snowflake Cortex AI Functions
• Knowledge of data transformation techniques within Snowflake
• Ability to work with structured and unstructured data in Snowflake

Preferred Skills:

• Experience implementing generative AI use cases such as semantic search or information extraction in Snowflake
• Familiarity with optimizing Snowflake workloads for analytics
• Knowledge of data security and governance in cloud data platforms
• Certification in Snowflake or cloud data engineering

Desired Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline
• Snowflake SnowPro Core Certification
• Relevant certification in SQL (e.g., Microsoft Certified: SQL Database Specialist)