Data Analyst/Developer - Power BI & Microsoft Fabric
Role summary
Seeking a Data Analyst/Developer for a one-year contract in Ottawa, supporting cyber-focused analytics. This hybrid role requires 12 days/month in-office and eligibility for a Secret-level security clearance. Responsibilities include designing and delivering end-to-end data solutions using Power BI and Microsoft Fabric, from data ingestion and transformation to semantic model and dashboard development. The role also involves API integration, developing AI-driven solutions with tools like Copilot Studio and Power Platform, and promoting data governance and responsible AI usage. Expertise in Power BI (DAX, performance optimization) is essential.
Location Ottawa Language English Required Security Clearance Secret Security Clearance Required
Role And Responsibilities
We are seeking a skilled Data Analyst/Developer with strong expertise in Power BI and Microsoft Fabric to support advanced analytics initiatives within a cyber-focused environment. This is a hybrid role requiring 12 days per month in-office, with the remaining time remote, and candidates must be eligible to obtain and maintain a Secret-level security clearance. In this position, you will design and deliver end-to-end data solutionsfrom ingesting and transforming data to building robust semantic models and intuitive, high-performance dashboardswhile ensuring secure, reliable access to data from both internal and external sources.
You will also leverage modern Microsoft tools such as Copilot Studio and the Power Platform to develop AI-driven solutions and workflow automation, including intelligent agents that support data insights and operational efficiency. The role involves establishing trusted data environments, applying governance best practices, and promoting responsible AI usage. The ideal candidate brings deep experience in Power BI (including DAX and performance optimization), working knowledge of Microsoft Fabric, and strong API integration skills, along with the ability to collaborate with stakeholders and provide technical leadership. This is a one-year contract starting May 11.