Manager, Data Architecture and Development

ASPCA

1d•$81,000 - $106,000•Remote

About The Position

Summary: The Manager, Data Architecture and Development will be primarily responsible for designing, maintaining and optimizing data solutions that drive our Membership data 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/ELT processes and pipelines; 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 in architecting and implementing 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. What You’ll Do The Manager, Data Architecture and Development reports directly to the Senior Director, Data Strategy & Operations and has no direct reports. Where and When You’ll Work 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. What You’ll Get 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 labor. You can view which zone applies to you based on your location (aspca.app.box.com/v/aspcazonetable). For questions regarding locations not on the list, please send an email to [email protected] for 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 be modified in 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, 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, sick and bereavement time, paid parental leave, 10 company paid holidays, and paid personal time off 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, 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) The ASPCA was founded in 1866 on the belief that animals are entitled to kind and respectful treatment by humans and must be protected under the law. As a 501(c)(3) not-for-profit corporation with more than two million supporters nationwide, the ASPCA is committed to preventing cruelty to dogs, cats, equines, and farm animals throughout the United States. The ASPCA is headquartered in New York City, where we maintain a full-service animal hospital, spay/neuter clinic, mobile spay/neuter and primary pet care clinics, a rehabilitation center for canine victims of cruelty, kitten nursery, adoption center, and two community veterinary centers. The ASPCA also operates programs and services that extend nationwide. We assist animals in need through on-the-ground disaster and cruelty interventions, behavioral rehabilitation, animal placement, legal and legislative advocacy, and the advancement of the sheltering and veterinary community through research, training, and resources. At the ASPCA, we are committed to fostering a collaborative and compassionate culture and we welcome all voices to contribute to our lifesaving mission. Our staff represent a vast array of backgrounds and diversity dimensions, bringing with them valuable experiences and perspectives. They join the ASPCA to learn, grow, and continually do their best work on behalf of animals. We are inspired by our staff, partners, and the communities we support across the country who work to improve animal lives. We are committed to diversity, equity, and inclusion at the ASPCA because it elevates our organizational culture, aligns with our Core Values, and enables us to move further and faster toward the ASPCA’s vision – that all animals live good lives; valued by society, protected by its laws, and free from cruelty, pain and suffering.

Requirements

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

Nice To Haves

Experience with building and maintaining Master Data Management (MDM) systems a plus.
Salesforce or Microsoft certifications (e.g., Data Architect, Integration Architect or Application Developer) a plus.

Responsibilities

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.

Benefits

Affordable health coverage, including medical, employer-paid dental, and optional vision coverage.
Flexible time off that 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 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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume