Data Systems Architect

Children's Council of San Francisco • San Francisco, CA

3d • Remote

About The Position

The Data Systems Architect is responsible for designing, managing, and evolving the organization’s data ecosystem. This role ensures the reliability, scalability, and integrity of data systems across platforms, supporting reporting, analytics, and operational needs. The Data Systems Architect will report to the Chief Technology Officer. This position will play a key role in designing and advancing the organization’s data ecosystem to support scalable systems, high-quality data, and organization-wide insights. This role is 100% remote, with occasional in-office presence for key meetings and collaboration.

Requirements

• 5+ years of experience in data architecture, systems design, or data platform management
• Experience with data warehousing solutions (Azure preferred)
• Experience designing data integrations and API-based architectures
• Strong experience with Salesforce system design, customization and automations
• Strong understanding of data governance and data quality best practices
• Proven ability to translate business needs into scalable technical solutions
• Strong project management skills with experience leading complex projects involving multiple business units and stakeholders
• Ability to communicate complex technical concepts to non-technical stakeholders

Nice To Haves

• Experience with BI/reporting tools (Power BI or similar)
• Familiarity with Account Engagement or similar email marketing tools
• Expertise in SQL, data modeling, and database design

Responsibilities

• Design and oversee the organization’s data architecture, including data warehouse, operational systems, and integrations
• Develop and maintain data models, data standards, and governance practices
• Lead the configuration and optimization of core business systems and their integration with the broader data ecosystem
• Work with individual business units and the organization as a whole to optimize business processes and design solutions across the organization’s Salesforce instance
• Supervise the Data Integrations Engineer, overseeing and supporting their work to ensure business continuity
• Ensure data quality through deduplication, validation, and monitoring processes
• Establish and enforce data security, access controls, and compliance standards
• Partner with internal stakeholders to define reporting and analytics requirements
• Lead data-related documentation efforts including data cataloging and mapping
• Collaborate with other data and systems staff (RDE)
• Collaborate with and manage external vendors or consultants supporting key platforms, ensuring high quality work and on-time deliverables
• Work in collaboration with the Data Integrations Engineer to complete data related tasks and projects as needed
• Manage different data related projects
• Other Data related duties as assigned

Benefits

• Generous Medical coverage for staff, including paid medical plan deductibles, copays and out-of-pocket maximums.
• Dental, Vision, Chiropractic & Acupuncture, Life, LTD and AD&D coverage.
• Voluntary benefits that include Supplement Life, Accident, Critical Illness, and Pet Insurance.
• 401(k) retirement plan with a generous employer match.
• Pre-tax Flexible Spending Accounts, Health Savings Account and Commuter Benefit programs.
• Generous paid time off package, including 14 paid holidays + a floating holiday for your Birthday.
• Ongoing training and professional development for all staff.
• Tuition Reimbursement.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed