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

#J-18808-Ljbffr

📌 Data Integration Developer & QA (Toronto)
🏢 UNICEF Canada
📍 Toronto