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

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.