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
Data Integration Developer
Full-time, Permanent (Vacant – New Role)
Director, Data & Insights
$70,500 to $85,500 per year annually with benefits and 3 weeks paid vacation
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 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 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.
Key Accountabilities
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 enableaccurateandtimelymovement of supporter data across platforms.
-
Work independently to understand business needs, engage stakeholders, define requirements, perform testing and validation, and deliver well-documented solutions.
-
Identifyopportunities 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 businessobjectives, 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
-
Proactivelyidentifyand resolve issuesimpactingdata quality, automation performance, and integration reliability.
-
Maintainappropriate controlsand documentation to ensure operational stability and repeatability.
Vendor Management (5%)
-
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 tovalidatethe accuracy, completeness, and integrity of data across allintegrationpipelines and automated workflows.
-
Develop andmaintainautomated 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 theyimpactdownstream systems or fundraising operations.
-
Build andmaintainmonitoring 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
Required
-
Post-secondary degree in Computer Science, Information Systems, Engineering, ora relateddiscipline.
-
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 SQLexpertise, 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 withabilityto 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.
Key Competencies
-
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
An Employer of Choice: What We Offer
UNICEF Canada is where diverse talent & passion come together to create extraordinary impact for every child. We are committed to being an employer of choice and building a culture that is inclusive, ambitious, compassionate, and high impact.
Members of the UNICEF Canada team have access to the following employee benefits:
A ROBUST COMPENSATION PACKAGE
-
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 the work-life integration needs of our team
-
Minimum3weeks of annual vacation (increases with time served) & 1additionalday per year of service (max 30)
-
10 paid sick days & 2 personal days
-
8to 11 employee wellness days – anadditionalseries 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
A CULTURE OF LEARNING & GROWTH
-
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,equityand inclusion principles
-
Opportunities to access both local & global stretch assignments
AN INCLUSIVE & PURPOSE-DRIVEN WORKPLACE
-
Centrallylocatedhead 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
A CHANCE TO DO MEANINGFUL & LIFE-CHANGING WORK
-
Under the leadership of a dynamic, accomplished, and experienced executive leadership team,you’llbe part of a diverse & talentedCanadianteam committed to creating meaningful impact while fostering an inclusive and supportive work environment.
-
You’lljoin a global UNICEF family with a shared commitment toimpactthe lives of children
Our Commitment to Inclusive Workplaces & 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.
At UNICEF Canada, we believe strongly in personal connections, and our hiring process is entirely human-driven. We do not use AI or automated systems to review applications or conduct interviews. Each candidate is evaluated by our experienced team to ensure a fair and thoughtful hiring experience.
How to Apply
Please submit your resume and cover letter as one document to
[email protected] by
11:59 PM EST on June 10th Please include reference
“Data Integration Developer” clearly in the subject heading. UNICEF Canada thanks all applicants for their interest in this opportunity; however, only those selected for an interview will be contacted. Consistent with our Child Safeguarding Policy, all successful candidates must receive clearance by a police background check (including a vulnerable sector screen).