Job Title

Our client in the non-profit sector is seeking a contract based Data Integration Developer to design, develop, and maintain data integration and automation solutions. Location: Hybrid Toronto Duration: 9 months to start Responsibilities: Manage daily automated BI data processes, automated two-way data integration between Raisers Edge and Engaging Networks, daily fundraising data imports into Raisers Edge through ImportOmatic, and import/export processes that integrate data with fundraising vendors. Design and build ETL/ELT pipelines that process structured and unstructured data, and develop automation and integration solutions that support the overall data strategy. Work independently to gather business requirements, meet with stakeholders, conduct testing and verification, and document new processes. Identify opportunities to improve efficiency, accuracy, and usefulness of data through automation and contribute to the ongoing evolution of the data strategy. Oversee, maintain, and troubleshoot all existing data integration solutions and pipelines to ensure ongoing data integrity and alignment with business needs. Maintain and optimize data transfer protocols with fundraising vendors. Coordinate changes with vendors to ensure uninterrupted fundraising operations. Serve as the primary point of contact for vendor data specialists. Requirements 5 years of experience in data integration and ETL development using tools such as Microsoft SQL Server and Microsoft Power Platform. Experience with ImportOmatic and VB code. Strong SQL skills, including performance tuning and query optimization. Proficiency in scripting languages such as Python, PowerShell, or Scala. Experience working in a nonprofit or fundraising environment is an asset. Knowledge of and hands-on experience with Blackbaud Raisers Edge or an equivalent CRM database. Experience integrating third-party programs and marketing tools, including the Engaging Networks fundraising platform. Experience integrating data from APIs and web services. Knowledge of data warehousing concepts, data modelling, and best practices. Experience with C# and the .NET framework is an asset. Experience with Salesforce is an asset. Relevant and current certifications are a strong plus.