Snowflake Data Engineer - ONLY W2 - Except CPT OPT

We are hiring a Snowflake Data Engineer - NJ - Contract - W2.

Job Description:

We are looking for an experienced Snowflake Data Engineer with strong hands-on expertise in data pipelines, SQL, and Snowflake architecture, along with solid experience in production support, monitoring, incident resolution, and performance optimization.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake, SQL, and cloud data tools.
• Perform Snowflake performance tuning, query optimization, and warehouse cost optimization.
• Handle production support activities, including incident management, root cause analysis, debugging failures, and ensuring data pipeline reliability.
• Monitor jobs, troubleshoot data issues, and maintain SLA adherence.
• Work with cloud platforms (AWS/Azure/Google Cloud Platform) for data ingestion and integration.
• Collaborate with cross-functional teams (Data Engineering, DevOps, Analytics).
• Implement Snowflake features like Snowpipe, Streams, Tasks, Time Travel, and Role-Based Access Control.
• Participate in on-call rotations for production support as needed.

Required Skills

• 3–8 years of experience in Data Engineering.
• Strong knowledge of Snowflake architecture, query profiling, and tuning.
• Expertise in SQL, stored procedures, and data modeling concepts.
• Hands-on experience with production support, job monitoring, and issue resolution.
• Experience with ETL tools (Informatica, Matillion, DBT, ADF, Glue—any).
• Experience with cloud services (AWS/Azure/Google Cloud Platform).
• Knowledge of CI/CD pipelines, Git, and automation preferred.
• Understanding of data quality frameworks and best practices.