Data Analyst / Developer – Power BI & Microsoft Fabric
- Location: Ottawa
- Type: Contract
- Job #34781
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.
Key Responsibilities
-
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
Required Skills & Experience
-
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)
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
Additional Requirements
Secret Clearance (Consultant must reside in Canada for a minimum of 5 years)