Sr Data Engineer with Medallion Architecture exp & Snowpro Certification - W2

Saransh Inc; Boca Raton (FL); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Saransh Inc. in Boca Raton, FL is seeking a Senior Data Engineer to architect and implement data pipelines using Medallion Architecture on Snowflake. The role emphasizes scalable ETL/ELT processes and robust data modeling in a hybrid, W2 contract setting.

The candidate will design Bronze/Silver/Gold data layers, develop advanced SQL, Snowflake scripting, and Python/Snowpark solutions, and ensure data quality, security, and performance. Mentorship of junior engineers is expected.

Qualifications

• Senior Data Engineer with 10+ years of experience.
• Must have Medallion Architecture expertise.
• SnowPro Certified Candidates preferred.

Responsibilities

• Design and develop Snowflake-based data solutions and ETL/ELT pipelines.
• Implement Medallion Architecture (Bronze, Silver, Gold).
• Develop complex SQL, Snowflake Scripting, Stored Procedures, Streams & Tasks.
• Implement CDC and incremental data processing.
• Design data models, schemas, fact/dimension tables, and SCD Type 1/2.
• Perform SQL/Snowflake performance tuning and production troubleshooting.
• Work with Snowpipe, Dynamic Tables, Stages, Views, and Materialized Views.
• Develop/support Streamlit applications with Snowflake.
• Work with Python/Snowpark and Azure Logic Apps.
• Implement data quality, auditing, reconciliation, security, and RBAC.
• Participate in code reviews and mentor junior engineers.

Skills

Snowflake Expert

SQL Expert

ETL / ELT

Medallion Architecture

Data Modeling & Database Design

Snowflake Scripting

Streams & Tasks

Stored Procedures

Data Warehousing

Tools

Snowflake

Python / Snowpark

Azure Logic Apps

REST APIs / JSON

Git / CI/CD

Job description

Role Summary

Medallion Architecture experience is mandatory.

We are looking for a Senior Data Engineer with strong hands-on expertise in Snowflake, SQL, ETL/ELT, Data Modelling, Database Design, and Medallion Architecture. The candidate should be experienced in building scalable data pipelines and working with cloud-based data platforms.

Role: Sr Data Engineer

Location: Boca Raton, FL (Hybrid)

Job Type: W2 Contract

Experience: 10+ years

Must

Look for SnowPro Certified Candidates.

Key Responsibilities

• Design and develop Snowflake-based data solutions and ETL/ELT pipelines.
• Implement Medallion Architecture (Bronze, Silver, Gold).
• Develop complex SQL, Snowflake Scripting, Stored Procedures, Streams & Tasks.
• Implement CDC and incremental data processing.
• Design data models, schemas, fact/dimension tables, and SCD Type 1/2.
• Perform SQL/Snowflake performance tuning and production troubleshooting.
• Work with Snowpipe, Dynamic Tables, Stages, Views, and Materialized Views.
• Develop/support Streamlit applications with Snowflake.
• Work with Python/Snowpark and Azure Logic Apps.
• Implement data quality, auditing, reconciliation, security, and RBAC.
• Participate in code reviews and mentor junior engineers.

Must-Have Skills

• Snowflake Expert
• SQL Expert
• ETL / ELT
• Medallion Architecture
• Data Modeling & Database Design
• Snowflake Scripting
• Streams & Tasks
• Stored Procedures
• Data Warehousing

Good To Have

• Streamlit
• Python / Snowpark
• Snowpipe / Dynamic Tables
• Azure Logic Apps
• Azure Data Services
• REST APIs / JSON
• Git / CI/CD
• Data Quality & Governance

Experience

• 8+ years in Data Engineering / Data Warehousing.
• 4+ years of Snowflake experience preferred.
• Strong experience in enterprise data pipelines and cloud data platforms.
• Strong production support and performance-tuning experience.