Principal BI Architect – Agentic BI

Job description

We are seeking a hands-on Manager – BI & Analytics to lead the design, development, and delivery of enterprise-scale BI and analytics solutions. The ideal candidate will have deep expertise in Power BI, Tableau, SQL, MS Fabric,, Snowflake, and Databricks , combined with a strong understanding of modern GenAI, LLM, and Agentic BI capabilities. This is a hands-on Manager role . The Manager will not only lead teams and client engagements but will also remain deeply involved in solution architecture, data modeling, BI development, performance optimization, technical problem-solving, and emerging Agentic BI initiatives. The role requires someone who can bridge business requirements, BI engineering, modern data platforms, and AI-driven analytics to deliver measurable business impact. Key Responsibilities: . BI Leadership: Lead the design and development of enterprise BI solutions while remaining hands-on with complex dashboards, reports, semantic models etc. Personally troubleshoot complex BI performance, data modeling, refresh, and scalability issues. Establish reusable BI frameworks, development standards, visualization best practices, and governance practices, while reviewing solutions developed by BI engineers and analysts and providing technical direction. 2. Data Modeling, SQL & Modern Data Platforms: Design scalable analytical data models and reporting architectures across Snowflake, Databricks, Azure SQL, and other enterprise data platforms. Write and optimize complex SQL for data extraction, transformation, analysis, and BI consumption. Work hands-on with Snowflake for data warehousing, analytical workloads, performance optimization, and BI integration, as well as Databricks/Lakehouse, Spark, and PySpark to develop and consume scalable analytical datasets. Collaborate with Data Engineering teams to improve ETL/ELT pipelines, data quality, data lineage, and source-to-report consistency. 3. GenAI & LLM-Powered Analytics: Lead and contribute hands-on to GenAI and LLM-powered BI initiatives, including natural-language analytics, automated insight generation, narrative reporting, and conversational BI. Identify opportunities to leverage LLMs and Python-based AI automation to improve analytics processes and reduce manual reporting effort. Partner with Data Science and AI Engineering teams to integrate LLM capabilities with enterprise data, semantic models, and BI applications, while evaluating emerging GenAI technologies and determining where they can deliver meaningful business value. 4. Agentic BI: Drive the development of Agentic BI solutions that can interpret business questions, interact with semantic models and enterprise data sources, perform multi-step analysis, and generate actionable recommendations. Design use cases where AI agents can interact with Power BI semantic models, Snowflake, Databricks, SQL databases, APIs, and business applications. Explore agent-driven capabilities such as automated root-cause analysis, anomaly investigation, predictive insights, and next-best-action recommendations, while establishing appropriate validation, evaluation, security, governance, and human-in-the-loop controls for AI-generated business insights. 5. End-to-End Solution Ownership: Own BI and analytics initiatives from business requirement discovery through solution design, development, testing, deployment, and adoption. Translate complex business problems into scalable analytical and AI-driven solutions by defining KPIs, metrics, data requirements, analytical approaches, and solution architecture. Ensure solutions are designed for performance, scalability, maintainability, security, and business usability throughout the delivery lifecycle. 6. Client & Stakeholder Leadership: Act as a senior technical and business-facing leader for BI and analytics engagements, working directly with business and client stakeholders to understand strategic objectives and translate them into data and analytics solutions. Present complex analytical findings, recommendations, and AI-driven insights to senior leadership in a clear and compelling manner. Build strong relationships with business stakeholders and establish credibility as a trusted analytics advisor. 7. Technical Team Leadership & Mentoring: Lead, mentor, and develop BI and Analytics engineers and consultants while providing hands-on technical guidance across Power BI, Tableau, SQL, data modeling, Snowflake, Databricks, and modern BI architecture. Conduct technical reviews, establish engineering standards and best practices across projects, and identify technical capability gaps. Develop team capabilities in modern BI, GenAI, and Agentic BI while balancing hands-on technical delivery with people leadership and project responsibilities. 8. Innovation & Continuous Improvement: Stay current with developments in Power BI, Tableau, Microsoft Fabric, Snowflake, Databricks, LLMs, GenAI, Agentic AI, and modern BI architectures. Identify opportunities to automate repetitive analytics and reporting processes, develop prototypes and proofs of concept, and convert successful AI and BI innovations into production-grade enterprise solutions. Evaluate new tools and technologies based on business value, scalability, security, and cost. 10–15+ years of experience in BI, Analytics, Data, or related technology roles, with significant hands-on experience in enterprise BI delivery. Deep hands-on expertise in Advanced PowerBI, Tableau, SQL, semantic modeling, and dashboard development . Strong experience designing and implementing BI solutions using MS Fabric, Snowflake and Databricks . Strong understanding of data warehousing, dimensional modeling, ETL/ELT, data pipelines, and modern cloud data architectures . Hands-on experience with Databricks, Spark/PySpark , or equivalent data engineering technologies. Experience using Python for analytics, automation, or AI/GenAI use cases. Practical experience with LLMs, Generative AI, conversational analytics, or AI-powered BI . Understanding of Agentic BI , AI agents, tool integration, semantic models, and AI-driven decision support. Strong understanding of BI performance optimization, scalability, governance, security, and data quality. Excellent business communication, executive presentation, storytelling, and stakeholder management skills. Demonstrated ability to lead technical teams while remaining hands-on in architecture, development, troubleshooting, and solution delivery . Experience managing multiple projects, priorities, and stakeholder expectations in a consulting or enterprise environment. Preferred / Nice to Have: Experience integrating LLMs with Power BI, Tableau, Snowflake, Databricks, or enterprise APIs . Exposure to RAG, embeddings, vector databases, semantic search, or conversational BI . Exposure to Agentic AI, MCP, agent orchestration frameworks, or AI-powered workflows . Experience with Tableau, Qlik Sense, or other BI platforms. Experience working with Power Automate, SharePoint, Excel, and embedded analytics . Experience building enterprise analytics solutions with measurable business impact. Thrive & Grow with Us : Competitive Salary: Your skills and contributions are highly valued here, and we make sure your salary reflects that, rewarding you fairly for the knowledge and experience you bring to the table. Dynamic Career Growth: Our vibrant environment offers you the opportunity to grow rapidly, providing the right tools, mentorship, and experiences to fast-track your career. Idea Tanks : Innovation lives here. Our "Idea Tanks" are your playground to pitch, experiment, and collaborate on ideas that can shape the future. Growth Chats : Dive into our casual "Growth Chats" where you can learn from the best—whether it's over lunch or during a laid-back session with peers, it's the perfect space to grow your skills. Snack Zone: Stay fuelled and inspired! In our Snack Zone, you'll find a variety of snacks to keep your energy high and ideas flowing. Recognition & Rewards : We believe great work deserves to be recognized. Expect regular Hive-Fives, shoutouts and the chance to see your ideas come to life as part of our reward program. Fuel Your Growth Journey with Certifications: We’re all about your growth groove! Level up your skills with our support as we cover the cost of your certifications . Blend is a premier AI services provider, committed to co-creating meaningful impact for its clients through the power of data science, AI, technology, and people. With a mission to fuel bold visions, Blend tackles significant challenges by seamlessly aligning human expertise with artificial intelligence. The company is dedicated to unlocking value and fostering innovation for its clients by harnessing world-class people and data-driven strategy. We believe that the power of people and AI can have a meaningful impact on your world, creating more fulfilling work and projects for our people and clients. For more information, visit .