Data Analyst / Developer – Power BI & Microsoft Fabric - DA 26-02858
Role summary
This is a 1-year contract role for a Data Analyst / Developer specializing in Power BI and Microsoft Fabric, based in Ottawa, Canada, with a hybrid work model (3 days/week on-site). The position requires the ability to obtain a Secret security clearance, with a typical residency requirement of 5 years in Canada. The role involves end-to-end data architecture, reporting, governance, and implementing AI-driven analytics solutions using Microsoft Fabric, Power BI, and Copilot Studio. Key responsibilities include designing data pipelines, developing semantic models, integrating systems via APIs, and promoting responsible AI practices. A minimum of 5 years of experience in Power BI and API integration, along with 2 years in Microsoft Fabric and Copilot Studio, is required.
Title: Data Analyst / Developer – Power BI & Microsoft Fabric
Location: Ottawa, Canada (Hybrid – 3 days/week on-site, 12 days/month)
Duration: 1 Year Contract
Clearance Requirement: *Ability to obtain* *Secret security clearance* *is required (typically requires 5 years residency in Canada). Candidates not meeting clearance eligibility criteria may not be considered for this role.*
### Description
Work Hours:
- 37.5 hours per week
Language:
- English
### Role Overview
We are seeking a Data Analyst / Developer with strong expertise in Power BI and Microsoft Fabric to support enterprise data and analytics initiatives. This role involves end-to-end data architecture, reporting, governance, and implementation of AI-driven analytics solutions.
### Key Responsibilities
- Serve as the Data & Analytics Architect, providing end-to-end expertise across Microsoft Fabric, Power BI, and Copilot Studio
- Design and implement data ingestion pipelines and trusted data repositories
- Develop semantic models, implement DAX, and build optimized, user-friendly reports
- Perform performance tuning and enforce governance practices (endorsement, certification, lineage)
- Design and deploy Copilot Studio agents for data Q&A and workflow automation
- Integrate systems using REST APIs with secure authentication (OAuth2/API keys), handling pagination and throttling
- Configure on-premises data gateways and document technical assumptions and limitations
- Leverage Copilot in Power BI for accelerated development and insights
- Promote responsible AI practices, including data readiness, grounding, and evaluation
- Provide guidance and knowledge transfer to internal teams
- Support additional data and analytics initiatives as required
### Required Skills
- 5+ years of advanced experience in Power BI (modeling, DAX, performance tuning, governance)
- 5+ years of experience with APIs for analytics (authentication, pagination, throttling)
- 2+ years of hands-on experience with Microsoft Fabric (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics)
- 2+ years of experience with Copilot Studio agent design and integrations (Power Automate, Dataverse, Microsoft Graph)
- Strong understanding of data architecture, reporting, and analytics best practices
### Nice to Have
- Experience with RTI/KQL and Activator alerting
- Experience as a technical lead within a Power BI or Microsoft Fabric Community of Practice
- Strong stakeholder management and communication skills across multiple levels
For more details reach at resumes@navitassols.com.