Enterprise Data Warehouse Engineer

About this role

Summary:

Overview

The Enterprise Data Warehouse 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 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 Enterprise Data Warehouse 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.

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

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

Where and When You’ll Work

This remote‑based position (which may require periodic travel as described below) is open to all eligible candidates based within the United States.

What You’ll Get

Compensation

Starting pay for the successful applicant will depend on a variety of facto...