Data Integration Developer & QA

UNICEF Canada; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Extended Health/Dental benefits

Flexible-hybrid work environment

3 weeks of annual vacation

8 to 11 employee wellness days

Job summary

UNICEF Canada in Toronto is seeking a Data Integration Developer & QA to drive data integration solutions vital for fundraising. The role includes designing ETL/ELT pipelines, maintaining integration solutions, and ensuring data quality through various workflows.

Qualified candidates have a post-secondary degree and 5+ years of hands-on experience with data integration, SQL, and strong scripting capabilities. The position offers a flexible-hybrid work environment and various employee benefits.

Qualifications

• 5+ years of hands-on experience in data integration development and ETL/ELT pipeline design using Microsoft technologies.
• Strong analytical skills with the ability to diagnose complex data issues.
• Experience with secure data handling practices and APIs.

Responsibilities

• Design, develop, and implement ETL/ELT pipelines for data integration.
• Maintain and troubleshoot existing integration solutions to ensure reliability.
• Provide training and support for operational teams related to data processes.
• Design and implement QA frameworks to validate data accuracy and integrity.

Skills

Data integration development

ETL/ELT pipeline design

Advanced SQL

Scripting (Python, PowerShell)

API integration

Data warehousing

Version control (Git)

Attention to detail

Education

Post-secondary degree in Computer Science, Information Systems, Engineering

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

SSRS

Job description

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 handling practices, particularly in environments managing personal or financial data.
• Strong analytical skills with ability to diagnose complex data issues & implement practical solutions.

Preferred / Assets

• Experience in the not‑for‑profit or fundraising sector.
• Hands‑on experience with Blackbaud Raiser’s Edge (or equivalent CRM).
• Experience with online fundraising platforms, particularly Engaging Networks.
• Experience with ImportOmatic or similar fundraising integration tools.
• Experience with Salesforce environments and data integration patterns.
• Experience with SSRS for reporting and operational data visibility.
• Experience with Azure platform services, including Azure Data Factory, Azure SQL, or Azure Blob Storage.
• Familiarity with Power BI or similar BI tools as a downstream consumer of integration pipelines.
• Experience managing SFTP and secure file transfer workflows with external vendors or partners.
• Development experience in C# and .NET.
• Exposure to Agile or iterative delivery practices.
• Relevant certifications (Microsoft, Azure, SQL, integration, data engineering) are a strong asset.
• Exceptional attention to detail and commitment to data accuracy.
• Strong ability to work independently with minimal supervision.
• Ability to deliver results under deadlines and operational pressure.
• Strong troubleshooting and problem‑solving capability.
• Excellent communication and stakeholder management skills.
• Collaborative mindset with the ability to engage both technical and non‑technical teams.

Benefits

• Extended Health/Dental benefits, Healthcare Spending Account, and Wellness Account.
• Life, AD&D, & Long‑Term disability insurance coverage.
• Employer match contributions (5%) to a Group Pension Plan.
• Access to parental leave top‑up.
• Flexible‑hybrid work environment to support work‑life integration.
• Minimum 3 weeks of annual vacation (increases with time served) & 1 additional day per year of service (max 30).
• 8 to 11 employee wellness days – an additional series of pre‑set days off, given annually to further extend long weekends.
• Discounted rate for a GoodLife gym membership.
• Access to an Employee and Family Assistance Program.
• Access to a comprehensive global learning platform with over 1600 courses, webinars & resources.
• Internal leadership development, training, & mentorship programs that integrate Anti‑Racism and diversity, equity and inclusion principles.
• Opportunities to access both local & global stretch assignments.
• Centrally located head office in mid‑town Toronto with satellite offices in Calgary & Montreal.
• Easily accessed by public transit and a short walk from several parking locations.
• Inclusive & accessible co‑working and meeting spaces designed to foster purpose at every turn and accommodate the diverse needs of employees.
• Under the leadership of a dynamic, accomplished, and experienced executive leadership team, you’ll be part of a diverse & talented Canadian team committed to creating meaningful impact while fostering an inclusive and supportive work environment.
• You’ll join a global UNICEF family with a shared commitment to impact the lives of children.

Inclusion & Recruitment

UNICEF Canada is an inclusive workplace and is committed to championing diversity, equity, inclusion, and accessibility. Requests for accommodation can be made at any stage of the recruitment process.