This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Our Financial client is seeking a Data Analyst / Developer to support the Cyber Division, acting as a Data & Analytics Architect across Microsoft Fabric, Power BI, and Copilot Studio for a long term HYBRID contract in Ottawa.
Job Responsibility:
Serve as Data & Analytics Architect across Microsoft Fabric, Power BI, and Copilot Studio
Design and deliver end-to-end data solutions (ingestion, modeling, semantic layers, reporting, governance)
Develop Power BI reports including DAX modeling, performance tuning, and data governance
Build and manage data ingestion pipelines and trusted data repositories
Design and implement Copilot Studio agents and AI-driven workflows (Power Automate, Dataverse, Graph)
Integrate external data via REST APIs (OAuth2/API keys), including pagination and throttling handling
Configure secure data refresh and on-premises data gateway connections
Promote responsible AI practices and support Copilot enablement
Provide knowledge transfer and SME guidance to internal stakeholders
Requirements:
5+ years advanced experience with Power BI (modeling, DAX, performance tuning, governance)
5+ years experience with API integration for analytics (authentication, pagination, throttling)
2+ years experience with Microsoft Fabric (Workspaces, Pipelines, OneLake, Notebooks, SQL Analytics)
2+ years experience with Copilot Studio and integrations (Power Automate, Dataverse, Microsoft Graph)
Secret Clearance (Consultant must reside in Canada for a minimum of 5 years)
Nice to have:
RTI / KQL experience
Experience with Activator alerting
Experience leading or contributing to a Power BI / Fabric Community of Practice
Strong stakeholder engagement and communication skills