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

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

Summary

The Senior Enterprise Data Engineer will play a critical role in designing, building, and maintaining the ASPCA's enterprise data warehouse ecosystem. This role will be part of the Enterprise Data Engineering Operations team, which sits within the broader Product, Data, and Reporting Solutions (PDRS) department. The Engineer will develop and maintain dbt Core models and data workflows across the medallion architecture, integrate master data management (MDM) workflows into enterprise pipelines, and partner with cross-functional stakeholders to support the ASPCA's transition from siloed systems to a centralized enterprise data solution.Reporting to the Director, Enterprise Data Engineering Operations, the Senior Enterprise Data Engineer will ensure that data assets are accurate, performant, reliable, and aligned with organizational standards. The ideal candidate will combine strong technical skills with a collaborative mindset, thriving in a distributed data environment where clarity, consistency, and data quality are essential. The ideal candidate will bring deep hands-on expertise with dbt Core, strong dimensional and medallion data modeling skills, and substantial experience developing and supporting enterprise data pipelines using Microsoft Fabric and Azure Data Factory.

Who We Are

The Information Technology (IT) department supports and improves a broad portfolio of technologies to support our staff. IT ensures that all ASPCA staff, partners, and communities have the systems needed to work effectively and efficiently to improve animal welfare. The sub-teams within IT include Product, Data and Reporting Solutions, Operations and Information Security, Technical Support, Enterprise Architecture, and Business Operations.

What You'll Do

Senior Enterprise Data Engineer reports directly to the Director, Enterprise Data Engineering Operations, and has no direct reports.

Where and When You'll Work

This position (which requires travel, as described below) is an on-site role and reports to an Los Angeles ASPCA location.

  • Must be available for occasional off-hours support for critical data pipelines
  • Ability and willingness to travel up to 5% of the time as needed
Interview Information

Our interview process will include:

  • a reference check early in our process, during which we will ask you to provide 5 references, 2 of which must be at the manager level.
  • an in-person interview component, likely in New York City.
What You'll Get
Compensation

Starting pay for the successful applicant will depend on a variety of factors, including but not limited to education, training, experience, location, business needs, internal equity, market demands or budgeted amount for the role. The target hiring range is for new hire offers only, and compensation may increase beyond the maximum hiring range based on performance over time. The maximum of the hiring range is reserved for candidates with the highest qualifications and relevant experience. The expected hiring salary ranges for this role are set forth below and may be modified in the future.

$138,000-143,000 annually

For more information on our benefits offerings, visit our website.

Benefits

At the ASPCA, you don't have to choose between your passion and making a living. Our comprehensive benefits package helps ensure you can live a rewarding life at work and at home. Our benefits include, but are not limited to:

  • Affordable health coverage, including medical, employer-paid dental and optional vision coverage.
  • Flexible time off that includes vacation time, paid personal time, sick time, bereavement time, paid parental leave, and 10 company paid holidays that allows you even more flexibility to observe the days that mean the most to you.
  • Competitive financial incentives and retirement savings, including a 401(k) plan with generous employer contributions - we match dollar-for-dollar up to 4% and provide an additional 4% contribution toward your future each year.
  • Robust professional development opportunities, including classes, on-the-job training, coaching and mentorship with industry-leading peers, internal mobility, opportunities to support in the field and so much more.
Responsibilities

Responsibility buckets are listed in general order of importance. They include, but are not limited to:

  • Medallion Layer Data Modeling and Development
    • Architect, implement, and maintain dbt Core models across the medallion architecture, applying appropriate transformation patterns to meet operational, analytical, and dimensional data requirements
    • Integrate MDM workflows and reference data into medallion-layer transformations in alignment with enterprise data governance standards
    • Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models as defined by enterprise MDM policies
    • Build data models that power enterprise analytics, reporting, and other downstream uses
    • Implement modeling best practices (e.g., naming
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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: 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 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
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 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
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
Senior Data Analyst
Senior Data Analyst

Remote Jobs • New York (NY)

Remote
USD 77,000 - 99,000
Health coverage
401(k) with company match
Professional development
Principal Data Engineer
Principal Data Engineer

Careington International Corporation • Frisco (TX)

On-site
USD 150,000 - 190,000
Sr. Staff Systems Engineer
Sr. Staff Systems Engineer

Fivetran, Inc. • Michigan

On-site
USD 180,000 - 240,000