Snowflakes Data Engg

Work Experience : 5+ Years at least

We are looking to hire a Data Engineer with strong expertise in Snowflake, Datawarehousing and end-to-end migration from legacy systems like SQL/Oracle/MySQL databases. Candidates should have hands-on-experience building robust data pipelines, creating ETL/ELT processes and designing scalable data architectures in Snowflake.The new hire will take part in modernizing the data ecosystem and building a Modern Data Platform.

Should have strong analytical and problem-solving skills. Will be able to communicate with the client independently. Should be familiar and willing to work in a fast-paced Agile environment. Take ownership of the tasks and work with team to meet the timelines.

Main Responsibilities:

Snowflake Development & Engineering

• Design, develop, and optimize Snowflake data models, warehouses, schemas, stages, and virtual warehouses.
• Implement Snowflake features such as Time Travel, Streams, Tasks, Clustering Keys, and Snowpipe.
• Build secure and scalable data sharing, role-based access, and governance processes.

Data Migration & ETL/ELT Workflows Lead end-to-end data migration  from legacy systems (primarily SQL Server , plus Oracle, MySQL, or flat files as needed).

• Design and implement ETL/ELT pipelines  using Snowflake, SQL, and tools such as ADF, DBT, Matillion, Fivetran, or Informatica.
• Perform data extraction, transformation, reconciliation, and validation to ensure accuracy and completeness.
• Optimize data ingestion processes for performance, cost efficiency, and reliability.

SQL & Performance Optimization

• Write high-performance SQL for complex data transformations.
• Tune queries in both Snowflake and on-premise SQL Server systems.
• Troubleshoot performance bottlenecks, warehouse sizing, and query optimization.

Data Architecture & Standards Collaborate with architects to define data models, schemas, naming conventions, and documentation standards.

• Contribute to design of scalable Lakehouse or Warehouse architectures .
• Ensure compliance with internal security, privacy, and governance policies.

Collaboration & Project Execution

• Work closely with business analysts, product owners, and engineering teams to understand requirements.
• Support UAT, production deployment, and post-migration validation.
• Participate in Agile ceremonies and contribute to continuous improvement.

Required Qualifications : 5+ years of professional experience in Data Engineering .

Strong hands-on experience with Snowflake  (SnowSQL, Snowpipe, Streams/Tasks, Virtual Warehouses, Time Travel, RBAC, etc.).

Proven experience migrating data from SQL Server to Snowflake  (or similar legacy-to-cloud migrations).

Strong SQL skills with ability to write complex queries and troubleshoot performance issues.

Experience with ETL/ELT tools such as Azure Data Factory, DBT, Matillion, Fivetran, Informatica, Airflow , or equivalent.

Strong understanding of data warehouse concepts , dimensional modeling, and best practices.

Experience with Cloud platforms  (Azure, AWS, or GCP).

Preferred Qualifications Experience with Python  for data processing and automation.

• Experience with CI/CD, DevOps , or Git-based versioning for data pipelines.
• Familiarity with continuous data migration, CDC techniques, and large-volume data loading.
• Knowledge of performance tuning in Snowflake using clustering, micro-partitions, and warehouse optimization.
• Snowflake certifications (SnowPro Core, SnowPro Advanced Architect/Engineer).

AWS/Azure or any Snowflake certification is a must, please do not apply if you are not certified

You should have an inclination for learning new tech as required and be able to work on multiple projects, delivering on deadlines in weekly sprints.

• Salary Range - It can be negotiated based on experience and interview performance.
• Interview Rounds : at least 4 with 1 of them being a hands on round
• Paid Leaves : 18 days per year
• Location - Remote
• Shift - Expected to work till 3:00 am - IST

We are based out of US so only work with overseas clients and applicants should be ready to work till the time mentioned above.