Senior Enterprise Data Engineer

🕒 September 30

🗽 New York – Remote

🗽 New York – Remote

💵 $138k - $143k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 13%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ASPCA

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 1866

🏥 Healthcare

💼 Consulting

⚖️ Legal

Healthcare • Consulting • Legal

ASPCA is an organization dedicated to the prevention of cruelty to animals. They provide services such as animal rescue, veterinary care, and improving animal welfare laws. ASPCA actively advocates for the protection of pets, farm animals, and promotes humane education, working to ensure a safe and nurturing environment for all creatures.

📋 Description

• Design, build, and maintain the ASPCA’s enterprise data warehouse ecosystem. • Develop and maintain dbt Core models and data workflows across the medallion architecture. • Integrate MDM workflows and reference data into enterprise pipelines. • Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models. • Build data models supporting enterprise analytics, reporting, and downstream uses. • Apply naming conventions, documentation, testing, and lineage tracking across dbt Core models. • Optimize SQL and dbt Core transformation logic. • Design and maintain pipelines for data ingestion, transformation, and delivery. • Implement orchestration, monitoring, alerting, automated testing, and error handling. • Maintain version control and support CI/CD workflows. • Troubleshoot data quality and freshness issues across Microsoft Fabric, dbt Core, and Snowflake. • Conduct root cause analysis and drive pipeline improvements. • Collaborate with Data Management & BI and Strategy & Research teams on trusted, analytics-ready datasets. • Support data governance, metadata practices, and transformation documentation. • Identify workflow automation and technical-debt reduction opportunities. • Participate in code reviews, knowledge sharing, and team initiatives. • Evaluate emerging tools and technologies for the ASPCA data ecosystem. • Report to the Director, Enterprise Data Engineering Operations; no direct reports.

🎯 Requirements

• High School Diploma, GED, or equivalent experience (Required). • 5+ years of hands-on experience building, maintaining, and optimizing dbt Core transformation pipelines across medallion architectures in production environments (Required). • 5+ years of experience designing, implementing, and supporting production data pipelines using Microsoft Fabric or Azure Data Factory (Required). • 3+ years of experience designing and maintaining data warehouse models and transformation workflows (Required). • 3+ years of experience working within modern cloud data warehouse environments (Required). • Expert-level proficiency in dbt Core, including advanced model design, macro development, custom tests, documentation, performance optimization, and automated deployment integration. • Advanced proficiency with Microsoft Fabric and/or Azure Data Factory. • Deep knowledge of data warehousing, dimensional modeling, medallion architecture, and ELT transformation patterns. • Strong SQL skills. • English required. • Python experience preferred. • Familiarity with Git/GitHub workflows, DevOps CI/CD practices, and cloud-native or SaaS-based data engineering tools. • Snowflake proficiency strongly preferred, including warehouse configuration, performance tuning, query optimization, cost management, and role-based access controls. • Familiarity with Snowflake-native dbt Projects strongly preferred. • Experience integrating mastered entities and reference data from commercial MDM platforms preferred; Reltio preferred. • Ability and willingness to travel up to 5% of the time. • 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 including vacation time, paid personal time, sick time, bereavement time, paid parental leave, and 10 company paid holidays. • 401(k) plan with dollar-for-dollar employer matching up to 4% and an additional 4% employer contribution. • Professional development opportunities, including classes, on-the-job training, coaching and mentorship. • Internal mobility opportunities. • Opportunities to support in the field.