Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Senior Enterprise Data Engineer will design, build, and maintain the ASPCA’s enterprise data warehouse ecosystem. This role involves developing and maintaining dbt Core models and data workflows across the medallion architecture, integrating master data management (MDM) workflows, and partnering with stakeholders to support a centralized enterprise data solution. The Engineer will ensure data assets are accurate, performant, reliable, and aligned with organizational standards, bringing deep expertise in dbt Core, data modeling, and enterprise data pipelines using Microsoft Fabric and Azure Data Factory.

Responsibilities

Architect, implement, and maintain dbt Core models across the medallion architecture, applying appropriate transformation patterns to meet operational, analytical, and dimensional data requirements.
Integrate MDM workflows and reference data into medallion-layer transformations in alignment with enterprise data governance standards.
Apply mastered entities, harmonized identifiers, survivorship rules, and standardized reference values to Gold-layer models as defined by enterprise MDM policies.
Build data models that power enterprise analytics, reporting, and other downstream uses.
Implement modeling best practices (e.g., naming conventions, documentation, testing, and lineage tracking) across all layers to ensure dbt Core models comply with enterprise governance standards and quality, performance, and security requirements.
Optimize SQL code and dbt Core transformation logic to ensure efficient, scalable, and maintainable data pipelines.
Design, build, and maintain robust pipelines that support data ingestion, transformation, and delivery while adhering to engineering standards for well-structured code, clear documentation, and idempotent processing.
Implement and maintain scalable job orchestration, monitoring, alerting, automated testing, and error-handling capabilities.
Preserve version control for pipeline code artifacts and support CI/CD workflows to ensure reliable deployment of changes.
Troubleshoot pipeline problems, such as issues with data quality and concerns over data freshness, across Microsoft Fabric, dbt Core, and Snowflake.
Conduct root cause analysis and proactively drive pipeline improvements.
Work closely with the Data Management & BI team to align on definitions, requirements, and expectations, ensuring that engineered datasets are accurate, trusted, and analytics-ready.
Collaborate with the Strategy & Research team to deliver granular, well-structured Silver-layer datasets that support statistical analysis, data science modeling, and operational insights.
Support enterprise data governance and data quality through strong metadata practices and clear documentation of transformation logic.
Identify opportunities to improve data workflows, automate processes, and reduce technical debt.
Participate in code reviews, knowledge-sharing sessions, and team-wide initiatives that strengthen engineering quality and consistency.
Contribute to the advancement of the ASPCA's data ecosystem by evaluating emerging tools and technologies.

Requirements

Expert-level proficiency in dbt Core is required, including advanced model design, macro development, custom tests, documentation practices, performance optimization, and integration with automated deployment pipelines.
Advanced proficiency with Microsoft Fabric and/or Azure Data Factory for enterprise pipeline orchestration, monitoring, scheduled and event-driven workflows, Lakehouse integration, operational support, and troubleshooting of production data pipelines.
Deep knowledge of data warehousing principles, including dimensional modeling, medallion architecture, and ELT transformation patterns.
Strong SQL skills (Python is a plus).
Familiarity with Git/GitHub workflows and DevOps CI/CD practices.
Experience with cloud-native or SaaS-based data engineering tools.
Proficiency with Snowflake is strongly preferred, including warehouse configuration, performance tuning, query optimization, cost management, and implementing role-based access controls.
Familiarity with Snowflake-native dbt Projects, including development, deployment, scheduling, monitoring, configuration management, and version upgrades of dbt workloads within Snowflake, is strongly preferred.
Must be available for occasional off-hours support for critical data pipelines.
Some travel to ASPCA locations and training sites (approximately 5% annually) may be required.

Skills

dbt Core
Microsoft Fabric
Azure Data Factory
Dimensional Modeling
Medallion Architecture
ELT Transformation Patterns
SQL
Python
Git/GitHub
DevOps CI/CD
Cloud-native data engineering tools
SaaS-based data engineering tools
Snowflake
Master Data Management (MDM)
Reltio

Location

United States

Work Type

Remote
Full-time

Experience Level

Senior
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
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

Education Level

High School Diploma or GED
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field preferred

Salary/Compensations

$138,000-143,000 annually

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.
401(k) plan with generous employer contributions — match dollar-for-dollar up to 4% and provide an additional 4% contribution.
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.

About the Company

The ASPCA Information Technology (IT) department supports and improves a broad portfolio of technologies to support our staff. IT ensures that all ASPCA staff, partners, and communities have the systems needed to work effectively and efficiently to improve animal welfare. The sub-teams within IT include Product, Data and Reporting Solutions, Operations and Information Security, Technical Support, Enterprise Architecture, and Business Operations.