Senior Data Engineer - R01572077

Brillio; Maharashtra; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Brillio is seeking a Senior Data Engineer to design and optimize Snowflake-based data pipelines. You will develop complex SQL, manage structured and unstructured data, and leverage Cortex AI Functions for AI-powered analytics. The role requires hands-on Snowflake experience and strong SQL skills in a fast-paced environment.

You will collaborate with data engineers and business teams to deliver scalable Snowflake solutions, ensure data quality, and optimize performance for cost efficiency.

Qualifications

• 2–4 years of hands-on Snowflake engineering and advanced SQL development.
• Develop complex SQL queries, joins, CTEs, views, stored procedures, and data transformations within Snowflake.
• Leverage Snowflake Cortex AI Functions 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 data validation, quality checks, and troubleshooting to maintain data integrity and reliability.
• Optimize SQL queries and Snowflake workloads for better performance and reduced cost.
• Support development and deployment of Generative AI use cases, including summarization and semantic search.
• Collaborate with data engineers, analysts, and business teams to gather requirements and deliver Snowflake solutions.

Responsibilities

• Develop complex SQL queries and data transformations in Snowflake.
• Utilize Snowflake Cortex AI Functions for AI-powered data processing.
• Collaborate with teams to deliver Snowflake solutions.
• Ensure data quality and reliability through validation and testing.
• Optimize workloads to improve performance and reduce cost.
• Support AI use cases like summarization and semantic search.

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 or related

Tools

Snowflake Cortex AI Functions

Job description

• 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

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)