Senior Enterprise Data Engineer
Core
Design, build, and maintain the ASPCA's enterprise data warehouse ecosystem using medallion architecture and dbt Core.
Role type
Senior Enterprise Data Engineer
Builds
Enterprise data pipelines, medallion-layer data models, and analytics-ready datasets
Domain
Non-profit animal welfare / Data Engineering
Required skills
dbt Core, SQL, Microsoft Fabric, Azure Data Factory, Snowflake, medallion data modeling, MDM workflows, CI/CD, pipeline orchestration
Preferred skills
dimensional modeling, data governance, root cause analysis, code optimization
Technologies
dbt Core, Microsoft Fabric, Azure Data Factory, Snowflake
Responsibilities
Architect and maintain dbt Core models across medallion architecture; Design and maintain robust data ingestion and transformation pipelines; Collaborate with BI and Strategy teams to align on data definitions and requirements; Optimize SQL code and transformation logic for performance; Implement monitoring, alerting, and automated testing for pipelines; Participate in code reviews and knowledge-sharing sessions.
Seniority
Senior, hands-on IC
