Senior Enterprise Data Warehouse Engineer

Job not on LinkedIn

🔥 1 minute ago

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

🤲 Charity

🤝 Non-profit

🌍 Social Impact

Charity • Non-profit • Social Impact

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

• The Senior Enterprise Data Engineer will play a critical role in designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem. • The Engineer will develop and maintain dbt Core models and data workflows across the medallion architecture, integrate master data management (MDM) workflows into enterprise pipelines, and partner with cross-functional stakeholders to support the ASPCA’s transition from siloed systems to a centralized enterprise data solution. • Reporting to the Director, Enterprise Data Engineering Operations, the Senior Enterprise Data Engineer will ensure that data assets are accurate, performant, reliable, and aligned with organizational standards. • The ideal candidate will bring deep hands-on expertise with dbt Core, strong dimensional and medallion data modeling skills, and substantial experience developing and supporting enterprise data pipelines using Microsoft Fabric and Azure Data Factory.

🎯 Requirements

• High School Diploma or GED(Required); Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field preferred • 5+ years of hands-on experience building, maintaining, and optimizing dbt Core transformation pipelines across medallion architectures in production environments • 5+ years of experience designing, implementing, and supporting production data pipelines using Microsoft Fabric and/or Azure Data Factory, including orchestration, monitoring, operational support, and troubleshooting of enterprise data workflows • Demonstrated experience applying dimensional modeling and enterprise data modeling practices (e.g., star schemas, SCDs, conformed dimensions) • 3–5 years of experience designing and maintaining data warehouse models and transformation workflows • 3–5 years of experience working within modern cloud data warehouse environments; experience with Snowflake is strongly preferred • Experience integrating mastered entities and reference data from commercial Master Data Management (MDM) platforms into enterprise data pipelines; Reltio preferred • Experience working within structured DevOps workflows, version control, and automated delivery pipelines.

🏖️ Benefits

• Affordable health coverage, including medical, employer-paid dental and optional vision coverage. • Flexible time off that includes vacation time, paid personal time, sick time, bereavement time, paid parental leave, and 10 company paid holidays that allows you even more flexibility to observe the days that mean the most to you. • Competitive financial incentives and retirement savings, including a 401(k) plan with generous employer contributions — we match dollar-for-dollar up to 4% and provide an additional 4% contribution toward your future each year. • Robust professional development opportunities, including classes, on-the-job training, coaching and mentorship with industry-leading peers, internal mobility, opportunities to support in the field and so much more.