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