About this role
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