Data Analyst / Developer - Power BI & Microsoft Fabric

**JOB DESCRIPTION
:**

• Serve as the Data & Analytics Architect for the Cyber Division, providing end-to-end architecture expertise across Microsoft Fabric, PowerBi, and Copilot Studio – from ingestion and modeling through semantic design, reporting, governance, and AI-assisted analytics.
• Deliver high impact reporting with Power BI and Microsoft Fabric including, design data ingestion and establishment of trusted data repositories, design semantic models and implement DAX, build optimized and user-friendly reports, performance tuning and governance (endorsements, certification, lineage).
• Design Copilot Studio agents that answer data questions and automate workflows (Power Automate, Dataverse, Microsoft Graph) with strong guardrails (RBAC), Power Platform DLP policies, responsible evaluation/grounding for data Q&A, workflow automation and Agentic AI solutions.
• Implement secure, authenticated refresh (OAuth2/API keys) including connection to external systems via REST APIs (OAuth2/API keys), handle pagination, throttling, and secure refresh, configuration of on-premises data gateway connections where needed and document assumptions and limitations.
• Use Copilot in Power BI for faster authoring and insight summaries.
• Promote responsible AI: ensure data readiness for Copilot, apply grounding/evaluation practices, and enable users in line with our Generative AI guidelines.
• Provide guidance and subject-matter expertise to Cyber colleagues to support knowledge transfers and skill development.
• Other activities and deliverable, as required.

Required Qualifications & Skills:

The Consultant should have the following qualifications and skills:

• A minimum of five (5) years of demonstrated advanced experience in Power BI modeling & DAX, performance analyzer, governance.
• A minimum of five (5) years demonstrated advanced experience in API literacy for analytics (auth, pagination, throttling).
• A minimum of two (2) years demonstrated advanced experience in Microsoft Fabric fundamentals (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
• A minimum of two (2) years demonstrated advanced experience in Copilot Studio agent design and integrations (Power Automate/Dataverse/Graph).

Additional Qualifications:

The following will also be considered:

• RTI/KQL experience; Activator alerting.
• Demonstrated experience as a technical lead in a Power BI/MS Fabric Community of Practice.
• Demonstrated ability to effectively engage with stakeholders at a variety of levels