Lead Data Engineer DBT ,SQL, Snowflake , Tableau - R01570901

Brillio; Bengaluru; On-site; INR 1,600,000 - 2,300,000; Full time

Job summary

Brillio is seeking a Lead Data Engineer in India to design and deliver scalable data and analytics solutions. You will lead data pipelines, modern data warehouse architectures, and BI reporting using Snowflake, DBT, SQL, Python, and Tableau.

You will work on building end-to-end data solutions, optimize data models, and mentor junior engineers while collaborating with business teams to translate requirements into scalable data products.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related field.
• Experience with Snowflake, DBT, SQL, Python, and Tableau is required.
• Experience in designing scalable data pipelines and data warehouses.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using DBT, SQL, and Python.
• Build and optimize Snowflake-based data warehouse solutions leveraging Snowpipe, Zero Copy Cloning, Time Travel, Fail Safe, and Data Exchange.
• Design and implement robust data models to support analytics and reporting.
• Develop Tableau dashboards and reports for business users and stakeholders.
• Collaborate with business teams to gather reporting requirements and translate them into scalable data solutions.
• Create analytical datasets and semantic data models to support BI and self-service reporting.
• Perform data validation, reconciliation, and troubleshooting to ensure data quality.
• Develop stored procedures and automation frameworks within cloud data environments.
• Drive adoption of AI/GenAI capabilities to improve data processing and analytics.
• Mentor junior engineers on Snowflake, DBT, SQL, Tableau, and data engineering best practices.

Skills

Snowflake

DBT

SQL

Python

Tableau

ETL/ELT

Data Warehousing

Data Modeling

Zero Copy Cloning

Time Travel

Snowpipe

SnowSQL

Education

Bachelor's Degree in Computer Science/IT/Data Engineering

Tools

Snowflake

DBT

Tableau

Power BI

Looker

AWS Redshift

Google BigQuery

Job description

Lead Data Engineer

Primary Skills

• ETL Fundamentals, Zero Copy Cloning, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures

Specialization

• Snowflake Data Architecture: Lead Data Engineer

Job requirements

Senior Data Engineer – Snowflake, DBT, SQL & Tableau

Location

Bangalore / Hyderabad / Pune / Chennai / Gurgaon

Experience

4-8 Years of Experience

Job Summary

We are looking for a highly skilled Data Engineer with expertise in Snowflake, DBT, SQL, Python, and Tableau to design and deliver scalable data and analytics solutions. The ideal candidate will have hands-on experience building data pipelines, implementing modern data warehouse architectures, developing dashboards, and enabling business insights through reporting and analytics.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using DBT, SQL, and Python.


• Build and optimize Snowflake-based data warehouse solutions, leveraging Snowpipe, Zero Copy Cloning, Time Travel, Fail Safe, and Data Exchange.


• Design and implement robust data models to support analytics and reporting requirements.


• Develop, maintain, and optimize Tableau dashboards and reports for business users and stakeholders.


• Partner with business teams to gather reporting requirements and convert them into scalable data solutions.


• Create analytical datasets and semantic data models to support BI and self-service reporting.


• Perform data validation, reconciliation, and troubleshooting to ensure data quality and integrity.


• Develop stored procedures and automation frameworks within cloud data environments.


• Drive adoption of AI/GenAI capabilities to improve data processing and analytics.


• Mentor junior engineers on Snowflake, DBT, SQL, Tableau, and data engineering best practices.

Required Skills

Snowflake

• Hands-on experience with Snowflake Data Architecture.


• Strong understanding of:
  
  
  
  • Snowpipe
  
  
  • Zero Copy Cloning
  
  
  • Time Travel
  
  
  • Fail Safe
  
  
  • SnowSQL
  
  
  • Snowflake Data Exchange
  
  
  
  


• Experience in Snowflake performance tuning and optimization.

DBT

• Strong hands-on expertise in DBT.


• Experience in developing data transformation models, testing, deployment, and documentation.

SQL

• Expert-level SQL skills with experience handling large-scale datasets.


• Strong knowledge of data manipulation, optimization, joins, analytical functions, and query tuning.


• Experience with PL/SQL and T-SQL.

Tableau

• Hands-on experience in Tableau development and dashboarding.


• Experience building interactive dashboards, visualizations, KPIs, and executive reporting.


• Strong understanding of Tableau data modeling and dashboard optimization techniques.


• Experience connecting Tableau with Snowflake and cloud data warehouses.


• Ability to translate business requirements into impactful reports and dashboards.

Python

• Strong Python programming skills for automation, orchestration, and data engineering use cases.

Data Engineering

• Strong understanding of ETL/ELT frameworks and modern data architectures.


• Experience in dimensional modeling and data warehousing concepts.


• Hands-on experience designing scalable enterprise data solutions.

Preferred Skills

• Exposure to AI/GenAI tools and capabilities.


• Experience with Power BI, Looker, or other BI visualization platforms.


• Experience with AWS Redshift, Google BigQuery, or similar cloud data platforms.


• Knowledge of Finance, Renewals, Subscription Management, or Sales Analytics domains.


• Experience working in Agile and DataOps environments.

Educational Qualification

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

Preferred Certifications

• Snowflake SnowPro Certification


• Tableau Desktop Certified Professional


• DBT Certification


• Microsoft Data Engineer Associate


• AWS Data Analytics Certification

Primary Skills

Snowflake, DBT, SQL, Tableau, Python

Secondary Skills

Data Modeling, Data Warehousing, ETL/ELT, AI/GenAI, Power BI, Looker, AWS Redshift, BigQuery