What are the responsibilities and job description for the Data Analyst Developer – Power BI & Microsoft Fabric (34781) position at Myticas Consulting?
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.
Key Responsibilities
Secret Clearance (Consultant must reside in Canada for a minimum of 5 years),
Key Responsibilities
- 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
- 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)
- RTI / KQL experience
- Experience with Activator alerting
- Experience leading or contributing to a Power BI / Fabric Community of Practice
- Strong stakeholder engagement and communication skills
Secret Clearance (Consultant must reside in Canada for a minimum of 5 years),