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

Posted 9 Days Ago
Be an Early Applicant
Bangalore, Bengaluru Urban, Karnataka, IND
Hybrid
Senior level
Information Technology
The Role
Lead data engineering role responsible for designing scalable ETL/ELT pipelines, Snowflake data warehouse solutions, dbt transformation models, SQL procedures, and Python automation. The role develops Tableau dashboards, analytical datasets, and semantic models; performs data validation and optimization; partners with business stakeholders; supports AI/GenAI adoption; and mentors junior engineers. Required expertise includes Snowflake architecture, dbt, advanced SQL, Tableau, Python, data modeling, and enterprise data warehousing.
Summary Generated by Built In
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

                           

Skills Required

  • 4-8 years of data engineering experience
  • Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field
  • Hands-on Snowflake Data Architecture experience
  • Experience with Snowpipe, Zero Copy Cloning, Time Travel, Fail Safe, SnowSQL, and Snowflake Data Exchange
  • Snowflake performance tuning and optimization experience
  • Hands-on dbt experience developing, testing, deploying, and documenting transformation models
  • Expert-level SQL skills, including data manipulation, optimization, joins, analytical functions, and query tuning
  • Experience with PL/SQL and T-SQL
  • Hands-on Tableau development and dashboarding experience
  • Experience building interactive dashboards, visualizations, KPIs, and executive reports
  • Tableau data modeling and dashboard optimization experience
  • Experience connecting Tableau with Snowflake and cloud data warehouses
  • Strong Python programming skills for automation, orchestration, and data engineering
  • Strong understanding of ETL/ELT frameworks, modern data architectures, dimensional modeling, and data warehousing
  • 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
  • Snowflake SnowPro Certification
  • Tableau Desktop Certified Professional certification
  • dbt Certification
  • Microsoft Data Engineer Associate certification
  • AWS Data Analytics Certification

Brillio Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.

  • Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
  • Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
  • Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.

Brillio Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Santa Clara, CA
2,676 Employees
Year Founded: 2014

What We Do

Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.

Similar Jobs

Coupa Logo Coupa

Lead Data Scientist

Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
3000 Employees

Coupa Logo Coupa

Principal Data Scientist

Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Hybrid
Bangalore, Bengaluru Urban, Karnataka, IND
3000 Employees
Remote or Hybrid
3 Locations
1100 Employees

Atlassian Logo Atlassian

Senior Principal Forward Deployed Engineer

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
In-Office or Remote
Bengaluru, Bengaluru Urban, Karnataka, IND
11000 Employees

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account