Overview

Join UNICEF Canada – a respected humanitarian organization dedicated to children’s well‑being. We are looking for a Data Integration Developer & QA to design, develop, and maintain data integration solutions that support our fundraising and enterprise data ecosystem.

Responsibilities

- Current Automation and Integration Solutions (35%)
- Design, develop, and implement ETL/ELT pipelines to process structured and unstructured data in support of the organization’s overall data strategy.
- Build automation and integration workflows that enable accurate and timely movement of supporter data across platforms.
- Work independently to understand business needs, engage stakeholders, define requirements, perform testing and validation, and deliver well‑documented solutions.
- Identify opportunities to enhance the efficiency, accuracy, and usability of data through automation, workflow orchestration, and improved integration design.
- Contribute to the continuous improvement of the organization’s data strategy by recommending modern tools, approaches, and best practices.

- Ongoing Management of Automation and Integration Solutions (35%)

- Own the ongoing maintenance, monitoring, and troubleshooting of all existing integration solutions and pipelines to ensure reliability, accuracy, and data integrity.
- Ensure that automated processes align with operational requirements and business objectives, including:
- Daily automated BI data processes and scheduled data workflows
- Two‑way integration between Raiser’s Edge and Engaging Networks
- Daily fundraising data imports into Raiser’s Edge via ImportOmatic
- Import/export workflows supporting fundraising vendors and third‑party partners





- Proactively identify and resolve issues impacting data quality, automation performance, and integration reliability.
- Maintain appropriate controls and documentation to ensure operational stability and repeatability.
- Oversee ongoing development and maintenance of secure data transfer protocols with fundraising vendors and external partners.
- Coordinate changes to integration processes to ensure uninterrupted fundraising operations.
- Serve as the primary point of contact for vendor technical teams and data specialists on integration‑related matters.

- User Support and Enablement (10%)

- Provide second‑level support to the Donation Processing team related to integration workflows, imports, automation processes, and data entry dependencies.
- Develop and deliver training to ensure operational teams can confidently execute required data processes.
- Ensure integration processes are clearly documented, accessible, and well communicated.

- Quality Assurance and Data Quality (15%)

- Design and implement QA frameworks to validate the accuracy, completeness, and integrity of data across all integration pipelines and automated workflows.
- Develop and maintain automated testing routines – including unit tests, regression tests, and end‑to‑end integration tests – to ensure reliable and repeatable pipeline performance.




- Establish and enforce data quality standards, validation rules, and exception‑handling protocols to proactively detect and remediate data anomalies before they impact downstream systems or fundraising operations.
- Build and maintain monitoring dashboards and alerting mechanisms to provide real‑time visibility into pipeline health, data quality metrics, and integration performance.
- Conduct root‑cause analysis on data quality incidents and implement corrective and preventive measures to reduce recurrence.
- Collaborate with BI, fundraising operations, and technical teams to define data quality expectations and embed quality checkpoints throughout the integration lifecycle.

Qualifications

- Post‑secondary degree in Computer Science, Information Systems, Engineering, or a related discipline.
- 5+ years of hands‑on experience in data integration development and ETL/ELT pipeline design, using platforms such as Microsoft SQL Server and associated tooling, including SSIS and stored procedures.
- Advanced SQL expertise, including query optimization, performance tuning, stored procedure development, and troubleshooting.
- Strong scripting capability (e.g., Python, PowerShell, Scala) to support automation, transformation, and workflow execution.
- Proven experience integrating data via APIs, web services, and third‑party platforms, including handling XML and JSON data formats.
- Solid understanding of data warehousing concepts, data modelling, and integration best practices.
- Experience with version control and source code management tools (e.g., Git, Azure DevOps).
- Familiarity w

📌 Data Integration Developer (Toronto)
🏢 UNICEF Canada
📍 Toronto