Data & Analytics Engineer at Food For Education
Food For Education
Job description
About the Role 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 Data architecture and source assessment: Document and profile all data sources — relational databases, Google Sheets, APIs and unstructured data — for quality, volume, update frequency, key relationships and business entity mappings. Design and maintain the unified BigQuery data model, applying agreed naming and governance standards, partitioning and clustering for cost, and retention and historisation rules, designed for transfer across countries and partners. Pipeline development and orchestration: 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. Analytics engineering and metric modelling: 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. Data quality, protection and incident management: 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. Documentation and knowledge transfer: 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 Big Query in production (models, tests and documentation) and demonstrated delivery of data migrations. Skills & Competencies: Strong Python and SQL Advanced proficiency in BigQuery or an equivalent cloud data warehouse in production Dimensional modelling: 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 (GitHub or equivalent) Data protection controls and data migration procedures Able to translate a business metric definition into an implementable specification, and discuss it directly with non-technical stakeholders Attentive to data accuracy; documents as a matter of course and builds systems others can operate Raises problems early and is comfortable reporting known issues and quality gaps Communicates clearly 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 live within the expected timelines. New ingestions running on standard patterns rather than a bespoke build. Pipeline uptime above 90%, with alerts responded to within 4 hours. Failures caught by monitoring before a stakeholder reports them. Data and KPI dictionary covering more than 80% of core datasets. Personal data masked at source and access tiers in place across all reporting. Dependencies and governance based on business logics implemented on core datasets. Every incident closed with a documented root cause within 5 working days.
Similar jobs
Social Media and Content Officer at Girls Not Brides
Girls Not Brides
ABOUT YOU You are a creative and audience-focused communicator with a passion for visual storytelling, social media, and digital engagement. You enjoy experimenting with different formats, identifying creative ways to communicate ideas, and producing content that connects with audiences. You are organised, adaptable, and comfortable managing multiple content requests while maintaining high standards of quality and consistency. You understand the importance of accessible, inclusive and ethical communications and enjoy collaborating with colleagues to bring stories to life across multimedia and social media channels. Job location Nairobi, Kenya / Mexico City, Mexico Working as a global team, all Girls Not Brides' team members may from time to time be expected to work outside normal working hours (e.g., early morning or early evening) this is not a regular occurrence and is only to accommodate collaboration of teams across different time zones. This role may require some international travel, as necessary Accountable To Communications Manager Salary range Market competitive based on a detailed survey by the Birches Group of comparable national NGO salaries in selected location. Payments will be made in local currency of where it is located. Contract This is a fixed term contract for 2 years. The successful candidate must have the right to work in the country that they are based in at the time of applying, and for the full duration of the two-year contract. KEY RESPONSIBILTIES Social media and digital audience engagement Develop and implement social media strategies, plans and approaches, translating communications strategies and plans into effective social media activity that supports external engagement and organisational goals. Develop and deliver tailored social media plans, calendars, scheduling, and content (copy/visuals) aligned to organisational brand, messaging, moments, key audiences, and priorities. Contribute to regular audience mapping and analysis with colleagues across external engagement, feeding in insights from social media performance, trends, and opportunities. Work closely with the Senior Digital Communications Officer to ensure aligned digital journeys for key audiences based on channel insights and performance. Monitor and evaluate social media performance, using data, audience insight and trends to continuously improve audience engagement and inform adaptation of social media approaches. Manage day-to-day social media activity independently, proactively monitoring key audiences and identifying and acting on emerging opportunities within agreed priorities and escalating issues where appropriate. Works proactively with colleagues across teams to integrate timely and strategic social media approaches in planning for key moments, campaigns, launches, and other activities. Work collaboratively with media and communications colleagues to identify and respond to relevant breaking news, emerging opportunities, and organisational priorities through timely social media activity, using judgement to determine appropriate approaches and escalating where required. Digital communications and creative content Produce engaging, high-quality multimedia content, communications materials and collateral, including graphics, videos, photography and other communications assets that support organisational priorities, publications, and influencing moments. Develop creative concepts and narrative approaches for content that translate organisational priorities into compelling content across digital channels, publications, campaigns and influencing moments. Apply editorial judgement to ensure all multimedia content is accurate, inclusive, accessible and aligned with organisational messaging, visual brand identity, and ethical storytelling principles. Work collaboratively with communications colleagues to develop approaches that strengthen written content, media opportunities, publications and other communications outputs through multimedia storytelling. Identify and maintain a bank of independent creative suppliers and partners, including designers, illustrators, photographers, videographers and other content producers, coordinating commissioning, contracting and delivery within agreed projects and budgets. Ensure visual consistency and adherence to brand standards across communications outputs and provide visual guidance and support to colleagues across the Communications Team and wider organisation where appropriate. Communications Team engagement Work closely and collaboratively with other communications team colleagues to deliver integrated communications. Work collaboratively as part of cross-functional project teams, partnering with colleagues across the organisation to support the development of communications plans, approaches, and content gathering aligned to organisational priorities. Support report design and visual presentation of organisational materials. Support the maintenance of communications assets, content libraries, and editorial resources to support efficient content production and knowledge management. Contribute to the development and maintenance of Communications Team content calendars and forward planning processes, ensuring social media activity, multimedia content and creative production are coordinated with wider communications priorities and key moments. Contribute to the Communications Team planning, learning, and connection, contributing to a high-performing, cross-geography team. Undertake monitoring and evaluation to inform and support learning and improved audience engagement over time. Contribute to other cross-team communications activities as required. Wider Organisational Responsibilities Support copywriting, proofreading and translation of communications outputs across our core languages as required Co
WASH Assistant - Tana River at Save the Children
Save the Children
ROLE PURPOSE: The post holder(s) will provide necessary support to the WASH Officer in implementation of quality WASH programme-WASH constructions, NFIs, Hygiene promotion and Upscaling WASH'em services in communities targeted by Save the Children in the region of Garissa/Wajir/Mandera/Tana River. The post is specifically oriented towards the WASH emergency response in the context of the crisis Elnino preparedness, and special attention will be made âÃÂÃÂâÃÂÃÂon the integration of the WASH sector in other core sector of Save the Children such as nutrition, food security, health, education and child protection. Reports to: WASH Officer Staff directly reporting to this post: N/A Role Dimensions: Water supply, storage and Sanitation, Hygiene promotion, Construction, Capacity Building, NFI distribution, distribution of water treatment chemicals. KEY AREAS OF ACCOUNTABILITY: Program design and implementation Assist the WASH Officer in follow-up and evaluation of activities related to the construction of WASH infrastructures in the communities, such as: Supervision of construction or rehabilitation of WASH facilities (animal troughs, tank platforms, elevated tower tanks, reticulation systems, borehole equipping & solarization). Hold project sites meeting with the contractors, community representatives to provide feedback on the projects. Planning, organizing and follow up of Hygiene promotion for community including leading in distribution of WASH NFI to target communities: items include Jerricans, Buckets, Soap, PUR, Aquatabs etc. Assist the WASH Officer in maintaining WASH documentation and support in documenting success stories from the communities served. Assist the WASH Officer in the general supervision of contractors, ensuring the safety of construction sites and community participation. Assist the WASH Officer in validating the progress and quality of work of the contractors and make the connection with the administration and logistics to ensure their payments. Assist the WASH Officer in planning for field logistics for project monitoring and supervision. Monitoring, Evaluation, Accountability and Learning Assist the WASH Officer in verifying that WASH infrastructure construction and rehabilitation works done by contractor are carried out according to quality standards established by Save the Children through quality checklists Plan and be responsible for the weekly reporting of data in order to follow up the standard project and strategic indicators (number of beneficiaries, number and type of activities completed. Reporting Writing daily report to WASH Officer, and verbal reports whenever necessary. Integration, coordination and transversal aspects Support the WASH Officer in ensuring that construction works is integrated with hygiene promotion and community participation component, to ensure sustainability of the infrastructure built. Coordinate WASH construction activities with other sectors of Save the Children, to integrate activities in the same geographical area and for the same beneficiaries. Ensure the integration of gender, child protection, HIV, environment and other crosscutting issues to the design, implementation and development of WASH construction activities, and ensure that activities consider the needs of specific groups and individuals, especially children, the elderly and disabled. BEHAVIOURS (Values in Practice) Accountability: Holds self-accountable for making decisions, managing resources efficiently, achieving and role modelling Save the Children values Holds the team and partners accountable to deliver on their responsibilities - giving them the freedom to deliver in the best way they see fit, providing the necessary development to improve performance and applying appropriate consequences when results are not achieved. Ambition: Sets ambitious and challenging goals for themselves and their team, takes responsibility for their own personal development and encourages their team to do the same Widely shares their personal vision for Save the Children, engages and motivates others Future orientated, thinks strategically and on a global scale. Collaboration: Builds and maintains effective relationships, with their team, colleagues, Members and external partners and supporters Values diversity, sees it as a source of competitive strength Approachable, good listener, easy to talk to. Creativity: Develops and encourages new and innovative solutions Willing to take disciplined risks. Integrity: Honest, encourages openness and transparency; demonstrates highest levels of integrity QUALIFICATIONS AND EXPERIENCE A degree or diploma in Civil Engineering, Water Engineering, Public Health and sanitation. Professional experience of 2 years minimum in the field of WASH infrastructure construction in humanitarian or development context. Experience of project management, implementing integrated Health and WASH projects within agreed timescales and budget limitations . Experience of and commitment to working through systems of community participation and accountability in an emergency integrated Health and WASH context. Knowledge of monitoring and evaluation . Some experience of representation and ability to represent Save the Children effectively in external forums. Commitment to the aims and principles of Save the Children. In particular, a good understanding of the Save the Children's mandate and child focus and an ability to ensure this continues to underpin our support . Ability to write clear and well-argued assessment and project reports . Excellent communication skills . Strong influencing skills . Politically and culturally sensitive with qualities of patience, tact and diplomacy . A high level of written and spoken English . The capacity and