Sr Snowflake Data Engineer

Job Description: Senior Snowflake Developer

Experience: 5+ Years

Role: Senior Snowflake Developer / Senior Data Engineer

Employment Type: Full-Time

Job Summary

We are looking for an experienced Senior Snowflake Developer with strong hands-on expertise in Snowflake, dbt, data migration, ETL/ELT processes, and data modelling. The ideal candidate should have experience designing, developing, and optimizing scalable data pipelines and enterprise data warehouse solutions.

The candidate must be capable of working directly with business stakeholders and customers to understand business requirements, translate them into technical solutions, and independently deliver high-quality data engineering outcomes.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake and dbt.
• Build and optimize ETL/ELT workflows for integrating data from multiple source systems.
• Develop efficient SQL queries, stored procedures, views, and other Snowflake objects.
• Perform data migration activities, including source-to-target mapping, data transformation, reconciliation, and validation.
• Design and implement logical and physical data models, including dimensional modelling, star schemas, and snowflake schemas.
• Develop reusable dbt models, macros, tests, snapshots, and documentation.
• Optimize Snowflake query performance, warehouse utilization, and compute costs.
• Implement data quality checks, data validation rules, and error-handling mechanisms.
• Work with cloud storage, APIs, databases, and other enterprise data sources to build reliable data ingestion solutions.
• Collaborate directly with business stakeholders, functional teams, architects, and customers to understand requirements and propose solutions.
• Independently manage assigned development activities, troubleshoot complex data issues, and deliver solutions within agreed timelines.
• Participate in technical discussions, code reviews, design reviews, and production support activities.
• Ensure data security, governance, access controls, and development standards are followed.

Mandatory Technical Skills

1. Snowflake

• Strong hands-on experience with Snowflake data warehouse architecture.
• Expertise in Snowflake SQL, query optimization, performance tuning, and cost management.
• Experience with virtual warehouses, stages, file formats, streams, tasks, and related Snowflake features.
• Experience implementing data ingestion and transformation solutions.

2. dbt (Data Build Tool)

• Strong practical experience developing and managing dbt projects.
• Experience with dbt models, materializations, macros, tests, snapshots, and documentation.
• Understanding of incremental models, dependency management, and modular transformation design.
• Experience integrating dbt with Snowflake and implementing data quality checks.

3. ETL/ELT Development

• Strong understanding of ETL and ELT architecture and implementation.
• Experience building scalable data ingestion and transformation pipelines.
• Ability to handle structured and semi-structured data.
• Experience with pipeline monitoring, error handling, and data reconciliation.

4. Data Migration

• Experience migrating data from legacy databases, data warehouses, or on-premises systems to Snowflake.
• Knowledge of source-to-target mapping, transformation rules, data profiling, validation, and reconciliation.
• Ability to identify migration issues and ensure data accuracy and completeness.

5. Data Modelling

• Strong knowledge of conceptual, logical, and physical data modelling.
• Experience with dimensional modelling, star and snowflake schemas, fact and dimension tables, and slowly changing dimensions (SCD).
• Ability to design scalable and maintainable data models aligned with business requirements.

6. SQL and Database Concepts

• Advanced SQL skills, including complex joins, CTEs, window functions, and query optimization.
• Strong understanding of relational databases, data warehousing concepts, and data transformation patterns.

Preferred Skills

• Experience with cloud platforms such as AWS, Microsoft Azure, or Google Cloud Platform.
• Familiarity with orchestration and scheduling tools such as Airflow or similar platforms.
• Experience with Git, CI/CD pipelines, and automated deployment practices.
• Exposure to Power BI, Tableau, or other BI and reporting platforms.
• Experience with Python for data processing and automation.
• Knowledge of data governance, metadata management, and data lineage.

Required Experience and Competencies

• Minimum 5+ years of relevant experience in data engineering, data warehousing, or Snowflake development.
• Strong hands-on experience with Snowflake, dbt, SQL, ETL/ELT, data migration, and data modelling.
• Ability to work independently as an individual contributor.
• Strong communication and stakeholder management skills.
• Experience interacting directly with customers or business stakeholders.
• Strong analytical, problem-solving, and troubleshooting capabilities.
• Ability to take ownership of technical deliverables from requirement gathering through implementation.