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 Raiser’s Edge and Engaging Networks, daily fundraising data imports into Raiser’s 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 Raiser’s 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.
