Data Integration Developer

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

• New 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 with data privacy principles and secure data