Senior Data Engineer

Job Title: Senior Data Engineer 
Location:  Boca Raton FL
Job Type:  Contract

Role Summary
We are looking for a Senior Data Engineer with strong hands-on expertise in Snowflake, SQL, ETL/ELT, Data Modeling, 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 Snow pipe, Dynamic Tables, Stages, Views, and Materialized Views.
Develop/support Stream lit 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.
Good communication, problem-solving, and technical leadership skills.