Senior Enterprise Data Engineer

Location: New York

Summary:

Overview 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 DoSenior Enterprise Data Engineer reports directly to the Director, Enterprise Data Engineering Operations, and has nodirect reports.

Where and When You’ll Work This remote‑based position (which requires travel, as described below) is open to all eligible candidates based within the United States. 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.  $,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  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…