AI Integration Consultant

OpenKyber LLC

31 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Intermediate

Job location

Remote

Tech stack

API

Artificial Intelligence

Data analysis

User Authentication

Data Governance

Data Security

Data Systems

OAuth

Performance Tuning

Power BI

Kusto Query Language

SQL Databases

Systems Integration

Data Ingestion

Microsoft Power Automate

Microsoft Fabric

REST

Pagination

Job description

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., * 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

Requirements

Do you have experience in Power BI?, * 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: