Data Engineer – Snowflake & dbt on Hybrid/Remote

AspenView Technology Partners; United States; Hybrid; USD 120,000 - 150,000; Full time

Job summary

AspenView Technology Partners is seeking a Data Engineer 2 to join a dynamic team building data pipelines for sports and entertainment. You will design, implement, and maintain data ingestion from cloud and on‑prem sources into Snowflake, using ADF for orchestration and dbt for in‑warehouse transformations.

Responsibilities include modeling, testing, and optimizing pipelines; implementing dimensional models; data quality, and collaborating with analytics stakeholders.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, or a related field.
• 3–5 years of hands‑on data engineering or analytics engineering experience.
• Snowflake: Strong hands‑on experience with Snowflake architecture (virtual warehouses, staging, zero‑copy cloning, tasks/streams, and performance tuning).
• dbt: Demonstrated proficiency with dbt (Core or Cloud) for modular transformation, macro development, testing, and documentation.
• Azure Data Factory: Hands‑on experience creating, configuring, monitoring, and troubleshooting ADF pipelines, linked services, integration runtimes, and parameterization.
• SQL & Modeling: Advanced SQL expertise and proven experience with dimensional data modeling concepts.
• Python & Cloud Storage: Proficient in Python scripting and familiar with Azure cloud storage patterns (ADLS Gen2, Azure Blob Storage).
• Analytics Engineering / DevOps: Practical experience with Git, CI/CD pipeline automation for data code, and automated testing patterns.
• Experience integrating data layers with modern BI visualization tools (e.g., Power BI, Tableau).

Responsibilities

• Design, build, and maintain automated data ingestion pipelines from cloud and on‑premises sources into Snowflake using Azure Data Factory (ADF).
• Translate business requirements into efficient ELT workflows using ADF for orchestration/ingestion and dbt (Core or Cloud) for in‑warehouse transformations.
• Build, test, and document scalable data models and transformations in dbt layered directly on Snowflake.
• Monitor, schedule, and optimize ADF pipelines, dataset triggers, and dbt runs to ensure high pipeline reliability and data freshness.
• Implement dimensional data models (Star/Snowflake schemas) optimized for Snowflake performance and cost efficiency.
• Perform data cleansing, standardization, and staging using ADLS Gen2/Blob storage landing zones.
• Write Python code (or Azure Functions/Snowpark routines) to handle complex API extractions, custom transformations, and automated utility tasks.

Skills

Snowflake

dbt

Azure Data Factory

SQL

Python

BI Tools

Git

Education

Bachelor's degree in Information Systems, Computer Science, or related field

Tools

Azure Data Factory

Snowflake

dbt

Job description

AspenView Technology Partners is seeking a Data Engineer 2 to join a dynamic team building data pipelines for sports and entertainment. You will design, implement, and maintain data ingestion from cloud and on‑prem sources into Snowflake, using ADF for orchestration and dbt for in‑warehouse transformations.

Responsibilities include modeling, testing, and optimizing pipelines; implementing dimensional models; data quality, and collaborating with analytics stakeholders.