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

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

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLdata modelingdata governancedata qualitymaster data managementdata migrationdata integrationPythonR

Soft Skills

collaborationproblem-solvingcommunicationcommitment to diversityequityinclusion

Certifications

Data ArchitectIntegration ArchitectApplication DeveloperBachelor's degree in Computer ScienceBachelor's degree in Information SystemsBachelor's degree in Data Engineering