Senior Enterprise Data Engineer - (on site NYC)
Core
Design, build, and maintain the ASPCA's enterprise data warehouse ecosystem using medallion architecture, dbt Core, and Microsoft Fabric.
Role type
Senior Enterprise Data Engineer
Builds
Enterprise data pipelines, medallion-layer data models, and analytics-ready datasets
Domain
Non-profit / Data Engineering
Deliverable
production ML models
Required skills
dbt Core, SQL, Microsoft Fabric, Azure Data Factory, Snowflake, medallion architecture, MDM workflows, dimensional modeling, CI/CD, pipeline orchestration
Preferred skills
Data governance, root cause analysis, code optimization, emerging technology evaluation
Technologies
dbt Core, Microsoft Fabric, Azure Data Factory, Snowflake
Responsibilities
Architect and maintain dbt Core models across medallion layers; integrate MDM workflows into enterprise pipelines; design and maintain robust data ingestion and transformation pipelines; optimize SQL code and transformation logic; troubleshoot pipeline issues and drive improvements; collaborate with BI and Strategy teams to ensure data quality and alignment.
Seniority
Senior, hands-on IC