Job Description

The Manager,DataArchitecture and Developmentwill be primarily responsible for designing,maintainingandoptimizingdata solutions that drive ourMembershipdata operations, analytics, and integration platforms. The ideal candidate will have strong expertise in SQL and/or other data-driven languages like R and Python; Salesforce data architecture, custom logic and Apex coding; ETL/ELTprocesses andpipelines; and experience with DevOps,with the ability to translate business requirements into scalable, high-performance data models and processes.

This role will be the lead inarchitecting andimplementing data solutions that allow the ASPCA to be creative in fundraising channels; provide robust and clean data for analysis and decision-making; and be a key decision maker in best practices for software and data platforms.

WhatYou’llDo

• The Manager, Data Architecture and Development reports directly to theSenior Director, Data Strategy & Operationsand has no direct reports.

Where and WhenYou’llWork

This remote-based position is open to all eligible candidates based within the United States.

• Ability and willingness to travel up to several times annually, as needed.

WhatYou’llGet

Compensation

The target hiring range is based on where the employee works, which for remote roles is the employee’s primary location of residence, and its respective cost of laborYou can view which zone appliesto you based on your location (aspca.app.box.com/v/aspcazonetable). For questionsregardinglocations not on the list, please send an email to Careers@aspca.orgfor more information.

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 bemodifiedin the future.

• Zone 1: $81,000 - $88,000 annually

• Zone 2: $ 89,000 - $ 96,000 annually

• Zone 3: $ 98,000 - $ 106,000 annually

Benefits

At the ASPCA, youdon’thave 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 offthat includes vacation time, sick and bereavement time, paid parental leave, 10 company paid holidays, and paid personal time off that allows you even more flexibility to observethe days that mean the most to you.

• Competitive financial incentives and retirement savingsincluding a 401(k) plan with generous employer contributions — we match dollar for dollar up to 4% and provide an additional4% contribution toward your future each year.

• Robust professional development opportunitiesincluding 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, and include but are not limited to:

Data Architecture & Modeling

• Design and maintain scalable data architecture, ensuring high data integrity, performance, and security.

• Develop logical and physical data models, metadata, and data flow diagrams.

• Collaborate with business stakeholders to understand data requirements and translate them into technical solutions.

• Implement best practices for data governance, data quality, and master data management.

ETL / Data Integration

• Design, develop, and maintain ETL/ELT jobs to extract data from multiple sources (Salesforce, APIs, databases, flat files, etc.) into data warehouses or analytics platforms.

• Optimize ETL processes for performance, reliability, and scalability.

• Troubleshoot data pipeline issues and ensure timely data delivery for reporting and analytics.

Database Development

• Develop complex SQL queries, stored procedures, and performance-tuned database models for our enterprise data warehouse(s).

• Manage database schema changes and maintain documentation of data systems.

• Support data migration, transformation, and integration activities across systems.

Salesforce Data Integration

• Architect and manage Salesforce data models, relationships, and API integrations.

• Build and maintain pipelines to synchronize Salesforce data with other enterprise systems and data warehouses.

• Ensure compliance with Salesforce data security and access controls.

Language: 

English (required) 

Qualifications:

• Proficient in SQL (writing and optimizing code; performance tuning, complex queries and entity creation).

• Proficient with ETL tools (e.g., Informatica, Talend, SSIS, MuleSoft, Airflow, or similar).

• Minimum 1 year experience integrating and managing Salesforce data (via APIs, data loader, demand tools, apex, or other middleware).

• Experience with building and maintaining Master Data Management (MDM) systems a plus.

• Proficient in cloud data platforms (e.g., AWS Redshift, Azure, Snowflake).

• Proficient with Python, R or shell-scripting for data automation.

• Ability to exemplify ASPCA’s core values, behavioral competencies, and commitment to diversity, equity, and inclusion.

Education and Work Experience: 

• Bachelor's degree in Computer Science, Information Systems, Data Engineering or related field required, or the equivalent professional experience.

• 4+ years of relevant experience, including SQL, ETL architecture and data modeling. 

• Salesforce or Microsoft certifications (e.g., Data Architect, Integration Architect or Application Developer) a plus.  

Other Skills

• Strong analytical and problem-solving abilities.

• Excellent communication and documentation skills.

• Ability to work collaboratively with technical and non-technical stakeholders.

• Self-motivated and detail-oriented, with a focus on data accuracy and system performance.

Language:

English (Required)

Education and Work Experience:

Bachelors (Required)