Position Title: Dynamics CRM Data Solutions Architect (Enterprise Systems Architect & Data Integration Lead)
Reports to: Chief Information Officer (CIO)
Department: Information Technology, National Office
Location: Ottawa, ON (REMOTE)
Status: Full-Time, Permanent
Salary: $95,000 - 120,000 per year plus other perks and benefits

Position Overview

This strategic role leads the transformation of a fragmented IT environment into a unified, scalable, and secure ecosystem. The Enterprise Systems Architect & Data Integration Lead will oversee the consolidation of 75+ systems, integrating Sales, Volunteer Management, and Fundraising into a streamlined architecture. The role also drives data management, reporting, and security frameworks to support informed decision-making and operational efficiency.

Key Responsibilities

Systems Architecture & Integration

• Lead the consolidation of 75+ systems into integrated platforms.
• Design and document unified architecture for Sales, Fundraising, and Volunteer Management.
• Oversee legacy system decommissioning, migration, and vendor collaboration.

Data Strategy & Reporting

• Serve as the organization’s lead data steward.
• Develop data models, warehouses, and reporting frameworks using Power BI, D365, and Azure.
• Align data strategies with evolving business needs and user roles.

Technical Oversight & Integration Management

• Manage core system integrations using PowerAutomate, Scribe, and APIs.
• Maintain documentation on integration architecture, workflows, and dependencies.
• Drive continuous improvement in system performance and reliability.

Security & Access Governance

• Design and manage role-based access models across platforms.
• Align permissions and data access with privacy and operational requirements.
• Support interface and reporting access controls through sound governance.

Qualifications

Required:

• 5+ years in enterprise systems integration, architecture, or CRM/ERP projects.
• Proficiency with Microsoft Dynamics 365, Power Platform, Power BI, and Azure.
• Experience with system consolidation and rationalization.
• Strong understanding of data architecture, security roles, and access control.
• Advanced data reporting and warehousing expertise.

Assets:

• Experience in nonprofit, healthcare, or regulated sectors.
• Familiarity with Microsoft Fabric, Salesforce, HubSpot, Brightspace, and Business Central.
• Bilingual (EN/FR), PMP certification, SQL skills.

We’re an equal opportunity employer committed to increasing diversity and inclusion in today’s workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Minorities, women, LGBTQ candidates, and individuals with disabilities are encouraged to apply. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions.