Six Figure Work

Senior Enterprise Data Engineer - (on site Los Angeles)

ASPCA

Company websiteaspca.org (ASPCA, opens in new tab)

Base salary $138K – $143K

Employer-published annual base salary, USD. Advertised base range in Area, LA

Apply (opens in new tab)

You apply on the employer's own site. Six Figure Work does not handle applications.

  • LocationArea, LA
  • WorkplaceWorkplace not stated
  • Status at last checkSource accepting applications when checked
  • Last checked (1 h ago) · observed since

About this job

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 conventions, documentation, testing, and lineage tracking) across all layers to ensure dbt Core models comply with enterprise governance standards and quality, performance, and security requirements
  • Optimize SQL code and dbt Core transformation logic to ensure efficient, scalable, and maintainable data pipelines

 

Pipeline Orchestration and Operations

  • Design, build, and maintain robust pipelines that support data ingestion, transformation, and delivery while adhering to engineering standards for well-structured code, clear documentation, and idempotent processing
  • Implement and maintain scalable job orchestration, monitoring, alerting, automated testing, and error-handling capabilities
  • Preserve version control for pipeline code artifacts and support CI/CD workflows to ensure reliable deployment of changes
  • Troubleshoot pipeline problems, such as issues with data quality and concerns over data freshness, across Microsoft Fabric, dbt Core, and Snowflake
  • Conduct root cause analysis and proactively drive pipeline improvements

 

Collaboration, Alignment, and Data Quality

  • Work closely with the Data Management & BI team to align on definitions, requirements, and expectations, ensuring that engineered datasets are accurate, trusted, and analytics-ready
  • Collaborate with the Strategy & Research team to deliver granular, well-structured Silver-layer datasets that support statistical analysis, data science modeling, and operational insights
  • Support enterprise data governance and data quality through strong metadata practices and clear documentation of transformation logic
  • Identify opportunities to improve data workflows, automate processes, and reduce technical debt
  • Participate in code reviews, knowledge-sharing sessions, and team-wide initiatives that strengthen engineering quality and consistency
  • Contribute to the advancement of the ASPCA's data ecosystem by evaluating emerging tools and technologies

Qualifications

  • Excellent analytical and problem-solving skills, with a strong commitment to data quality
  • Ability to collaborate effectively with both technical and non-technical partners
  • Solid written and verbal communication skills, with the ability to clearly convey data and technical concepts
  • Comfortable operating in a highly distributed, cross-functional environment
  • Skilled at managing multiple priorities, shifting requirements, and changing timelines
  • Demonstrates curiosity, creativity, and a willingness to experiment and learn
  • Takes initiative and works independently while valuing teamwork
  • Welcomes feedback and proactively seeks opportunities to improve systems and workflows
  • Values diversity of thought and embraces an inclusive, collaborative team culture
  • Ability to exemplify ASPCA’s core values and behavioral competencies

Technical Requirements

  • Expert-level proficiency in dbt Core is required, including advanced model design, macro development, custom tests, documentation practices, performance optimization, and integration with automated deployment pipelines
  • Advanced proficiency with Microsoft Fabric and/or Azure Data Factory for enterprise pipeline orchestration, monitoring, scheduled and event-driven workflows, Lakehouse integration, operational support, and troubleshooting of production data pipelines
  • Deep knowledge of data warehousing principles, including dimensional modeling, medallion architecture, and ELT transformation patterns
  • Strong SQL skills required
  • Python experience preferred
  • Familiarity with Git/GitHub workflows and DevOps CI/CD practices
  • Experience with cloud-native or SaaS-based data engineering tools
  • Proficiency with Snowflake is strongly preferred, including warehouse configuration, performance tuning, query optimization, cost management, and implementing role-based access controls
  • Familiarity with Snowflake-native dbt Projects, including development, deployment, scheduling, monitoring, configuration management, and version upgrades of dbt workloads within Snowflake, is strongly preferred

Education and Work Experience

  • High School Diploma,  GED, or equivalent experience (Required); Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field preferred
  • 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)
  • 3+ years of experience working within modern cloud data warehouse environments required; experience with Snowflake is strongly preferred
  • Experience integrating mastered entities and reference data from commercial Master Data Management (MDM) platforms into enterprise data pipelines preferred; Reltio preferred
  • Experience working within structured DevOps workflows, version control, and automated delivery pipelines preferred

Language:

English (Required)

Education and Work Experience:

High School Diploma, GED, or Equivalent Experience (Required)

Source: ASPCA on Workday · View original posting (opens in new tab)

How this pay compares

Base floor $138,000, above 27% of the 4,420 Data & ML roles nationwide on this site; the other 73% list the same floor or a higher one. The employer's range is $5,000 wide, 4% of the floor. Observed open for 10 days so far (since Nov 9, 2026).

Pay in context

Among 4,420 Data & ML roles nationwide listed on this site, the median base floor is $165,000 and the middle half runs from $135,000 to $197,300. This role's floor ($138,000) is above 27% of them; 7 others list the same floor.

Base floors of 4,420 Data & ML roles nationwide

Base floors of 4,420 Data & ML roles nationwide$100K to $125K: 17.1% (757); $125K to $150K: 20.6% (911); $150K to $175K: 19.8% (873); $175K to $200K: 18.9% (834); $200K to $225K: 11.4% (503); $225K to $250K: 5.2% (232); $250K to $275K: 3.1% (135); $275K and up: 4.0% (175)0%8%16%24%17%10021%12520%15019%17511%2005%2253%2504%275This job $138K
Each bar counts postings on this site by published base floor, in $K. The marker is this job's floor.
Table
Base floors of 4,420 Data & ML roles nationwide
Floor bandSharePostings
$100K to $125K17.1%757
$125K to $150K20.6%911
$150K to $175K19.8%873
$175K to $200K18.9%834
$200K to $225K11.4%503
$225K to $250K5.2%232
$250K to $275K3.1%135
$275K and up4.0%175
How this is calculated
Statistic
Base floor distribution of the cohort
Formula
count of cohort postings in each $25K band of published base floor / postings in the cohort
Denominator
4,420 open postings with this job family nationwide
Sample size
4420
Hidden when
the cohort has fewer than 30 postings
Calculation version
jobpage-analysis-v1
Data as of
2026-11-20
Employer set
Open jobs on this site that publish a base salary of $100,000 or more

Only jobs on this site count, and each one publishes a base salary of $100,000 or more, so this compares six-figure jobs with each other, not with the whole market. Computed Nov 20, 2026.

How ASPCA pays

3 of ASPCA's 8 live roles on this site list a higher base floor and 3 list a lower one. Across them the median floor is $138,000; the middle half runs from $121,625 to $148,375.

Base floors of ASPCA's 8 live roles

Base floors of ASPCA's 8 live roles$100K to $125K: 37.5% (3); $125K to $150K: 50.0% (4); $150K to $175K: 12.5% (1)0%15%30%45%38%10050%12512%150This job $138K
Each bar counts this employer's live roles by published base floor, in $K. The marker is this job's floor.
Table
Base floors of ASPCA's 8 live roles
Floor bandShareRoles
$100K to $125K37.5%3
$125K to $150K50.0%4
$150K to $175K12.5%1
How this is calculated
Statistic
Employer base floor distribution
Formula
count of the employer's open roles in each $25K band of published base floor / its open roles
Denominator
8 open public roles at this employer
Sample size
8
Hidden when
this employer has fewer than 5 roles
Calculation version
jobpage-analysis-v1
Data as of
current
Employer set
Open jobs on this site that publish a base salary of $100,000 or more

Similar pay elsewhere

Other employers' Data & ML roles nationwide with the nearest published base floor to $138,000, one per employer.

This range next to 6 other live ASPCA roles with the nearest advertised base floor
Chart as a table
This range next to 6 other live ASPCA roles with the nearest advertised base floor
RolePublished base
Senior Enterprise Data Engineer - (on site Los Angeles) (this listing)$138K - $143K
Senior Enterprise Data Engineer - (on site NYC)$138K - $143K
Veterinarian$148K - $156K
Salesforce Technical Lead$149,500 - $156,500
Veterinarian, Cruelty Recovery Center$123K - $142K
Veterinary Practice Director$117,500 - $132,000
Veterinary Practice Director - Mobile Veterinary Services$117,500 - $132,000

Same $100K to $400K scale as every card. All ASPCA roles · How to read the bar

Observed changes

  1. First observed on the employer's board, already publishing a qualifying base salary
  2. Listing details edited by the employer
  3. Stopped meeting the published-salary criteria
Observed since
Employer-stated posting date
2026-11-10
Where this pay comes from

Location as the employer wrote it: LA Area

- $138,000-143,000 annually

Method
Employer text, read with fixed rules and re-verified
Checked
Rule set
us-base-v2

The pay passage appears in the employer's own job text. Fixed, deterministic rules located it, and the passage below was checked against the stored copy of the posting.

What we verified

  • The pay figures come from the employer's own listing, quoted exactly above.
  • The pay is an annual base salary in US dollars with a minimum of at least $100,000.
  • The role was publicly listed on the employer's job board when last checked.

We do not verify what the employer will actually offer, whether the employer is still recruiting for the role, or anything beyond what the employer published. Full methodology.

Get Six Figure Work by email

Pick what you want. Nothing is selected for you unless it matches the page you are on, and nothing is sent until you confirm from a link we email you.

What would you like to receive?

A short weekly note on what employer-published pay data shows: who pays what, where, and what is changing. Once a week.

Practical notes for job seekers: interviewing, applying for six-figure roles, and making an upward move. About twice a month.

New jobs that match a search you choose. Every job listed has an employer-published base salary of $100,000 or more. At most one email a day (or weekly, your choice). Nothing is sent on days with no new matches. Alerts cover every new job, because this page has no filters.

We email you only after you confirm from a link we send to this address. We do not sell or share your address. Every email has a one-click unsubscribe link. How we handle your email.