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

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health coverage
401(k) plan

Job summary

The Senior Enterprise Data Engineer at The American Society for the Prevention of Cruelty to Animals will design, build, and maintain ASPCA's data warehouse ecosystem within the Enterprise Data Engineering Operations team. The role focuses on dbt Core models, medallion architecture, and MDM workflows across enterprise pipelines, ensuring data accuracy, performance, and governance.

Reporting to the Director, the engineer will collaborate with cross-functional teams while supporting the transition

Qualifications

  • Experience designing and maintaining enterprise data warehouse ecosystems.
  • Experience integrating MDM workflows into enterprise pipelines.
  • Strong collaboration with cross-functional stakeholders.

Responsibilities

  • Architect, implement, and maintain dbt Core models across the medallion architecture.
  • Integrate MDM workflows and reference data into medallion-layer transformations.
  • Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models.
  • Build data models that power enterprise analytics, reporting, and other downstream uses.
  • Implement modeling best practices.

Skills

dbt Core
Dimensional data modeling
Medallion architecture
Enterprise data pipelines
Data governance

Tools

Microsoft Fabric
Azure Data Factory

Job description

The Senior Enterprise Data Engineer at The American Society for the Prevention of Cruelty to Animals will design, build, and maintain ASPCA's data warehouse ecosystem within the Enterprise Data Engineering Operations team. The role focuses on dbt Core models, medallion architecture, and MDM workflows across enterprise pipelines, ensuring data accuracy, performance, and governance.

Reporting to the Director, the engineer will collaborate with cross-functional teams while supporting the transition

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Enterprise Data Engineer: Medallion DW + dbt Expert
Senior Enterprise Data Engineer: Medallion DW + dbt Expert

ASPCA • Village of Pelham (NY)

On-site
USD 138,000 - 143,000
Affordable health coverage
Flexible time off
Competitive retirement savings
+1
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 - (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
Senior Enterprise Data Engineer - (on site NYC)
Senior Enterprise Data Engineer - (on site NYC)

ASPCA • Village of Pelham (NY)

On-site
USD 138,000 - 143,000
Affordable health coverage
Flexible time off
Competitive retirement savings
+1
Remote Senior Data Analyst — Shelter Analytics & Insights
Remote Senior Data Analyst — Shelter Analytics & Insights

Remote Jobs • New York (NY)

Remote
USD 77,000 - 99,000
Health coverage
401(k) with company match
Professional development
Senior Data Engineer – Data Warehousing & Cloud ETL
Senior Data Engineer – Data Warehousing & Cloud ETL

AAMC • United States

Remote
USD 128,000 - 150,000
Hybrid/remote work
Health & Wellness
Paid time off
+3
Senior Integration Platform Architect (Hybrid/Remote)
Senior Integration Platform Architect (Hybrid/Remote)

ASPCA • United States

Hybrid
USD 137,000 - 142,000
Health coverage
Flexible time off
401(k) with company match
+1
Director, Data Engineering & Modeling — Data Product Leader
Director, Data Engineering & Modeling — Data Product Leader

Mars Petcare • Vancouver (WA)

On-site
USD 140,000 - 241,000
Competitive salary
Health insurance
Paid time off
+2
Senior Data Engineer: Medallion + Snowflake Expert
Senior Data Engineer: Medallion + Snowflake Expert

Saransh Inc • Boca Raton (FL)

Hybrid
USD 120,000 - 160,000