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

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