- New York City, New York, United States
- On-site
- Full-time · Senior
- $138K–$143K per year
- 5+ years
Designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem using dbt Core, Microsoft Fabric, and Azure Data Factory within a medallion architecture.
Compensation
$138,000-143,000 annually
Responsibilities
- Architect, implement, and maintain dbt Core models across the medallion architecture
- Integrate MDM workflows and reference data into medallion-layer transformations
- Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models
- Build data models that power enterprise analytics, reporting, and other downstream uses
- Optimize SQL code and dbt Core transformation logic
Requirements
- High School Diploma, GED, or equivalent experience
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field
- Nice to have: Master Data Management (MDM)
- Nice to have: Reltio
- Nice to have: star schemas
Skills
Benefits
- Affordable health coverage
- medical
- employer-paid dental
- optional vision coverage
- Flexible time off