Senior Enterprise Data Engineer

🔥 5 hours ago

🗽 New York – Remote

🗽 New York – Remote

💵 $138k - $143k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 0%

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, 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 supporting enterprise analytics, reporting, and downstream uses • Apply naming conventions, documentation, testing, and lineage tracking • Optimize SQL and dbt Core transformation logic • Design, build, and maintain data ingestion, transformation, and delivery pipelines • Implement job 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 • Support data governance and data quality through metadata and transformation documentation • Identify workflow automation and technical debt reduction opportunities • Participate in code reviews, knowledge-sharing sessions, and team initiatives • Evaluate emerging data engineering tools and technologies

🎯 Requirements

• 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 • Python experience preferred • Familiarity with Git/GitHub workflows and DevOps CI/CD practices • Experience with 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 • English required • High School Diploma, GED, or equivalent experience required • 5+ years of hands-on experience building, maintaining, and optimizing dbt Core transformation pipelines in production medallion architectures • 5+ years of experience designing, implementing, and supporting production data pipelines using Microsoft Fabric or Azure Data Factory • Demonstrated experience with dimensional and enterprise data modeling practices • 3+ years of experience designing and maintaining data warehouse models and transformation workflows • 3+ years of experience in modern cloud data warehouse environments • Ability to provide occasional off-hours support • Ability and willingness to travel up to 5% of the time • Ability to work within a distributed, cross-functional environment

🏖️ 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 match up to 4% • Additional 4% employer contribution toward retirement • Professional development opportunities including classes, on-the-job training, coaching and mentorship • Internal mobility opportunities • Opportunities to support in the field