Data Analyst / Developer - Power BI & Microsoft Fabric

Position: Data Analyst / Developer - Power BI & Microsoft Fabric
Client: Public Sector
Location: Ottawa (Hybrid)
Duration: 1 Year
Security Clearance: Secret
Language: English
Background:
Kyndryl is seeking the Services of a Senior Data Analyst / Developer to serve as the Data & Analytics Architect for the clients 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.
They will also be tasked with delivering 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).
Qualifications

• 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).
• Ability to work in a hybrid environment in Ottawa (Downtown)
• Active Secret clearance with the federal government (Mandatory)

Responsibilities/Deliverables:

• 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

#IndKyn

• Please note this is for a contract position with one of our clients and not a fulltime employment role with Kyndryl Canada\*\*