Senior Data Engineer: Medallion + Snowflake Expert

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

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.