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

Role: Sr Data Engineer Location: Boca Raton, FL (Hybrid) Job Type: W2 Contract Experience: 10+ years Must Look for SnowPro Certified Candidates. 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.

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.