Data Integration Developer
UNICEF Canada
A complete application in a minute — tailored resume and cover letter, ready to send.
Benefits offered by this job
Job summary
UNICEF Canada is seeking a Data Integration Developer to design, build, and maintain scalable data pipelines, automation, and integration across fundraising platforms. You will contribute to our data strategy, ensure data quality, and support decision making for programs that reach children.
Based in Toronto with a flexible-hybrid model, you will report to the Director of Business Intelligence, collaborate across teams, and help advance UNICEF Canada's mission with robust ETL solutions and
Qualifications
- A post‑secondary degree in a related field.
- 5+ years in data integration and ETL with SQL Server & Power Platform.
- Strong SQL skills, including performance tuning.
- Proficiency in Python, PowerShell, or Scala for automation.
- Not-for-profit/fundraising data management experience is a plus.
- Knowledge of BlackBaud Raiser’s Edge or similar CRM.
- Experience with Engaging Networks for marketing data.
- Experience integrating data from APIs and web services.
- Knowledge of data warehousing concepts and modeling basics.
- C# and .NET development experience is a plus.
- Salesforce experience is a plus.
- ImportOmatic experience is a plus.
- Certifications are a plus.
- Accuracy and attention to detail.
- Ability to work independently.
- Ability to meet deadlines.
- Strong problem-solving skills.
- Strong interpersonal skills.
Responsibilities
- Design and build ETL/ELT pipelines to process structured and unstructured data.
- Collaborate with stakeholders to understand needs, test, verify, and document new processes.
- Advance the Data Strategy by identifying automation opportunities.
- Oversee and troubleshoot existing data pipelines to ensure data integrity.
- Manage daily automated BI data processes and integrations with vendors.
- Coordinate changes to ensure seamless fundraising operations with data teams.
- Provide second-level support and training on data integration processes.
Skills
Education
Tools
Job description
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 teamworking 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 Title: Data Integration Developer
Employment Type: Full-time, Permanent (Vacant – New Role)
Reports to: 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: Work Environment:UNICEF Canada currently operates under a Flexible-Hybrid model that requires team members to attend the office at least 2 days/week.
UNICEF is the world’s farthest-reaching humanitarian organization for children. Across 190 countries and territories, and in the world’s toughest places, we provide and advocate for education, health and nutrition services. Protect children from violence and abuse. Bring clean water and sanitation to those in need. Keep them safe from climate change and disease. Serve as the world’s largest provider of vaccines. Before, during and after emergencies, we’re on the ground with life-saving help and hope. The needs of children around the world continue to increase and the role of UNICEF is more important than ever.
UNICEF Canada is one of 32 National Committees (NatComs) located in high-income countries around the world. Our team exists to fundraise for UNICEF’s highest priorities, and to work neutrally with governments and the private sector in Canada and internationally to advance the rights and well-being of children and youth.
As UNICEF Canada prepares to launch a bold new Strategic Plan in 2026, raising funds in support of children around the world will remain a key focus. Be part of this next phase of impact!
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.
- Design and buildETL/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
- 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
- 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
- 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
- A post‑secondary degree in a related field
- 5+ yearsof 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
- Accuracy and attention to detail
- Ability to work independently
- Ability to work under deadlines
- Excellent problem‑solving skills
- Strong interpersonal skills
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:
- 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 the 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)
- 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
- 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
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
