Onsite Data Engineer - Snowflake/dbt Pipeline Expert

Soaring Eagle Data Solutions; Apollo Beach (FL); On-site; USD 110,000 - 120,000; Full time

Benefits offered by this job

401(k)

401(k) matching

Health insurance

Dental insurance

Vision insurance

Flexible schedule

Job summary

Soaring Eagle Data Solutions is seeking an onsite data engineering consultant to build and optimize data pipelines for Snowflake using dbt. The role focuses on developing dbt models, designing Snowflake environments, migrating SQL Server data, and delivering clean, well-tested SQL in a production setting.

The ideal candidate will have hands-on Snowflake experience, dbt Core or Cloud proficiency, strong SQL/T-SQL, and a background in data warehousing.

Qualifications

• Hands-on Snowflake production experience required.

Responsibilities

• Develop and maintain dbt models and data transformations
• Design, implement, and tune Snowflake environments including warehouses, schemas, security, and performance
• Migrate and integrate data from SQL Server into Snowflake
• Write clean, efficient, and well-tested SQL
• Collaborate with client stakeholders to gather requirements and translate business needs into technical solutions
• Propose best practices across data architecture, governance, and cost optimization

Skills

Snowflake

dbt Core/Cloud

SQL

Data warehousing concepts

T-SQL

Stored procedures

SSIS

Git

CI/CD

Airflow

Dagster

Azure

AWS

GCP

Tools

SQL Server

SSIS

T-SQL

Snowflake

dbt Core/Cloud

Git

CI/CD

Airflow

Dagster

Azure

AWS

GCP

Job description

Soaring Eagle Data Solutions is seeking an onsite data engineering consultant to build and optimize data pipelines for Snowflake using dbt. The role focuses on developing dbt models, designing Snowflake environments, migrating SQL Server data, and delivering clean, well-tested SQL in a production setting.

The ideal candidate will have hands-on Snowflake experience, dbt Core or Cloud proficiency, strong SQL/T-SQL, and a background in data warehousing.