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 pipeline
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 Careers@aspca.org 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)