CRM & Power Platform Administrator

The CRM & Power Platform Administrator is the organization's resident expert on our Microsoft Dynamics 365 environment and the wider Microsoft Power Platform. Reporting to the Executive Director, Development Strategy & Systems, this role owns the day-to-day administration, configuration, security, and continuous improvement of the CRM as the central system supporting donor relations, fundraising, gift processing, charitable tax-receipting, and constituent engagement.

Working across departments, the Administrator translates business needs into reliable, well-documented technical solutions — automating data entry, safeguarding data integrity, building reporting and analytics, and enabling staff through training and standard operating procedures. Because the environment is maintained within a shared, centrally-governed framework, the role delivers enhancements and customizations without compromising the stability, security, or integrity of core CRM functionality, and coordinates with the Jewish Federations of North America (JFNA) collective — distinguishing between local configuration and changes managed centrally.

Responsibilities include, but are not limited to, the following.

• Administer the Dynamics 365 environment day-to-day, including Dataverse tables, forms, views, business rules, and solution/environment management (development, test, and production).
• Configure and maintain the core Dynamics 365 customer engagement apps in line with organizational processes and the shared, centrally-governed build.
• Manage application lifecycle and release practices — testing centrally-managed build updates and Microsoft releases before deployment, and communicating changes to affected staff.
• Distinguish between locally configurable elements and centrally-managed build components, escalating and coordinating accordingly.

• Own the CRM security model: security roles, teams, business units, field-level security, and least-privilege access provisioning and reviews.
• Apply cybersecurity best practices across the platform (access control, MFA/conditional access alignment with Entra /M365, audit logging, and periodic access recertification).
• In collaboration with Marketing, Finance, and other stakeholders, support data privacy and regulatory compliance relevant to Canadian charities — including BC PIPA/PIPEDA for personal information and CASL consent management for electronic marketing — by implementing and maintaining the supporting technical controls.
• Maintain the integrity of gift-processing and charitable tax-receipting workflows to ensure they remain accurate, auditable, and CRA-compliant.

• Design, build, and maintain Power BI reports and dashboards tailored to individual, departmental, and leadership needs.
• Develop robust data models and measures (Power Query / DAX), and review and streamline existing reports to reduce duplication and improve reliability.
• Deliver fundraising, campaign, and donor analytics, and support reconciliation between the CRM and finance systems where required.

• Administer and support Dynamics 365 Customer Insights (Data and Journeys), including segments, customer journeys, email marketing, and event or campaign flows.
• In partnership with Marketing, support CASL-compliant marketing execution — consent capture, subscription management, and unsubscribe handling.

• Manage and support third-party integrations to the CRM, including document generation (Documents Core Pack ) and address/data-validation tooling (e.g., Loqate or Melissa Data).
• Work with stakeholders across departments (Foundation, Finance, Marketing, etc.) to determine appropriate coding and categorization of CRM data.
• Oversee data hygiene and quality — deduplication, standardization, validation, and enrichment — and implement and document the standards that maintain it.
• Design and manage data imports, exports, transformations, and migrations using platform and supported third-party tools.

• Serve as the primary point of…