Senior Enterprise Data Warehouse Engineer

Role Description

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.
• 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.
• Thrive in a distributed data environment where clarity, consistency, and data quality are essential.
• Bring deep hands-on expertise with dbt Core.
• Have strong dimensional and medallion data modeling skills.
• Possess substantial experience developing and supporting enterprise data pipelines using Microsoft Fabric and Azure Data Factory.

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.

Requirements

• Expert-level proficiency in dbt Core, 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 (Python is a plus).
• 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.

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.
• Competitive financial incentives and retirement savings, including a 401(k) plan with generous employer contributions.
• Robust professional development opportunities, including classes, on-the-job training, coaching and mentorship with industry-leading peers.