Brillio

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

Brillio Bangalore, Karnataka, India

Artificial Intelligence · 5,001-10,000 employees

Sep 09
data-engineer Senior (5-10 yrs) Full-time India
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

Design, develop, and maintain scalable ETL/ELT pipelines and Snowflake-based data warehouse solutions. Develop and optimize Tableau dashboards while mentoring junior engineers on data engineering best practices.

What they look for

Snowflake DBT SQL Tableau Python ETL ELT Data Warehousing Data Modeling Snowpipe Zero Copy Cloning Time Travel PL/SQL T-SQL Data Engineering Automation

Requirements

Requires 4-8 years of experience with strong expertise in Snowflake, DBT, SQL, Python, and Tableau. A Bachelor's degree in Computer Science, Information Technology, or a related field is required.

Full description

Lead Data Engineer

\n

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

\n

Similar roles