Data Integration Developer

Canadian Unicef Committee•Toronto, ON

3h•CA$70,500 - CA$85,500•Hybrid

About The Position

Impact Starts at UNICEF Canada JOIN OUR TEAM AS A DATA INTEGRATION DEVELOPER Are you a data integration developer with a passion for building seamless systems and driving meaningful impact? Looking to use your expertise to drive change and make a direct impact on the lives of children? Join UNICEF Canada – one using Canada’s most respected and historic charities – and be part of a high-impact, mission-driven team working across Canada and globally to create a better world for children. We are seeking a talented individual for the role of Data Integration Developer Position Details Position Title: Data Integration Developer Employment Type: Full-time, Permanent (Vacant – New Role) Reports to: Director, Data & Insights Direct Reports: 0 Salary Range: $70,500 to $85,500 per year annually with benefits and 3 weeks paid vacation Work Location: Toronto Work Environment: UNICEF Canada currently operates under a Fixed-Hybrid model that requires team members to attend the office at least 2 days/week (Tuesday/Wednesday) Why UNICEF & UNICEF Canada? UNICEF [https://www.unicef.org/] is the world’s farthest-reaching humanitarian organization for children. Across 190 countries and territories, and in the world’s toughest places, we provide and advocate for education, health and nutrition services. Protect children from violence and abuse. Bring clean water and sanitation to those in need. Keep them safe from climate change and disease. Serve as the world’s largest provider of vaccines. Before, during and after emergencies, we’re on the ground with life-saving help and hope. The needs of children around the world continue to increase and the role of UNICEF is more important than ever. UNICEF Canada [https://www.unicef.ca/en] is one of 32 National Committees (NatComs) located in high-income countries around the world. Our team exists to fundraise for UNICEF’s highest priorities, and to work neutrally with governments and the private sector in Canada and internationally to advance the rights and well-being of children and youth. As UNICEF Canada launches a bold new Strategic Plan in 2026, raising funds in support of children around the world will remain a key focus. Be part of this next phase of impact! The Opportunity We are seeking a skilled Data Integration Developer to play a critical role in designing, developing, and maintaining data integration solutions that support our fundraising and enterprise data ecosystem. As a key member of the Data & Insights team, this role is accountable for ensuring that supporter data is accurately captured, integrated, validated, transformed, and moved across systems through automation and integration of workflows. The successful candidate will work across a broad technical landscape - including ETL/ELT pipelines, APIs, automation tools, and vendor integrations - to ensure data integrity and operational continuity. This is an opportunity to join a high-performing team, solve meaningful and technically complex problems, and contribute directly to the ongoing execution and evolution of our enterprise data strategy.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.

Benefits

Extended Health/Dental benefits
Healthcare Spending Account
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
Minimum 3 weeks of annual vacation (increases with time served)
1 additional day per year of service (max 30)
10 paid sick days
2 personal days
8 to 11 employee wellness days
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
Opportunities to access both local & global stretch assignments