Data Integration Developer

Position DetailsPosition Title: Data Integration DeveloperEmployment Type: Full-time, Permanent (Vacant – New Role)Reports to: Deputy Director, Business IntelligenceDirect Reports: 0Salary Range: $70,500 to $85,500 per year annually with benefits and 3 weeks paid vacationWork Location: TorontoWork Environment: UNICEF Canada currently operates under a Flexible-Hybrid model that requires team members to attend the office at least 2 days/week. The OpportunityWe are seeking a skilled Data Integration Developer to join our team and play a crucial role in designing, developing, and maintaining data integration solutions. The ideal candidate will have hands-on experience with data extraction, configuration, automation, and workflow orchestration.As a key member of the Business Intelligence team, the Data Integration Developer is responsible for all supporter data created, modified, or moved through automation and integration. The successful candidate will have the opportunity to be part of a great team, to solve interesting and challenging problems, and help shape the ongoing development and implementation of our data strategy.Key AccountabilitiesNew Automation and Integration Solutions (45%) Design and build ETL/ELT pipelines to process structured and unstructured data, automation, and integration solutions in support of our overall data strategyWork independently to understand business needs, meet with stakeholders, test, verify, and document new processesContribute to the ongoing development and evolution of our overall Data Strategy by identifying opportunities for improving efficiency, accuracy, and usefulness of data through automationOngoing Management of Automation and Integration Solutions (40%)Oversee, maintain, and troubleshoot all existing data integration solutions and pipelines to ensure automated processes and business processes preserve data integrity and meet business goals. These processes include:Daily automated BI data processesAutomated 2-way data integration between Raiser’s Edge and our Engaging Networks online fundraising platformDaily fundraising data imports into Raiser’s Edge through ImportOmaticImport and export processes to integrate data with fundraising vendorsVendor Management (10%)Oversee ongoing development and maintenance of data transfer protocols with our fundraising vendorsCoordinate all changes to ensure seamless fundraising operationsAct as the primary point of contact with fundraising vendors’ data specialistsUser Support (5%)Provide second-level support to the donation processing team on existing data integration, data entry, and import processesProvide training to the donation processing team on how to run data integration, data entry, and import processesEnsure data integration is documented and well communicatedQualificationsA post-secondary degree in a related field5+ years of data integration and ETL development using different tools, e.g., Microsoft SQL Server and its accompanying tools, Microsoft Power PlatformStrong SQL skills, including performance tuning and query optimization.Proficiency in scripting languages like Python, PowerShell, or Scala for automation and data processing tasksExperience in data management in a not-for-profit/fundraising organization is considered an assetKnowledge and hands-on experience using BlackBaud Raiser’s Edge or equivalent constituent relationship management (CRM) databaseExperience supporting third-party program integration and marketing tools. We use the Engaging Networks online fundraising platformExperience with integrating data from APIs and other web servicesKnowledge of data warehousing concepts, data modelling, and best practicesExperience with C# and .NET framework development is considered an assetExperience with Salesforce is considered an assetExperience working with ImportOmatic is considered an assetCurrent and relevant certifications are a strong plusKey Competencies:Accuracy and attention to detailAbility to work independentlyAbility to work under deadlinesExcellent problem-solving skillsStrong interpersonal skillsAn Employer of Choice: What We OfferUNICEF 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 COMMITMENT TO WELLNESSMinimum 3 weeks of annual vacation (increases with time served) & 1 additional day per year of service (max 30)10 paid sick days & 2 personal days8 to 11 employee wellness days – an additional series of pre-set days off, given annually to further extend long weekendsDiscounted rate for a GoodLife gym membershipAccess to an Employee and Family Assistance ProgramA CULTURE OF LEARNING & GROWTHAccess to a comprehensive global learning platform with over 1600 courses, webinars & resourcesInternal leadership development, training, & mentorship programs that integrate Anti-Racism and diversity, equity and inclusion principlesOpportunities to access both local & global stretch assignmentsAN INCLUSIVE & PURPOSE-DRIVEN WORKPLACECentrally located head office in mid-town Toronto with satellite offices in Calgary & MontrealEasily accessed by public transit and a short walk from several parking locationsInclusive & accessible co-working and meeting spaces designed to foster purpose at every turn and accommodate the diverse needs of employeesA CHANCE TO DO MEANINGFUL & LIFE-CHANGING WORKUnder the leadership of a dynamic, accomplished, and experienced executive leadership team, you’ll be part of a diverse & talented Canada 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 childrenOur Commitment to Inclusive Workplaces & RecruitmentUNICEF Canada is an inclusive workplace and is committed to championing diversity, equity, inclusion, and accessibility. Accommodation requests 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 ApplyPlease submit your resume and cover letter as one document to careers@unicef.ca by 11:59 PM EST on Friday, December 5, 2025. Please include your salary expectations in your cover letter and 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).