Senior Enterprise Data Engineer: Medallion DW + dbt Expert

ASPCA

Village of Pelham (NY)

On-site

USD 138,000 - 143,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Affordable health coverage
Flexible time off
Competitive retirement savings
Professional development opportunities

Job summary

The ASPCA in New York City seeks a Senior Enterprise Data Engineer to design, build, and maintain our enterprise data warehouse and medallion architecture. You will develop dbt Core models and integrate MDM workflows across enterprise pipelines.

Reporting to the Director of Enterprise Data Engineering Operations, you will collaborate with cross-functional teams in a distributed environment, ensuring data quality, governance, and scalable data solutions using Fabric, Azure Data Factory, and

Qualifications

  • DBT Core modeling across medallion architecture.
  • Production data pipelines design and support.
  • Experience with Microsoft Fabric or Azure Data Factory.

Responsibilities

  • Architect, implement, and maintain dbt Core models across the medallion architecture.
  • Integrate MDM workflows and reference data into medallion-layer transformations.
  • Optimize SQL and dbt Core transformations for performance and scalability.
  • Collaborate with Data Management & BI teams to deliver analytics-ready datasets.
  • Support CI/CD and governance standards across pipelines.

Skills

Data modeling
SQL
Data governance
Collaboration
Problem solving

Education

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

Tools

dbt Core
Microsoft Fabric
Azure Data Factory
Snowflake
Git/GitHub

Job description

The ASPCA in New York City seeks a Senior Enterprise Data Engineer to design, build, and maintain our enterprise data warehouse and medallion architecture. You will develop dbt Core models and integrate MDM workflows across enterprise pipelines.

Reporting to the Director of Enterprise Data Engineering Operations, you will collaborate with cross-functional teams in a distributed environment, ensuring data quality, governance, and scalable data solutions using Fabric, Azure Data Factory, and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer, Enterprise Platform & Medallion
Senior Data Engineer, Enterprise Platform & Medallion

ASPCA • New York (NY)

On-site
USD 138,000 - 143,000
Senior Enterprise Data Engineer - Medallion & MDM Expert
Senior Enterprise Data Engineer - Medallion & MDM Expert

The American Society for the Prevention of Cruelty to Animals • United States

On-site
USD 138,000 - 143,000
Health coverage
401(k) plan
Senior Enterprise Data Engineer - (on site Los Angeles)
Senior Enterprise Data Engineer - (on site Los Angeles)

The American Society for the Prevention of Cruelty to Animals • United States

On-site
USD 138,000 - 143,000
Health coverage
401(k) plan
Senior Enterprise Data Engineer - (on site NYC)
Senior Enterprise Data Engineer - (on site NYC)

ASPCA • New York (NY)

On-site
USD 138,000 - 143,000
Data Architect & Engineer: Medallion Lakehouse & dbt Expert
Data Architect & Engineer: Medallion Lakehouse & dbt Expert

BTI Solutions, Inc. • Plano (TX)

On-site
USD 120,000 - 160,000
Senior Data Engineer: Enterprise Data Platform & Fabric
Senior Data Engineer: Enterprise Data Platform & Fabric

Compunnel Inc. • Newark (NJ)

On-site
USD 140,000 - 170,000
Senior Full-Stack BI Architect & Fabric Data Engineer Remote
Senior Full-Stack BI Architect & Fabric Data Engineer Remote

Proactive Technology Management • Ferndale (WA)

Remote
USD 140,000 - 190,000
Competitive compensation
Shape data strategy and lead BI/ data‑
Professional development and training
+4
Remote Senior Data Engineer: AWS, Data Mesh & Medallion
Remote Senior Data Engineer: AWS, Data Mesh & Medallion

Wise Integration • United States

Remote
USD 68,000 - 117,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Newark (NJ)

On-site
USD 140,000 - 170,000
Senior Data Engineer: Medallion + Snowflake Expert
Senior Data Engineer: Medallion + Snowflake Expert

Saransh Inc • Boca Raton (FL)

Hybrid
USD 120,000 - 160,000