Ambition Recruitment Hiring! Full Time BI Developer - Ambition in Hong Kong - Ricebowl

Key Responsibilities

1. AI & Fabric Data Agent Development

• Build & Deploy Data Agents: Design, test, and maintain Fabric-native Data Agents using Azure OpenAI Assistant APIs to enable natural language querying across Lakehouse, Warehouses, and KQL databases.
• Agentic Prompt Engineering: Design system prompts, few-shot examples, domain-specific instructions, and chain-of-thought instructions to ensure AI agents generate accurate, secure, and context-aware SQL/DAX queries.
• Guardrails & Governance: Integrate Azure AI Content Safety and Microsoft Purview policies to enforce read-only data access, security boundaries, and prevent hallucinated or unauthorized outputs.

2. Microsoft Fabric & Semantic Modelling

• AI-Ready Architecture: Clean and structure data in Fabric OneLake to be "AI-ready". Optimize tables, columns, and relationship naming conventions so LLMs can interpret schemas accurately.
• Semantic Model Design: Develop highly optimized Power BI Semantic Models with Direct Lake connectivity to provide the single source of truth for both human-facing dashboards and AI agents.
• Data Orchestration: Build and troubleshoot pipelines using Dataflows Gen2 and Data Factory inside Fabric to ingest diverse enterprise data.

3. BI & Dashboards

• Interactive Visualizations: Design and build executive-level Power BI dashboards with intuitive UX, focusing on actionable insights.
• Hybrid Delivery: Ensure that users can transition seamlessly between structured reports (Power BI) and conversational analytics (Fabric Data Agents).
• Advanced Analytics: Implement complex DAX measures, calculations, and analytical patterns to support diagnostic and predictive business questions.

Required Skills & Experience

Technical Stack

• Platform: 2+ years of hands-on experience with Microsoft Fabric (OneLake, Lakehouse, Warehouses, and Real-Time Intelligence).
• BI & Analytics: Strong proficiency in Power BI, advanced DAX, and semantic data modelling.
• AI & Prompt Engineering: Solid understanding of Large Language Models (LLMs), prompt engineering techniques , and RAG-based architectures.
• Data Languages: Strong SQL and Python skills for data preparation and pipeline scripting.