Job Specifications
Our client, the Bank of Canada in Ottawa has a 12 month hybrid remote renewable contract for a Senior Data Analyst / Developer.
Candidates must be a permanent resident or a Canadian citizen and have lived in Canada a minimum of 5 years.
Serve as the Data & Analytics Architect for the Cyber Division, providing end-to-end architecture expertise across Microsoft Fabric, PowerBi, and Copilot Studio – from ingestion and modeling through semantic design, reporting, governance, and AI-assisted analytics.
• Deliver high impact reporting with Power BI and Microsoft Fabric including, design data ingestion and establishment of trusted data repositories, design semantic models and implement DAX, build optimized and user-friendly reports, performance tuning and governance (endorsements, certification, lineage).
• Design Copilot Studio agents that answer data questions and automate workflows (Power Automate, Dataverse, Microsoft Graph) with strong guardrails (RBAC), Power Platform DLP policies, responsible evaluation/grounding for data Q&A, workflow automation and Agentic AI solutions.
• Implement secure, authenticated refresh (OAuth2/API keys) including connection to external systems via REST APIs (OAuth2/API keys), handle pagination, throttling, and secure refresh, configuration of onpremises data gateway connections where needed and document assumptions and limitations.
• Use Copilot in Power BI for faster authoring and insight summaries.
• Promote responsible AI: ensure data readiness for Copilot, apply grounding/evaluation practices, and enable users in line with our Generative AI guidelines.
• Provide guidance and subject-matter expertise to Cyber colleagues to support knowledge transfers and skill development.
Required Qualifications & Skills:
• A minimum of five (5) years of demonstrated advanced experience in Power BI modeling & DAX, performance analyzer, governance.
• A minimum of five (5) years demonstrated advanced experience in API literacy for analytics (auth, pagination, throttling).
• A minimum of two (2) years demonstrated advanced experience in Microsoft Fabric fundamentals (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
• A minimum of two (2) years demonstrated advanced experience in Copilot Studio agent design and integrations (Power Automate/Dataverse/Graph).
Additional Qualifications The following will also be considered:
• RTI/KQL experience; Activator alerting.
• Demonstrated experience as a technical lead in a Power BI/MS Fabric Community of Practice.
• Demonstrated ability to effectively engage with stakeholders at a variety of levels
About the Company
At CQ Search we understand that people make your business succeed, and we will deliver those candidates to you. We are committed to a thorough assessment of available and qualified candidates to assure that proper "fit". The benchmark of OUR success is that an employee you hire from CQ Search Group Ltd. thrives in your environment
Know more