Apply on Employer Site

Canyon · 1 month ago

Data Warehouse Data Engineer

Tinton Falls, NJ

Full-time

Onsite

Mid Level

$120K/yr - $155K/yr

Canyon Associates is seeking a Data Warehouse Data Engineer to design and maintain ETL/ELT pipelines. The role involves data modeling, automation of data transformations, and collaboration with BI Analysts to optimize data for business intelligence consumption.

Events

No H1B

U.S. Citizen Only

Responsibilities

Design, build, and maintain ETL/ELT pipelines using Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Spark) and legacy SSIS

Develop ingestion frameworks for flat files (CSV/Excel), APIs, SaaS platforms, cloud feeds, and partner data

Implement medallion architecture (Bronze, Silver, Gold) using Lakehouse (Delta Lake), Warehouse, and OneLake

Automate data transformations using SQL, PySpark, and Fabric Notebooks

Build and optimize star schema models, conformed dimensions, and fact tables for BI consumption

Implement incremental loads, SCD handling (Type 1/2), partitioning, Z-ordering, compaction, and other Delta Lake optimization techniques

Collaborate with BI Analysts to translate business requirements into performant data models

Qualification

Data EngineeringETL/ELTData ModelingT-SQLAzureSSISPySparkMicrosoft FabricDelta LakeBusiness Intelligence

Required

Must be USC or GC

Strong Data Engineer skills

Data modeling experience

Experience with SSIS

Proficiency in T-SQL

Experience with Azure

Experience with ETL/ELT processes

Design, build, and maintain ETL/ELT pipelines using Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Spark) and legacy SSIS

Develop ingestion frameworks for flat files (CSV/Excel), APIs, SaaS platforms, cloud feeds, and partner data

Implement medallion architecture (Bronze, Silver, Gold) using Lakehouse (Delta Lake), Warehouse, and OneLake

Automate data transformations using SQL, PySpark, and Fabric Notebooks

Build and optimize star schema models, conformed dimensions, and fact tables for BI consumption

Implement incremental loads, SCD handling (Type 1/2), partitioning, Z-ordering, compaction, and other Delta Lake optimization techniques

Collaborate with BI Analysts to translate business requirements into performant data models

Benefits

401(k)

Dental insurance

Health insurance

Paid time off

Vision insurance

Company

Canyon

Canyon is a pioneering live communication agency.

Founded in 2006

Manchester, Manchester, GBR

11-50 employees

http://www.canyonwebsite.co.uk/

Funding

Current Stage

Early Stage

Total Funding

unknown

2012-08-16Acquired

Company data provided by crunchbase