Data Analyst Developer – Power BI & Microsoft Fabric (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),