cover image
Myticas Consulting

Data Analyst Developer (34507)

Hybrid

Ottawa, Canada

Mid level

Freelance

08-02-2026

Share this job:

Skills

SQL Analytics and Reporting Coaching power bi Analytics Power Automate DAX

Job Specifications

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.

,

About the Company

Myticas Consulting is a proven industry-leading IT Staffing and Recruitment organization, with active locations in major North American cities such as Ottawa Ontario, Chicago Illinois, and Atlanta Georgia. Our large team of IT recruitment and sales professionals have over 50+ years of combined experience providing the highest quality of Telecommunication Engineering, ERP and IT Software Development resources, to both Public and Private sector enterprise level environments. Here at Myticas, we strive to continually provide ... Know more