- Company Name
- CQ Search Group Ltd.
- Job Title
- Data Analyst / Power BI Developer
- Job Description
-
Job Title: Senior Data Analyst / Power BI Developer
Role Summary: Lead the end‑to‑end architecture of data and analytics for the Cyber Division, delivering solutions across Microsoft Fabric, Power BI, and Copilot Studio. Responsibilities include data ingestion, semantic modeling, reporting, governance, secure API integration, and AI‑enhanced insights.
Expectations: Design trusted data pipelines, build high‑impact, performance‑optimized reports, implement secure data refresh, architect Copilot Studio agents, and promote responsible AI governance. Serve as subject‑matter expert and mentor for Cyber stakeholders.
Key Responsibilities
• Design and implement data ingestion pipelines within Microsoft Fabric (Workspaces, Notebooks, Pipelines, OneLake, SQL analytics).
• Model data using DAX, create semantic layers, and optimize reports with Power BI Performance Analyzer.
• Develop secure, reliable API connections (OAuth2, API keys); handle pagination, throttling, and on‑premises data gateway configuration.
• Build Copilot Studio agents for data‑question answering and workflow automation via Power Automate, Dataverse, and Microsoft Graph; enforce RBAC, DLP, and responsible AI practices.
• Use Copilot in Power BI for faster authoring and insight summaries.
• Apply governance standards (endorsement, certification, lineage) and promote responsible AI guidelines.
• Deliver knowledge transfer and skill development to Cyber colleagues; act as SME in data and analytics.
• Engage stakeholders at all levels to gather requirements, provide updates, and facilitate solution adoption.
Required Skills
• 5+ years Power BI modeling & DAX, performance tuning, and governance.
• 5+ years API literacy for analytics (authentication, pagination, throttling).
• 2+ years Microsoft Fabric fundamentals (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
• 2+ years Copilot Studio agent design and integration (Power Automate, Dataverse, Graph).
• Strong knowledge of secure authentication, data governance, and responsible AI.
• Excellent communication and stakeholder engagement.
Optional/Additional Qualifications
• Experience with RTI/KQL and Activator alerting.
• Technical lead experience in a Power BI/Microsoft Fabric Community of Practice.
Required Education & Certifications
• No specific degree or certification required.
• Must be legally authorized to work in Canada and have resided in Canada for ≥ 5 years.