Senior Data Engineer, Enterprise Platform & Medallion

ASPCA

New York (NY)

On-site

USD 138,000 - 143,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

ASPCA is seeking a Senior Enterprise Data Engineer to design, build, and maintain the enterprise data warehouse ecosystem. You will develop and maintain dbt Core models across the medallion architecture and integrate MDM workflows into enterprise pipelines.

Based in New York, this on-site role reports to the Director, Enterprise Data Engineering Operations and requires up to 5% travel. Strong SQL, dbt, and cloud data warehousing skills are essential for delivering analytics-ready data assets.

Qualifications

  • 5+ years of hands-on experience building, maintaining, and optimizing dbt Core transformation pipelines across medallion architectures in production environments (Required)
  • 5+ years of experience designing, implementing, and supporting production data pipelines using Microsoft Fabric or Azure Data Factory, including orchestration, monitoring, operational support, and troubleshooting of enterprise data workflows (Required)
  • Demonstrated experience applying dimensional modeling and enterprise data modeling practices (e.g., star schemas, SCDs, conformed dimensions) (preferred)
  • 3+ years of experience designing and maintaining data warehouse models and transformation workflows (Required)
  • Experience integrating mastered entities and reference data from commercial MDM platforms into enterprise data pipelines (preferred; Reltio preferred)
  • Bachelor’s degree in CS/IS/Engineering and related field, English language proficiency (Required)

Responsibilities

  • Architect, implement, and maintain dbt Core models across the medallion architecture, applying transformation patterns to meet data requirements
  • 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 to power enterprise analytics and reporting
  • Optimize SQL code and dbt Core transformations for performance and scalability
  • Design, build, and maintain robust pipelines for ingestion, transformation, and delivery
  • Implement scalable job orchestration, monitoring, alerting, testing, and error-handling
  • Preserve version control and support CI/CD for deployment
  • Troubleshoot data quality and freshness issues across Fabric, dbt Core, Snowflake
  • Collaborate with Data Management & BI and Strategy & Research teams; support data governance and metadata practices
  • Contribute to code reviews and knowledge-sharing; evaluate emerging tools and technologies

Skills

dbt Core
SQL
Python
Git/GitHub
ELT patterns
Data Modeling
Snowflake
Microsoft Fabric
Azure Data Factory
dbt Projects

Education

Bachelor’s degree in CS/IS/Engineering

Tools

Snowflake
Azure Data Factory
Microsoft Fabric
Git

Job description

ASPCA is seeking a Senior Enterprise Data Engineer to design, build, and maintain the enterprise data warehouse ecosystem. You will develop and maintain dbt Core models across the medallion architecture and integrate MDM workflows into enterprise pipelines.

Based in New York, this on-site role reports to the Director, Enterprise Data Engineering Operations and requires up to 5% travel. Strong SQL, dbt, and cloud data warehousing skills are essential for delivering analytics-ready data assets.

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 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
Senior Data Platform Engineer: Snowflake, dbt & ELT
Senior Data Platform Engineer: Snowflake, dbt & ELT

Advanced Medical Management, Inc. • Long Beach (CA)

On-site
USD 130,000 - 180,000
Full health coverage
401(k) and retirement plans
Tuition reimbursement
+1
Senior Data Engineer: Medallion + Snowflake Expert
Senior Data Engineer: Medallion + Snowflake Expert

Saransh Inc • Boca Raton (FL)

Hybrid
USD 120,000 - 160,000
Senior Data Engineer: Enterprise Data & Analytics Architect
Senior Data Engineer: Enterprise Data & Analytics Architect

MedVet Medical & Cancer Centers for Pets • United States

On-site
USD 130,000 - 190,000
Comprehensive Health Benefits
Vision and Dental
401k with Employer Match
+4
Senior Data Engineer — Hybrid BI, ETL & Analytics
Senior Data Engineer — Hybrid BI, ETL & Analytics

PetSmart, Inc. • Phoenix (AZ)

Hybrid
USD 120,000 - 180,000
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
Senior Data Engineer

MedVet Medical & Cancer Centers for Pets • United States

On-site
USD 130,000 - 190,000
Comprehensive Health Benefits
Vision and Dental
401k with Employer Match
+4