Data Architect

Job Overview

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.

Job

Administration (e.g., Finance, IT, HR)

• Catalog and inventory the current enterprise data repositories, analytic tools and related tech stacks
• Gain understanding of organisations reporting and analytic needs through interviews and collaboration with internal stakeholders
• Lead assessments to consider potential new data systems, vendors, and tools
• Design and develop data architecture frameworks to support the organisations objectives
• Develop strategies and propose solutions to expand and enhance the data architecture for organisation
• Recommend tools and systems that support our objectives in balance with budget constraints and right‑size 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 optimise the use of current tools
• Build and configure a modern data stack to reduce data silos, enable cross‑platform analysis and provide tools to data consumers
• Create systems and processes that support a diversity of technical capabilities and organisational needs
• Support organisation efforts to integrate 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 organisation‑wide business intelligence
• Partner with the Data team to build and promote a robust business intelligence ecosystem that democratises 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 provisioned to protect food bank data assets
• Proven ability in managing access to and be responsible for protecting confidential financial information
• Superb judgement; 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 organisation

• 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, data normalization, semantic layers, data modelling, data warehouses, and data lakes.
• Working knowledge of data security standards, including PCI and HIPAA.
• Deep understanding of the…