Data Architect

Alameda County Community Food Bank•Oakland, CA

2h•$142,000•Hybrid

About The Position

The Data Architect will play a central role in designing, developing, deploying and supporting a data infrastructure that will allow ACCFB to analyze data across silos, provide new business intelligence tools to staff, support continuous learning & innovation, and create a data culture in support of data democratization. The organization has various data analytic tools and the early stages of a data warehouse. These tools and systems, however, are not keeping pace with advances in business intelligence or the organization’s needs. The Data Architect will be a dedicated resource focusing on our enterprise data to allow us to fully develop a data warehouse, democratization of data to support self-service analytics, promote data informed decision making and potentially bring in new technologies such as data lakes and machine learning. Alameda County Community Food Bank has achieved notable success in recent years — and is currently responding to an incredible increase in need in our community due to the pandemic and recession. Even with a passionate network of 420+ agency partners serving more clients — and distributing more food – than ever before, we’ve expanded our services even further to meet the growth in need. Our organization’s success is built on bold decision-making, a culture of equity and inclusivity, and an environment that embraces innovative thinking to create a healthier, more prosperous and just community for all. With our latest strategic plan, we are setting a bold trajectory for the long-term work required to dismantle the systems that perpetuate poverty, including racism. Our staff regularly engage in conversations about race, class, power and privilege as part of our organizational commitment to equity, justice and inclusion. Please learn more about our efforts at www.accfb.org.

Requirements

Bachelor's degree or master's Degree in a relevant field or equivalent professional experience.
7 or more years of professional experience in data architect or data engineering as a primary function of position.
At least 3 years of experience designing data strategies and building enterprise data systems.
Hands on experience working with enterprise systems, their data structures, and relationships to business operations.
Proven expertise with SQL, ETL/ETL, data normalization, semantic layers, data modeling, data warehouses, and data lakes.
Working knowledge of data security standards, including PCI and HIPAA.
Deep understanding of the databases, data warehouses, data lakes, and related analytics tools.
Exceptional analytical skills and attention to detail.
Ability to communicate complex technical information to a non-technical audience, translating and adapting presentations to promote understanding.
Ability to work and interact well with individuals (staff, volunteers, and participants) from a variety of socioeconomic backgrounds in a culturally diverse environment.
Ability to develop and maintain collaborative and professional relationships.
Ability to prioritize and handle multiple assignments in a high-demand environment.

Nice To Haves

Experience with Microsoft Dynamics NAV/BC365 ERP, SQL Server, and Jet Analytics DWH.
Experience with Salesforce CRM ecosystem and Data Cloud.
Experience with Tableau, Jet Reports, ESRI, R and other analytics tools.
Working knowledge of system and date integration tools.
Excellent written and verbal communication skills.
Experience in a nonprofit environment with a variety of stakeholders and deeply rooted community values.

Responsibilities

Catalog and inventory the current enterprise data repositories, analytic tools and related tech stacks
Gain understanding of organizations reporting and analytic needs through interviews and collaboration with internal stakeholders
Lead assessments to consider potential new data systems, vendors, and tools
Designs and Develops data architecture frameworks to support the organizations objectives
Develop strategies and propose solutions to expand and enhance the data architecture for organization
Recommend tools and systems that support our objectives in balance with budget constraints and right-sized appropriately for sustainability
Partner with Director of IT to develop a long-term roadmap for data enabling strategies
Provide enhancements to existing data infrastructure to optimize the use of current tools
Build and configure a modern data stack to reduced data silos, enables cross-platform analysis and provides tools to data consumers
Create systems and processes that support a diversity of technical capabilities and organizational needs
Support organization efforts to integrated systems, identify single source of truth, improve data normalization and promote cross-system data consistency
Provide Training and Support assistance to users of the data analytics infrastructure
Create documentation for data users and SOP to support its growth and development
Provide maintenance and ongoing enhancements to systems
Lead a cross-departmental data user group responsible for reviewing data system changes, advancing data quality and governance practices, and supporting the ongoing development of organization-wide business intelligence.
Partner with the Data team to build and promote a robust business intelligence ecosystem that democratizes data and promotes data driven decisions.
Collaborate with IT leadership to develop, support and implement strategic plans aligned with data analytics and business intelligence
Champion best practices in data architecture, including data governance, quality, and security
Partner with IT Team and data owners to promote the safeguard of our enterprise data
Conduct audits of data systems and repositories to ensure access is provisions to protect food bank data assets
Proven ability in managing access to and be responsible for protecting confidential financial information
Superb judgment; ability to handle confidential information with great sensitivity
Ability to maintain confidentiality of sensitive Food Bank data along with the ability to establish credibility, trust and partnership at all levels of an organization
Essential duties of the role may change and adapt over time as the organization defines and builds a new data ecosystem.
All other duties as assigned.