Snowflake Data Engineer / Senior Data Engineer - W2

Job Description – Snowflake Data Engineer / Senior Data Engineer

Experience: 5–12 Years (Flexible based on expertise)
Primary Skills: Snowflake, ETL, DBT
Good to Have: Snowflake Cortex AI, Railway / Transportation Domain

Job Summary

We are looking for an experienced Snowflake Data Engineer with strong expertise in Snowflake, ETL development, and DBT. The candidate should have hands-on experience designing, developing, and maintaining scalable data pipelines and implementing efficient data transformation solutions.

Experience working with Snowflake Cortex AI and railway or transportation-related projects will be an added advantage.

Key Responsibilities

- Design, develop, and maintain scalable data pipelines using Snowflake.
- Build and optimize ETL/ELT workflows for integrating data from multiple source systems.
- Develop and maintain DBT models, including staging, intermediate, and data mart layers.
- Implement incremental data loads, CDC mechanisms, and data transformation logic.
- Perform Snowflake query optimization and performance tuning.
- Work with Snowflake features such as Streams, Tasks, Dynamic Tables, and Snowpipe.
- Implement data quality checks, data reconciliation, and validation processes.
- Collaborate with architects, business analysts, and other engineering teams.
- Support data migration, integration, and production deployment activities.

Required Skills

- Strong hands-on experience in Snowflake.
- Good experience in ETL/ELT development and data integration.
- Hands-on experience with DBT (models, tests, snapshots, macros, and incremental models).
- Strong SQL skills, including complex queries and stored procedures.
- Experience with data warehousing concepts and dimensional data modelling.
- Knowledge of data pipeline orchestration and scheduling.
- Experience handling large volumes of data and optimizing performance.

Good to Have Skills

- Exposure to Snowflake Cortex AI, Cortex Search, Cortex Analyst, or AI-powered data solutions.
- Experience with Snowflake Snowpark and Python.
- Experience with cloud platforms such as AWS or Azure.
- Experience in railway, transportation, logistics, or supply chain domain.
- Understanding of railway operational data, train movements, schedules, events, and operational reporting.
- Experience with CDC, Kafka, or real-time data integration.

Preferred Domain Experience

Candidates with experience in railway or transportation projects will be given preference, particularly those who have worked on:

- Train scheduling and movement data.
- Train tracking and operational events.
- Locomotive and equipment data.
- Operational reporting and KPI dashboards.
- Integration of multiple railway source systems.

Education

Bachelor's or Master's degree in Computer Science, IT, Engineering, or a related discipline