Senior Data Engineer- Snowflake + DBT

Position: Snowflake Data Engineer

Purpose of the Position: This role seeks candidate who are passionate about building and optimising cloud-based data platform that support modern analytical initiatives. You will assist in implementing scalable Snowflake data pipeline, enabling efficient ingestion and transformation workflows, and supporting migration from legacy ETL systems to dbt-driven ELT architectures. The role contributes to improving data accessibility, performance, and consistency across enterprise analytics environment.

Location: Pune/ Bangalore/ Nagpur/ Chennai

Type of Employment: Full-time

Key Result Areas and Activities:

Snowflake Pipeline Development & Implementation - Develop and maintain Snowflake-native data pipeline including schemas, stages, steams, task, and warehouse configuration supporting ETL workloads.

Code conversion, refinement and optimization – Convert SSIS transformations into dbt staging/intermediate/mart models, review and validate tool converted dbt transformations to ensure accuracy maintainability alignment with enterprise modelling standards.

Data Modelling & Warehousing Structuring - Implement dimensional models and optimised storage structure aligned with enterprise reporting and analytical requirements.

Migration Documentation & Lineage Support - Maintain transformation documentation, mapping logic, testing evidence, and lineage metadata to support governance and audit readiness.

Cross-Team Collaboration & Delivery Support - Work closely with Cross functional teams and client stakeholders to resolve transformation discrepancies and ensure timely migration delivery

Work and Technical Experience:

Must Have:
Strong SQL development skills and experience in building transformation pipelines
Hands-on experience with snowflake cloud data platform
Experience implementing schemas, stages, steams, task, and warehouse
Experience supporting ETL/ELT workflows and clouds-based data ingestion
Understanding snowflake components (Time Travel, Data Sharing, Secure Views)
Knowledge of dimensional data modelling (Star/Snowflake schemas)
Experience with performance tuning and compute cost optimization in snowflake
Experience working with cloud storage integration
Familiarity with version control systems (GIT/Azure DevOps)
Ability to work with cross-functionally dependent teams
Experience with Snowpipe-based ingestion workflow

Good to Have:
Experience supporting dbt transformation pipeline
Experience in working with SnowConvert
Familiarity with orchestration tools (Airflow)
Exposure to clustering strategy implementation
Experience working in large-scale migration delivery programmes
Understanding of enterprise data governance practices
Experience mentoring junior engineers in transformation programs

Qualifications:

Experience
5+ years of experience in data engineering and Snowflake implementation
Exposure to mentoring engineers preferred
Education
Bachelor’s or Master’s degree in Computer Science, Information Technology, or equivalent.

Qualities:

Strong ownership, analytical and problem-solving mindset
Good communication and collaboration skills
Cross-team coordination capability
Performance-aware SQL mindset
Migration delivery adaptability
Structured Troubleshooting approach
Mentorship capabilities