Data Integration Developer

Canadian Unicef Committee • Toronto, ON

2d • 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. 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level