Alquemy logo

Data Analyst/ Developer - Power BI & Microsoft Fabric

Alquemy
Contract
On-site
Ottawa, Canada

Job Description

Join our client’s Cyber Strategy and Awareness team to lead the design and implementation of advanced data solutions, automated workflows, and AI-driven agents. You will be responsible for the end-to-end management of our reporting ecosystem, ensuring data is secure, governed, and optimized for high-impact insights.

Core Responsibilities:

  • AI & Automation: Design Copilot Studio agents to automate workflows and answer data-driven questions using the Power Platform.
  • Data Engineering: Implement secure data ingestion, manage REST API connections (authentication, throttling), and design trusted data repositories and pipelines within Microsoft Fabric (OneLake, Notebooks, SQL Analytics).
  • Power BI Excellence: Oversee semantic model design, DAX implementation, and report UX, utilizing Copilot to accelerate authoring.
  • Governance & Security: Ensure data readiness for Generative AI through rigorous grounding and adherence to RBAC and DLP policies.
  • Mentorship: Act as a subject-matter expert to support skill development within the cyber division.

Required Qualifications:

  • Power BI: Minimum 5 years of advanced experience in modeling, DAX, performance tuning, and governance.
  • API Literacy: Minimum 5 years of experience handling API-based analytics, including authentication and throttling.
  • Microsoft Fabric: Minimum 2 years of advanced experience with Workspaces, Notebooks, Pipelines, and OneLake.
  • Copilot Studio: Minimum 2 years of experience designing agents and integrating them with the Power Platform.
  • Language: Full proficiency in English.

Technical Requirements:

  • Hardware/Software: Windows 11 device, USB A/C ports, high-speed internet, Windows App for Azure Virtual Desktop, and a smartphone for Microsoft Authenticator.

Preferred Skills:

  • Experience with RTI/KQL and Activator alerting.
  • Demonstrated experience as a technical lead in a Power BI/MS Fabric Community of Practice.
  • Strong stakeholder engagement skills.