Data Analyst / Developer - Power BI & Microsoft Fabric

Data Analyst / Developer - Power BI & Microsoft Fabric

Term: 1 year

Hours: 37.5 / week

Location: Hybrid: 12 days on-site / mth in Ottawa (3 days / wk)

Clearance: Minimum 5 years residency in Canada in order to get Secret clearance

Services:

The Consultant will be responsible for providing the following Services in order of priority to the Bank:

Under the direction of the Assistant Director, Cyber Strategy and Awareness:

• 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 on-premises 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.

• Other activities and deliverable, as required.

Required Qualifications & Skills:

The Consultant should have the following qualifications and 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.