Overview
The Individual Giving Data Engineer will design, build, and maintain data platforms, cloud infrastructure, and integrations to support WFP's global individual giving programme. The role focuses on developing pipelines, integrations, and cloud-native services to enhance fundraising data capabilities.
Key Responsibilities
- Lead the implementation of IG data strategies, aligning with corporate standards and ensuring warehouse evolution, tooling choices, integrations, and data flows meet technical architecture and fundraising programme needs.
- Review existing data flows, identify gaps, and design solutions for current and emerging data needs.
- Consult with enterprise architecture to optimize re-use of existing corporate data assets.
- Align warehouse implementation with broader IG technical and fundraising architecture.
- Support the evolution of data and integration architectures, identifying opportunities to replace manual processes with AI and cloud-native approaches.
- Own and drive the end-to-end implementation of the data warehouse, including physical and logical data modelling, schema design, and layer structuring.
- Build and maintain scalable, well-documented ELT pipelines and ingestion patterns to consolidate data from various sources.
- Lead the implementation of new data integrations with agency feeds, external partners, vendor platforms, and third-party systems.
- Design and implement data transformation pipelines, including attribution of input pipelines for performance measurement and channel reporting models.
- Integrate data from new acquisition channels and new geographic decentralized markets.
- Design and implement technical solutions supporting the synchronization and activation of data across fundraising systems.
- Implement comprehensive data observability and integrity checks at the warehouse layer, including automated monitoring and alerting.
- Own root-cause resolution of warehouse-level data issues, ensuring clear diagnosis, permanent resolution, and documentation.
- Prevent recurring manual data fixes and backfills by building robust, self-healing pipelines.
- Maintain clear data lineage documentation and data dictionaries.
- Work with Privacy and TEC Information Security teams to ensure data handling compliance.
- Support the development and maintenance of reporting capabilities by providing reliable datasets and technically robust foundations.
- Collaborate closely with Business Intelligence colleagues to ensure reporting solutions are accurate, scalable, and aligned with business definitions.
- Develop self-service reporting capabilities where appropriate.
- Provide resilience across critical reporting activities.
- Contribute to the design and maintenance of technical environments for validating data and integration flows.
- Support QA processes in validating data-related flows.
- Ensure testing coverage provides confidence in data accuracy, completeness, and structure.
- Act as the primary technical point of contact for data engineering needs across Individual Giving.
- Translate analytical and operational requirements from non-technical stakeholders into technical specifications.
- Support the IG Tech & Ops Lead with ad hoc data analysis.
- Contribute to knowledge-sharing and data literacy across IG and PSP teams.
- Work in coordination and partnership with IG tech team, Business Intelligence, CRM, and other technical teams.
- Develop internal capability by mentoring colleagues, promoting knowledge sharing, and establishing self-service approaches.
- Reduce dependency on external suppliers over time.
Required Experience
- 4–5 years of experience in data engineering, data platform engineering, analytics engineering, or closely related technical disciplines.
- Proven experience building and maintaining data pipelines and ETL/ELT workflows in a production environment.
- Experience developing dashboards and reports using BI tools such as Tableau, Power BI, Looker, and similar.
- Experience working with fundraising, CRM, or marketing data is a strong advantage.
- Experience designing and implementing integrations across multiple systems using APIs, middleware platforms, managed services, or bespoke engineering approaches.
- Experience evolving data warehouse architectures within live operational environments, balancing modernization with continuity of reporting and operational needs.
- Experience in UN or international development organizations is an asset.
- Hands-on experience with cloud-based data platforms, particularly Redshift and associated AWS services used to support data engineering and integration workloads.
- Familiarity with technologies supporting server-side data collection and activation (e.g. server-side GTM, Conversion APIs, event collection architectures) would be advantageous.
- Familiarity with modern data stack tools such as dbt, Airflow, Azure Devops, or similar orchestration and transformation tools.
- Solid understanding of data modelling principles, data governance, and data quality management.
- Knowledge of GDPR and data privacy principles as applied to fundraising and CRM data.
- Ability to work independently in a fully remote environment, managing multiple deliverables and deadlines.
- Experience providing technical leadership, mentoring, or guidance to less experienced colleagues would be advantageous.
Qualifications
University degree in Computer Science, Data Science, Statistics, Information Systems, or a related technical field
