The Enterprise Data Warehouse Engineer will play a critical role in designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem.
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.
The Enterprise Data Warehouse Engineer will ensure that data assets are accurate, performant, reliable, and aligned with organizational standards.
Responsibilities include Architecting, implementing and maintaining dbt models, optimizing SQL code, designing and building robust data pipelines, and collaborating with teams to ensure data quality.

Requirements

High School Diploma or GED (Required)
3–5 years of experience designing and maintaining data warehouse models and transformation workflows required
3–5 years of experience building and maintaining dbt based transformation pipelines across medallion layers required
3–5 years of experience working in a cloud data warehouse environment required (Snowflake strongly preferred)
Demonstrated experience applying dimensional modeling and enterprise data modeling practices (e.g., star schemas, SCDs, conformed dimensions)
3–5 years of experience orchestrating data pipelines using Microsoft Fabric, Azure Data Factory, or similar cloud orchestration tools required
Experience integrating with commercial Master Data Management (MDM) platforms; Reltio preferred
Experience working within structured DevOps workflows, version control, and automated delivery pipelines.
Must be available for occasional off-hours support for critical data pipelines.

Benefits

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

dbtSQLdata modelingdimensional modelingenterprise data modelingdata pipelinescloud data warehousedata transformation workflowsorchestrating data pipelinesDevOps

Certifications

High School DiplomaGED