Middle Data Engineer — Snowflake & dbt & Azure
Below market
Data Smart Solutions LLC
$600 – 800
21 people applied
Job Details
Middle Data Engineer — Snowflake / dbt / Azure
We are looking for a Middle Data Engineer with strong Snowflake, SQL and dbt skills to build and support production data pipelines.
Salary: $600 – $800 (Net) + performance-based bonus
Format: Remote
Core Requirements
• 2+ years of data engineering experience
• Hands-on experience with Snowflake: streams, Time Travel, data sharing, and standard, transient, hybrid and Iceberg tables
• Advanced SQL skills (live coding in Snowflake is part of the interview)
• Experience with dbt: macros shared across projects, pre- and post-hooks, SCD Type 2
• Experience with Azure Data Factory or Azure Synapse Pipelines, including self-hosted integration runtimes
• Python and PySpark
• Git and pull-request workflows, code review and automated testing
Nice to Have
• Azure Function Apps and Logic Apps
• Microsoft Defender for scanning incoming files
• Databricks
• Orchestration tools (e.g. Airflow)
What You'll Work On
• Hourly ingestion from SQL Server and 24/7 OLTP systems
• Ingesting files from customer NAS shares and APIs into Azure Blob Storage
• Building and maintaining dbt models in Snowflake
• Handling production issues: schema changes, failed hooks, missing files and jobs that fail halfway
What We Offer
• Fully remote work
• Performance-based bonus
• Professional growth opportunities
Hiring Process
1. Online coding assessment
2. Technical interview
3. Final discussion with the manager
AI tools and outside help are not allowed during interviews. Sessions are recorded.
Ready to apply? Apply via form.
Below market
Stay cautious
If you are asked to send SMS codes, install something, transfer money, or do anything else related to money — do not agree: these are signs of fraud. We strive to verify employers' information, but we are not responsible for its accuracy.