I'm Malhar Pawar — Analytics Architect with deep roots in data engineering, semantic modelling, and AI-powered analytics. I build the infrastructure that makes data useful.
About Me
Data Engineer. BI Architect. AI Explorer.
Based in Pune, India, I work at the intersection of data engineering, business intelligence, and artificial intelligence. With hands-on experience building enterprise analytics platforms for the QSR and finance industries, I specialize in transforming complex data ecosystems into actionable intelligence.
My current focus is on integrating Large Language Models with BI platforms through Model Context Protocol (MCP) servers — building AI copilots that let business users query data using natural language. I hold the Microsoft Fabric Analytics Engineer Associate and Microsoft Fabric Data Engineer Associate certifications.
I believe the future of analytics is conversational, automated, and deeply integrated with AI. Every project I build moves toward that vision.
Tech Stack
My Technical Arsenal
Tools and technologies I use daily to build data platforms and intelligence systems.
Featured Work
Projects That Moved The Needle
Enterprise analytics platforms, data pipelines, and BI solutions delivering measurable impact.
AI & Innovation
Experimenting at the Edge of AI + Data
Building agentic AI systems, LLM-powered analytics tools, and intelligent data platforms.
AI-Powered BI Copilot
LLM integration with Power BI semantic models via MCP servers for natural language data querying.
Autonomous Analytics Agent
Agentic AI system that monitors data quality, detects anomalies, and auto-generates executive summaries.
LLM Data Query Engine
Natural language to SQL/DAX translator powered by Claude that understands business context and metadata.
AI Data Quality Monitor
AI-driven data reconciliation and validation that learns patterns and flags pipeline anomalies.
Activity Feed
What I've Been Building
A timeline of recent technical explorations and experiments.
Blog & Insights
Writing About What I Build
Let's Build Something Together
Looking for a data engineer who thinks in systems, builds with purpose, and experiments with AI? Let's talk.