Data Specialist - R01569581

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

Job summary

Brillio 2 is seeking a Data Engineer with strong Snowflake, DBT, SQL and Python to design, develop, and maintain scalable data solutions. The ideal candidate will have hands-on experience building modern data pipelines, implementing data warehouse solutions, and enabling analytics through efficient data modeling and transformation practices.

The role focuses on creating robust data models, optimizing ETL/ELT processes, and ensuring data quality across cloud platforms to empower enterprise

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Hands-on Snowflake experience with Snowflake Data Warehouse and features like Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe.
• Proficiency in DBT, SQL, and Python for building data pipelines and transformations.
• Experience with data warehousing, dimensional modeling, data governance, and metadata management.

Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines using DBT, SQL, and Python.
• Develop and optimize Snowflake-based data warehouse solutions for analytics and reporting.
• Create robust data models and transformation frameworks to support business requirements.
• Implement data ingestion, cleansing, transformation, and validation processes.
• Develop and maintain stored procedures, views, and database objects within cloud data platforms.
• Optimize SQL queries, data models, and pipelines for performance and scalability.
• Collaborate with stakeholders, analysts, and engineers to translate requirements into technical solutions.
• Monitor data quality and troubleshoot data-related issues across platforms.
• Leverage Snowflake features such as Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe.
• Participate in code reviews, testing, deployment, and documentation activities.
• Support data governance, security, and best practices across the data ecosystem.

Skills

Snowflake

DBT

SQL

Python

ETL/ELT

Data Warehousing

Data Modeling

Education

Bachelor's degree in Computer Science/IT/Engineering

Tools

SnowSQL

Airflow

Power BI

Tableau

Looker

Git

Job description

Lead Data Engineer

• BigTable, Cloud Functions, Cloud Spanner, GKE
• GCP Data Engineer Advanced: Senior Data Engineer

Job Title: Data Engineer – Snowflake, DBT, Python & SQL

Experience

5–8 Years

Location

Bangalore / Hyderabad / Pune / Chennai / Gurgaon

Job Summary

We are seeking a skilled Data Engineer with strong expertise in Snowflake, DBT, SQL, and Python to design, develop, and maintain scalable data solutions. The ideal candidate will have hands-on experience building modern data pipelines, implementing data warehouse solutions, and enabling analytics through efficient data modeling and transformation practices.

Key Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines using DBT, SQL, and Python.
• Develop and optimize Snowflake-based data warehouse solutions for enterprise analytics and reporting.
• Create robust data models and transformation frameworks to support business requirements.
• Implement data ingestion, cleansing, transformation, and validation processes.
• Develop and maintain stored procedures, views, and database objects within cloud data platforms.
• Optimize SQL queries, data models, and pipelines for performance and scalability.
• Work closely with business stakeholders, analysts, and engineering teams to translate requirements into technical solutions.
• Monitor data quality and troubleshoot data-related issues across platforms.
• Leverage Snowflake features such as Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe.
• Participate in code reviews, testing, deployment, and documentation activities.
• Support data governance, security, and best practices across the data ecosystem.

Required Skills

Snowflake

• Strong hands-on experience with Snowflake Data Warehouse.
• Experience with:
  • Snowpipe
  • Zero Copy Cloning
  • Time Travel
  • Fail Safe
  • SnowSQL
  • Data Sharing/Data Exchange
  • Performance tuning and optimization of Snowflake workloads.

DBT

• Strong expertise in DBT (Data Build Tool).
• Experience developing reusable transformation models.
• Understanding of DBT testing, documentation, and deployment practices.

SQL

• Advanced SQL skills with experience handling large-scale datasets.
• Expertise in query optimization, joins, analytical functions, and performance tuning.
• Experience with stored procedures and database development.

Python

• Strong Python programming skills for data processing and automation.
• Experience with data engineering frameworks and scripting.

Data Engineering

• Strong understanding of ETL/ELT concepts and modern data architectures.
• Experience in data warehousing and dimensional modeling.
• Knowledge of data governance, data quality, and metadata management.

Preferred Skills

• Experience with orchestration tools such as Airflow.
• Exposure to cloud platforms such as AWS, Azure, or GCP.
• Knowledge of CI/CD practices and Git-based version control.
• Experience with reporting and visualization tools such as Power BI, Tableau, or Looker.
• Exposure to AI/GenAI capabilities within data engineering solutions.

Educational Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Certifications

• Snowflake SnowPro Certification
• DBT Certification
• AWS/Azure/GCP Data Engineering Certifications
• Databricks or Cloud Data Platform Certifications

Primary Skills

Snowflake, DBT, SQL, Python

Secondary Skills

Data Modeling, ETL/ELT, Airflow, AWS/Azure/GCP, Power BI/Tableau, Data Warehousing