Senior Enterprise Data Engineer - (on site NYC)

The American Society for the Prevention of Cruelty to Animals

Where
New York, NY - 8th Avenue
Pay
$138K a year

Posted 10 days ago· Checked live at The American Society for the Prevention of Cruelty to Animals 4 days ago

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what The American Society for the Prevention of Cruelty to Animals asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on The American Society for the Prevention of Cruelty to Animals's own hiring page 4 days ago.
What is the job?
The Senior Enterprise Data Engineer will play a critical role in designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem. This role will be part of the Enterprise Data Engineering Operations team, which sits within the broader Product, Data, and Reporting Solutions (PDRS) department.
What does it pay?
$138K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

The Senior Enterprise Data Engineer will play a critical role in designing, building, and maintaining the ASPCA’s enterprise data warehouse ecosystem. This role will be part of the Enterprise Data Engineering Operations team, which sits within the broader Product, Data, and Reporting Solutions (PDRS) department.

What You’ll Do

Senior Enterprise Data Engineer reports directly to the Director, Enterprise Data Engineering Operations, and has no direct reports.

Where and When You’ll Work

This position (which requires travel, as described below) is an on-site role and reports to the 8th Ave ASPCA location.

  • Must be available for occasional off-hours support for critical data pipelines
  • Ability and willingness to travel up to 5% of the time as needed

Interview Information

Compensation

Starting pay for the successful applicant will depend on a variety of factors, including but not limited to education, training, experience, location, business needs, internal equity, market demands or budgeted amount for the role. The target hiring range is for new hire offers only, and compensation may increase beyond the maximum hiring range based on performance over time. The maximum of the hiring range is reserved for candidates with the highest qualifications and relevant experience. The expected hiring salary ranges for this role are set forth below and may be modified in the future.

  • $138,000-143,000 annually

For more information on our benefits offerings, visit our website.

Benefits

At the ASPCA, you don’t have to choose between your passion and making a living. Our comprehensive benefits package helps ensure you can live a rewarding life at work and at home. Our benefits include, but are not limited to:

  • 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.

Responsibilities

Responsibility buckets are listed in general order of importance. They include, but are not limited to:

Qualifications

  • Excellent analytical and problem-solving skills, with a strong commitment to data quality
  • Ability to collaborate effectively with both technical and non-technical partners
  • Solid written and verbal communication skills, with the ability to clearly convey data and technical concepts
  • Comfortable operating in a highly distributed, cross-functional environment
  • Skilled at managing multiple priorities, shifting requirements, and changing timelines
  • Demonstrates curiosity, creativity, and a willingness to experiment and learn
  • Takes initiative and works independently while valuing teamwork
  • Welcomes feedback and proactively seeks opportunities to improve systems and workflows
  • Values diversity of thought and embraces an inclusive, collaborative team culture
  • Ability to exemplify ASPCA’s core values and behavioral competencies

Technical 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 required
  • Python experience preferred
  • 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

Education and Work Experience

  • High School Diploma, GED, or equivalent experience (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 (Required)
  • 5+ years of experience designing, implementing, and supporting production data pipelines using Microsoft Fabric or Azure Data Factory, including orchestration, monitoring, operational support, and troubleshooting of enterprise data workflows (Required)
  • Demonstrated experience applying dimensional modeling and enterprise data modeling practices (e.g., star schemas, SCDs, conformed dimensions)preferred
  • 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; experience with Snowflake is strongly preferred
  • Experience integrating mastered entities and reference data from commercial Master Data Management (MDM) platforms into enterprise data pipelines preferred; Reltio preferred
  • Experience working within structured DevOps workflows, version control, and automated delivery pipelines preferred

Education and Work Experience

High School Diploma, GED, or Equivalent Experience (Required)

Similar open jobs

Data engineer jobs in New York (108)Jobs in New York (19148)