Senior Data Engineer (Snowflake+ DBT)

Anblickslucknow, uttar pradesh, in

3 days ago

Job description

Senior Data Engineer (Snowflake + dbt)

Experience : 8–12 Years

Location : Hyderabad / Ahmedabad (Hybrid)

Company : Anblicks Inc. – Great Place to Work® Certified | Snowflake Elite Partner

Role Overview

We are looking for a highly skilled Senior Data Engineer with deep hands-on experience in Snowflake and dbt to design, build, and optimize scalable ELT pipelines and analytical data models. In this role, you will lead technical design, drive engineering best practices, and collaborate with cross-functional teams to build high-quality, reliable, and cost-efficient data solutions.

Key Responsibilities

1. Data Pipeline & ELT Development

Design, develop, and maintain scalable ELT / ETL pipelines using Snowflake, dbt, and orchestration tools (Airflow, dbt Cloud, Prefect).
Own the dbt development lifecycle including modeling, tests, documentation, versioning, and deployment.
Build reusable and modular data transformation frameworks supporting analytics, BI, and machine learning use cases.

2. Snowflake Engineering & Optimization

Design and implement Snowflake data models using :

Dimensional modeling

Data Vault

3NF and enterprise modeling practices

Optimize compute performance through query tuning, clustering, micro-partitioning, warehouse optimization, caching, and Snowpipe.

Monitor pipeline performance and apply cost-control strategies.

3. Advanced SQL & Problem Solving

Write complex, optimized SQL for large datasets and multi-layered transformations.

Troubleshoot ingestion, transformation, and modeling issues end-to-end across the data ecosystem.

Implement automated data quality checks, validation rules, and CI / CD workflows.

4. Collaboration, Architecture & Mentorship

Work closely with BI teams, analysts, and product owners to convert business needs into scalable technical designs.

Participate in design reviews, provide technical recommendations, and champion best practices in data modeling, governance, and engineering.

Mentor junior team members and contribute to reusable frameworks, accelerators, and internal playbooks.

Required Skills & Experience

8–12 years of strong data engineering experience with cloud-native architectures.

Minimum 5 years hands-on experience with Snowflake & dbt in production.

Mastery in SQL , ELT patterns, and performance tuning.

Deep understanding of data warehousing concepts, CDC, SCDs, and dimensional modeling.

Practical experience with orchestration tools (Airflow, dbt Cloud, Prefect).

Good knowledge of cloud ecosystems ( AWS / Azure / GCP ).

Understanding of data governance, security, metadata, and pipeline auditing.

Excellent analytical, communication, and stakeholder management skills.

Nice to Have

Python for automation or data processing.

Exposure to Databricks, Spark, or event-based data ingestion.

Experience with Git-based CI / CD, Terraform / IaC, or containerized environments.

Understanding of BI tools (Power BI, Looker, Tableau).

Why Join Anblicks

Great Place to Work® Certified culture with strong focus on people, learning, and growth.

Opportunity to work on enterprise Snowflake implementations as part of a Snowflake Elite Partner ecosystem.

Fast-paced, innovation-driven environment with continuous learning, certification support, and career advancement.

Exposure to global clients, modern data stacks, and cutting-edge cloud technologies.

Create a job alert for this search

Senior Data Engineer • lucknow, uttar pradesh, in

Related jobs

Promoted
New!

Senior Data Engineer

TEKsystems Global Services in IndiaLucknow, IN

Develop and manage data pipelines using ADF and Azure data bricks.Expert knowledge in data warehousing, data modeling and ETL. Good to have datastage exposure.Expertise in on-prem to azure cloud mig...Show moreLast updated: 13 hours ago

Promoted

Senior Data Platform Engineer

Black Dog LabsLucknow, IN

Remote (collaboration across time zones), India or LATAM preferred.Proficient English communication.Data Engineering / Backend Engineering / DevOps. We’re looking for a hands-on Senior Data Platform...Show moreLast updated: 30+ days ago

Promoted

Senior Data Engineer

American InferenceLucknow, IN

Please apply directly through for this position.We kindly request that candidates refrain from contacting company officials via email or messages regarding this role. We are an AI and Data Consulti...Show moreLast updated: 14 days ago

Promoted

Senior Data Engineer

IntelliasLucknow, IN

Apache Flink / Apache Spark (Streaming).Data Engineer or similar role, with hands-on expertise in large-scale, production-grade data pipelines. Kafka + Flink / Spark Streaming).Python for data engin...Show moreLast updated: 16 days ago

Promoted

Data Engineer

HCLTechLucknow, IN

We’re Expanding Our Digital & Data Talent Pool.Are you a professional ready to take on enterprise-scale transformation journey? We are on a mass hiring drive and looking for experts who can bring i...Show moreLast updated: 30+ days ago

Promoted
New!

Senior Data Engineer / Architect - Snowflake

Aezion, IncLucknow, IN

We are seeking a highly skilled Snowflake Data Engineer with expertise in DBT, Airbyte, and Airflow, combined with strong experience in Kimball dimensional modeling. The ideal candidate will design ...Show moreLast updated: 13 hours ago

Promoted
New!

Senior Data Engineer

FornaxLucknow, IN

If solving business challenges drives you.Fornax is a team of cross-functional individuals who solve critial business challenges using core concept of analytics, critical thinking.We are seeking a ...Show moreLast updated: 13 hours ago

Promoted
New!

Data Engineer | Bangalore | Leading Big 4 Consulting Firm

Acme ServicesLucknow, IN

Design, develop, and maintain scalable and robust data pipelines (ETL / ELT) using PySpark on the Databricks platform.Implement data ingestion strategies to load data from various sources (e.APIs, da...Show moreLast updated: 13 hours ago

Promoted
New!

Senior Data Architect- Snowflake

USEReadyLucknow, IN

USEReady is a data and analytics firm that provides the strategies, tools, capability, and capacity that businesses need to turn their data into a competitive advantage. USEReady partners with cloud...Show moreLast updated: 13 hours ago

Promoted

Data Engineer

Ubique SystemsLucknow, IN

Primary skills : Python, SQL, data lakes, azure.Pipeline Development & Automation.Design, build, and maintain CI / CD pipelines to automate deployment of DQ rules and data services across environments...Show moreLast updated: 30+ days ago

Promoted
New!

Senior Data Engineer

MindlanceLucknow, IN

We’re looking for a strong, hands-on Sr Data Engineer who can independently drive client conversations, collaborate with SMEs, and deliver high-quality data solutions in a cloud-native environment....Show moreLast updated: 13 hours ago

Promoted

Senior AWS Data Engineer

CYAN360Lucknow, IN

Position : Senior AWS Data Engineer.Work Timings : 2 : 30 PM to 11 : 30 PM IST.Need someone who can join immediately or in 15 days • • •. Design, develop, and deploy end-to-end data pipelines on AWS cloud in...Show moreLast updated: 30+ days ago

Promoted

Senior Data Engineer

Intellify SolutionsLucknow, IN

Total years of experience : 10+ years.Required : Bachelor’s degree or relevant experience.Required : Prior experience as a software engineer or data engineer in a. Required : Cloud Data Warehouse experi...Show moreLast updated: 7 days ago

Promoted

Data Engineer

Alp Consulting Ltd.Lucknow, IN

Architect and maintain our Amazon Redshift Serverless data warehouse.Design and implement ETL pipelines from operational Redshift to staging (DSA), landing (DLA), and TDW layers.Model data using st...Show moreLast updated: 30+ days ago

Promoted
New!

Snowflake + DBT Engineer

MindBrainlucknow, uttar pradesh, in

Location : Pune — Remote / Hybrid.We are looking for a highly experienced Snowflake + DBT Engineer to architect, build, and optimize modern cloud data platforms. The ideal candidate should have deep ex...Show moreLast updated: 6 hours ago

Promoted

Data Engineer

IntraEdgeLucknow, IN

Python, PySpark, AWS services (Glue, Lambda), and Snowflake.The ideal candidate will design, build, and maintain scalable data pipelines, ensure efficient data integration, and enable advanced anal...Show moreLast updated: 30+ days ago

Promoted
New!

Senior Data Engineer

Adaptive Technology InsightsLucknow, IN

We are looking for an experienced.You will be responsible for designing, building, and optimizing data pipelines and architecture to support analytics, reporting, and data-driven decision-making ac...Show moreLast updated: 13 hours ago

Promoted

Senior Data Engineer

DonyatiLucknow, IN

We are seeking a highly skilled Senior Data Engineer to join our team in building a modern data platform on AWS.You will play a key role in transitioning from legacy systems to a scalable, cloud-na...Show moreLast updated: 2 days ago