Data Analyst Developer

Myticas LLC; Ottawa; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A financial services company in Ottawa is seeking a Data Analyst / Developer for a long-term HYBRID contract role. The ideal candidate will have extensive hands-on experience with Power BI and Microsoft Fabric, supporting various data analytics and reporting initiatives. This position involves designing and implementing solutions, managing Power BI projects, and promoting responsible AI practices. Strong expertise in API integrations, data governance, and stakeholder engagement is essential.

Qualifications

• 5 years advanced experience with Power BI modeling, DAX, performance analyzer & governance.
• 5 years experience with API literacy for analytics (OAuth2, pagination, throttling, secure refresh).
• 2 years hands‑on experience in Microsoft Fabric (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
• 2 years experience designing Copilot Studio agents and integrating with Power Automate, Dataverse, and Microsoft Graph.

Responsibilities

• Design Copilot Studio agents for data Q&A and workflow automation.
• Implement secure API refresh using OAuth2/API keys and REST integrations.
• Manage Power BI end‑to‑end for the Cyber division.
• Build high‑impact Power BI & Microsoft Fabric solutions.
• Leverage Copilot in Power BI for report creation.
• Promote responsible AI practices.
• Provide SME guidance and coaching.
• Support additional analytics and reporting.

Skills

Power BI modeling

DAX

API literacy

Microsoft Fabric

Copilot Studio

Job description

Our financial client is seeking a Data Analyst / Developer specialized in Power BI & Microsoft Fabric

For a long term HYBRID contract, the Developer will support cyber strategy, analytics, AI enablement, and reporting initiatives. This role requires strong hands‑on experience with Power BI, Fabric, API integrations, and Copilot Studio.

Key Responsibilities

• Design Copilot Studio agents for data Q&A and workflow automation (Power Automate, Dataverse, Graph API) with strong governance and RBAC controls.
• Implement secure, authenticated API refresh using OAuth2/API keys, including pagination, throttling, REST integrations, and on‑prem gateway configurations.
• Manage Power BI end‑to‑end for the Cyber division (semantic modeling, DAX, UX, performance tuning, lineage, governance).
• Build high‑impact Power BI & Microsoft Fabric solutions including trusted data ingestion, semantic modeling, and optimized reporting.
• Leverage Copilot in Power BI for accelerated report creation and insight generation.
• Promote responsible AI practices: grounding, evaluation, data readiness, and user enablement.
• Provide SME guidance, knowledge transfer, and coaching to internal Cyber teams.
• Support additional analytics and reporting activities as required.

Required Qualifications

• 5 years advanced experience with Power BI modeling, DAX, performance analyzer & governance.
• 5 years experience with API literacy for analytics (OAuth2, pagination, throttling, secure refresh).
• 2 years hands‑on experience in Microsoft Fabric (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
• 2 years experience designing Copilot Studio agents and integrating with Power Automate, Dataverse, and Microsoft Graph.

Nice‑to‑Have Skills

• Experience with RTI/KQL, Activator alerting.
• Experience as a technical lead in a Power BI or Fabric Community of Practice.
• Strong stakeholder engagement across multiple levels.