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

Saransh Inc

Boca Raton (FL)

Hybrid

USD 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer: Medallion + Snowflake Expert
Senior Data Engineer: Medallion + Snowflake Expert

Saransh Inc • Boca Raton (FL)

Hybrid
USD 120,000 - 160,000
Snowflake Architect
Snowflake Architect

Aroha Technologies, Inc • Raritan (NJ)

Hybrid
USD 96,000 - 165,000
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio

Infoorigin Inc • Columbus (OH)

Remote
USD 130,000 - 190,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Snowflake Data Engineer
Snowflake Data Engineer

TechDigital Group • North Wales

On-site
USD 100,000 - 130,000
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio

Info Origin Inc • Ohio

Remote
USD 83,000 - 96,000
Database Developer/Architect with Snowflake
Database Developer/Architect with Snowflake

RZS Recruitment • New York (NY)

Hybrid
USD 110,000 - 120,000
Senior Data Analyst-Snowflake (Direct Hire/ No Sponsorship)-( Local Chicago candidates only)
Senior Data Analyst-Snowflake (Direct Hire/ No Sponsorship)-( Local Chicago candidates only)

e.biT Consulting • Schaumburg (IL)

On-site
USD 110,000 - 140,000
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio
Senior Snowflake Data Engineer / Data Architect- Remote- Ohio

Infoorigin Inc • United States

Remote
USD 140,000 - 190,000