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 of 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
Reports to: Director, Data & Insights
Salary Range: $70,500 to $85,500 per year plus benefits and 3 weeks paid vacation
Location: Toronto
Hybrid model: attend office at least 2 days per week (Tuesday/Wednesday)
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 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 Required
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 for personal or financial data.
Strong analytical skills with ability to diagnose complex data issues and 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.
An Employer of Choice: What We Offer UNICEF Canada is where diverse talent and 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.
A Robust Compensation Package
Extended Health/Dental benefits, Healthcare Spending Account, and Wellness Account
Life, AD&D, and Long-Term disability insurance coverage
Employer match contributions (5%) to a Group Pension Plan
Access to parental leave top‑up
A Commitment to Wellness
Flexible‑hybrid work environment to support work‑life integration needs of our team
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
A Culture of Learning & Growth
Access to a comprehensive global learning platform with over 1600 courses, webinars, & resources
Internal leadership development, training, and mentorship programs that integrate Anti‑Racism and diversity, equity and inclusion principles
Opportunities to access both local & global stretch assignments
An Inclusive & Purpose‑Driven Workplace
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
A Chance to Do Meaningful & Life‑Changing Work
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
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.
Consistent with our Child Safeguarding Policy, all successful candidates must receive clearance by a police background check (including a vulnerable sector screen).
#J-18808-Ljbffr
or continue with email
Join UNICEF Canada – one of 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
Reports to: Director, Data & Insights
Salary Range: $70,500 to $85,500 per year plus benefits and 3 weeks paid vacation
Location: Toronto
Hybrid model: attend office at least 2 days per week (Tuesday/Wednesday)
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 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 Required
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 for personal or financial data.
Strong analytical skills with ability to diagnose complex data issues and 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.
An Employer of Choice: What We Offer UNICEF Canada is where diverse talent and 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.
A Robust Compensation Package
Extended Health/Dental benefits, Healthcare Spending Account, and Wellness Account
Life, AD&D, and Long-Term disability insurance coverage
Employer match contributions (5%) to a Group Pension Plan
Access to parental leave top‑up
A Commitment to Wellness
Flexible‑hybrid work environment to support work‑life integration needs of our team
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
A Culture of Learning & Growth
Access to a comprehensive global learning platform with over 1600 courses, webinars, & resources
Internal leadership development, training, and mentorship programs that integrate Anti‑Racism and diversity, equity and inclusion principles
Opportunities to access both local & global stretch assignments
An Inclusive & Purpose‑Driven Workplace
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
A Chance to Do Meaningful & Life‑Changing Work
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
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.
Consistent with our Child Safeguarding Policy, all successful candidates must receive clearance by a police background check (including a vulnerable sector screen).
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more