Data & Analytics Engineer

Food For Education

Posted: Sep 30, 2026

Deadline: Not specified

Data & Analytics Engineer

We are a not for profit organization that works with vulnerable children in the public school system to improve their lives and school performance. Founded in 2012, Food for Education provides subsidized school meals every day to over 15,000 kids with a goal of feeding 1,000,000 kids by 2025.

Role overview: The Data & Analytics Engineer owns Food4Education's data platform end to end: the pipelines and APIs that bring data from source systems into the data warehouse, and the models, tests and definitions that turn it into metrics the organisation can rely on. The role ensures data arrives reliably, completely and securely; is modelled consistently so every report returns the same answer; and is documented to a standard that supports multi-country expansion and technical assistance to partner organizations. The post-holder works in a two-person engineering team in which each member leads one discipline and is fully capable in the other, working closely with engineering and platform teams, source-system owners, BI analysts and business teams.

Key responsibilities

• Document and profile all data sources for quality, volume, update frequency, key relationships and business entity mappings. Design and maintain the unified BigQuery data model, applying naming and governance standards, partitioning and clustering for cost, and retention and historisation rules, designed for transfer across countries and partners.

• Build and maintain extraction, transformation and enrichment pipelines for every source system, using incremental loading to minimise processing cost, and deliver data migrations, new integrations and ingestion for new countries. Configure and maintain Apache Airflow (or equivalent) workflows with business-aligned scheduling, error handling, retries and backfills, and monitor pipeline health to resolve failures.

• Design and maintain dbt models from staging to serving layers with consistent grain, naming and conformed dimensions. Implement core metric definitions so every report, dashboard and external submission uses the same logic; build dbt tests across critical assets; maintain the KPI dictionary (definition, logic, source, refresh cadence, as-at date, businessowner); reconcile figures where systems disagree; prepare certified self-service datasets; and flag definitions that cannot be implemented as written, working with system and business owners to close gaps at source.

• Implement validation checks at extraction and loading. Maintain quality monitoring dashboards, data dictionaries, alerting tools, and data lineage, while logging, triaging, resolving, and documenting incidents against agreed severity levels. Mask or hash personal data at the ETL layer, implement row- and column-level access control across agreed tiers, ensure no model reintroduces personal data, and support access reviews and data protection requirements.

• Maintain the raw-layer data dictionary, KPI dictionary, dependencies and lineage; document pipelines, transformations, models and operational runbooks; train and support the BI team on data models and access patterns; and ensure systems can be operated and transferred without the post-holder present.

• Minimum Requirements

Education

• Bachelor's degree in Computer Science, Engineering, Statistics or a related field.

Experience

• Minimum 4 years across data and analytics engineering, with production experience in both, including at least 2 years owning dbt and BigQuery in production (models, tests and documentation) and demonstrated delivery of data migrations.

Skills and competencies:

• Strong Python and SQL; advanced proficiency in BigQuery or an equivalent cloud data warehouse in production; dimensional modelling including grain, conformed dimensions, slowly changing dimensions and star schema design; production experience building and orchestrating data pipelines with tools such as Apache Airflow, Dagster, Cloud Composer or GitHub Actions, including scheduling, dependency management, retries and alerting; change data capture, incremental loading and backfill strategies across varied source systems; version control, code review and CI/CD applied to data work; data protection controls and data migration procedures; ability to translate a business metric definition into an implementable specification and discuss it with non-technical stakeholders; attentiveness to data accuracy; documentation as a standard practice; proactive problem reporting; clear communication with non-technical colleagues, system owners and vendors; organized and dependable under operational pressure.

Certifications (if applicable):

• Cloud data platform or dbt certifications are an advantage but not required.

Preferred qualifications:

• ERP integration experience, Sage X3 or similar IoT or telematics data; experience supporting month-end financial close, ensuring finance data feeds are complete, reconciled and available on schedule; experience in a small team owning the full data stack.

• What success looks like

Within the first 12 months:

• Data migrations and data integrations are delivered within the expected timelines. New ingestions run on standard patterns. Pipeline uptime is above 90%, with alerts responded to within 4 hours. Failures are caught by monitoring before a stakeholder reports them. The data and KPI dictionary covers more than 80% of core datasets. Personal data is masked at source and access tiers are in place across all reporting. Dependencies and governance are implemented on core datasets. Every incident is closed with a documented root cause within 5 working days.