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

Primary Skills

Specialization

Job requirements

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