AI Analyst, BI

Job Summary We are looking for an experienced AI & BI Automation Technical Lead to design, enhance and scale AI-powered Business Intelligence automation solutions. The role combines hands-on Microsoft Power Platform, Python, Azure and Generative AI engineering with technical ownership of BI automation, automated quality validation and report delivery capabilities. The individual will convert business and operational requirements into scalable, reliable and reusable technology solutions. The successful candidate will work closely with global BI hubs, Technology teams, architects and business stakeholders to automate BI processes, improve report quality, reduce manual effort and increase delivery efficiency. This role requires a strong balance of technical depth, BI domain understanding, solution ownership and stakeholder engagement. Key Responsibilities 1. AI and BI Automation Solution Ownership Own the technical design, enhancement and ongoing evolution of AI-enabled BI automation capabilities. Develop scalable solutions for report onboarding, scheduling, refresh, monitoring, quality validation and delivery. Convert manual BI processes into reusable and configurable automation workflows. Define and maintain the technical roadmap with BI, Technology and business stakeholders. Evaluate AI and automation opportunities based on business value, feasibility, scalability and adoption potential. Ensure solutions can support multiple regions, clients, report types and BI hubs. 2. Python and Application Engineering Design and develop scalable, cloud-native applications using Python. Build and maintain APIs, backend services and business-rule engines. Develop reliable solutions using object-oriented programming, reusable components and established design patterns. Perform automated data validation, missing-value detection, duplicate analysis, anomaly detection and variance analysis using Pandas, Polars or equivalent frameworks. Develop integrations across BI reporting, automation, quality-control and delivery platforms. Integrate Power Platform applications with Azure services, SQL Server, REST APIs, SharePoint, Microsoft Teams, Power BI and other enterprise systems. Optimize applications for performance, reliability, maintainability and scalability. 3. Generative AI and Intelligent Automation Develop and integrate enterprise Generative AI solutions using services such as Azure OpenAI, Llama, LangChain and vector search. Build AI-enabled solutions using Azure AI Foundry, Azure AI Search, Microsoft Copilot Studio, AI Builder, custom prompts, agent flows and generative actions. Apply Retrieval-Augmented Generation, prompt engineering and structured AI workflows to BI use cases. Use AI to generate executive summaries, business insights, recommendations and exception explanations. Design controls to validate AI-generated output before it is used in business processes. Evaluate Small Language Models for cost-efficient or low-latency deployments. Explore AI agents and intelligent workflows for report creation, quality validation, monitoring and operational support. Apply deterministic validation wherever accuracy, traceability and repeatability are required. 4. BI Process and Quality Automation Understand the complete BI report lifecycle, including requirement intake, report creation, refresh, validation, approval and delivery. Automate repeatable activities across Excel-based reporting and other BI platforms. Develop configurable quality rules for data checks, business validation and change detection. Support report-level and worksheet-level checks such as blanks, duplicates, formula continuity, reporting periods, product or market changes and variance thresholds. Design monitoring and exception-management capabilities that enable users to identify and resolve failures quickly. Partner with BI subject-matter experts to convert business validation requirements into scalable technical rules. Establish measurable quality controls and audit trail