Data Integration Developer

UNICEF Canada; Toronto; On-site; CAD 70,000 - 86,000; Full time

Job summary

A leading child-focused organization in Toronto seeks a Data Integration Developer. You will be responsible for designing ETL pipelines and maintaining data integration solutions. The ideal candidate has over 5 years of experience in data integration, strong SQL skills, and proficiency in automation scripting. This role offers a flexible-hybrid work environment with comprehensive benefits, including a minimum of 3 weeks of vacation.

Benefits

Minimum 3 weeks of annual vacation

10 paid sick days

Discounted gym membership

Qualifications

• Qualified candidates must have 5+ years of data integration experience.
• Strong performance tuning and query optimization skills required.
• Experience in the not-for-profit sector is a plus.

Responsibilities

• Design ETL/ELT pipelines to integrate various data sources.
• Maintain and troubleshoot existing data integration solutions.
• Provide training and support for data integration processes.

Skills

Data integration and ETL development

Strong SQL skills

Automation scripting (Python, PowerShell, Scala)

Experience with BlackBaud Raiser’s Edge

Data warehousing concepts

Education

Post-secondary degree in a related field

Tools

Microsoft SQL Server

Engaging Networks platform

ImportOmatic

Job description

Position Details

Position Title: Data Integration Developer

Employment Type: Full-time, Permanent (Vacant – New Role)

Reports to: Deputy Director, Business Intelligence

Direct Reports: 0

Salary Range: $70,500 to $85,500 per year annually with benefits and 3 weeks paid vacation

Work Location: Toronto

Work Environment: UNICEF Canada currently operates under a Flexible-Hybrid model that requires team members to attend the office at least 2 days / week.

The Opportunity

We 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 Accountabilities

New 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 strategy
• Work independently to understand business needs, meet with stakeholders, test, verify, and document new processes
• Contribute to the ongoing development and evolution of our overall Data Strategy by identifying opportunities for improving efficiency, accuracy, and usefulness of data through automation

Ongoing 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 processes
• Automated 2-way data integration between Raiser’s Edge and our Engaging Networks online fundraising platform
• Daily fundraising data imports into Raiser’s Edge through ImportOmatic
• Import and export processes to integrate data with fundraising vendors

Vendor Management (10%)

• Oversee ongoing development and maintenance of data transfer protocols with our fundraising vendors
• Coordinate all changes to ensure seamless fundraising operations
• Act as the primary point of contact with fundraising vendors’ data specialists

User Support (5%)

• Provide second‑level support to the donation processing team on existing data integration, data entry, and import processes
• Provide training to the donation processing team on how to run data integration, data entry, and import processes
• Ensure data integration is documented and well communicated

Qualifications

• A post‑secondary degree in a related field
• 5+ years of data integration and ETL development using different tools, e.g., Microsoft SQL Server and its accompanying tools, Microsoft Power Platform
• Strong SQL skills, including performance tuning and query optimization.
• Proficiency in scripting languages like Python, PowerShell, or Scala for automation and data processing tasks
• Experience in data management in a not‑for‑profit / fundraising organization is considered an asset
• Knowledge and hands‑on experience using BlackBaud Raiser’s Edge or equivalent constituent relationship management (CRM) database
• Experience supporting third‑party program integration and marketing tools. We use the Engaging Networks online fundraising platform
• Experience with integrating data from APIs and other web services
• Knowledge of data warehousing concepts, data modelling, and best practices
• Experience with C# and .NET framework development is considered an asset
• Experience with Salesforce is considered an asset
• Experience working with ImportOmatic is considered an asset
• Current and relevant certifications are a strong plus

Key Competencies

• Accuracy and attention to detail
• Ability to work independently
• Ability to work under deadlines
• Excellent problem‑solving skills
• Strong interpersonal skills

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 COMMITMENT TO WELLNESS

• 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 – 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, & 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 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 children

Our Commitment to Inclusive Workplaces & Recruitment

UNICEF 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 Apply

Please submit your resume and cover letter as one document to [e-mail] by 11 : 59 PM EST on Thursday, November 27, 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).