Data Architect– Power BI & Microsoft Fabric - DA#01


IT - CANADA - Montreal, QC
Montréal, Quebec
Locations: Montréal, Gatineau, Kanata, Nepean, Orleans
Last Day to Apply: April 03, 2026
Pay: From $70.00 per hour

Job Title: Data Architect – Power BI & Microsoft Fabric
Duration: 1-Year Contract
Work Hours: 37.5 hours/week
Location: Hybrid – Ottawa (3 days onsite per week | 12 days/month)
Language Requirement: English


Job Overview

"Navitas Partners, LLC" is seeking an experienced Data Architect – Power BI & Microsoft Fabric to join our Cyber Division as a Data & Analytics Architect. This role will lead the design and delivery of modern data solutions, leveraging Microsoft Fabric, Power BI, and Copilot Studio to enable advanced analytics, AI-driven insights, and workflow automation.

The ideal candidate will bring deep expertise across the full data lifecycle—from ingestion and modeling to semantic design, reporting, governance, and AI-assisted analytics.


Key Responsibilities

  • Act as the Data & Analytics Architect for the Cyber Division, providing end-to-end architectural guidance across Microsoft Fabric, Power BI, and Copilot Studio
  • Design and deliver scalable, high-performance reporting solutions, including:
    • Data ingestion and transformation
    • Trusted data repository design
    • Semantic modeling and DAX development
    • Performance optimization and tuning
    • Data governance (endorsement, certification, lineage)
  • Develop and implement Copilot Studio agents to support automated data Q&A and workflow automation using Power Automate, Dataverse, and Microsoft Graph
  • Ensure secure data integration by implementing authenticated connections (OAuth2/API keys), managing pagination, throttling, and configuring on-premises data gateways where required
  • Leverage Copilot in Power BI to accelerate report development and generate insight summaries
  • Promote responsible AI practices by ensuring data readiness and applying proper grounding and evaluation techniques aligned with Generative AI standards
  • Provide technical leadership, mentorship, and knowledge transfer to team members
  • Collaborate with stakeholders across the organization to deliver effective data solutions
  • Perform additional duties as required

Required Qualifications & Skills

  • Minimum 5 years of advanced experience in Power BI, including data modeling, DAX, performance tuning, and governance
  • Minimum 5 years of experience integrating APIs for analytics (authentication, pagination, throttling)
  • Minimum 2 years of hands-on experience with Microsoft Fabric (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics)
  • Minimum 2 years of experience designing and implementing Copilot Studio agents and integrations (Power Automate, Dataverse, Microsoft Graph)

Preferred Qualifications

  • Experience with RTI/KQL and Activator alerting
  • Proven experience serving as a technical lead within a Power BI or Microsoft Fabric Community of Practice
  • Strong stakeholder management and communication skills across multiple organizational levels

For more details reach at resumes@navitassols.com

About Navitas Partners, LLC: It is a certified WBENC and one of the fastest-growing Technical / IT staffing firms in the US providing services to numerous clients. We offer the most competitive pay for every position. We understand this is a partnership. You will not be blindsided and your salary will be discussed upfront.

Skip to the main content