Principal BI Architect – Agentic BI
Job Summary
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.
Qualifications :
- 1015 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.
Additional Information :
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 bestwhether its over lunch or during a laid-back session with peers its the perfect space to grow your skills.
- Snack Zone: Stay fuelled and inspired! In our Snack Zone youll 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: Were all about your growth groove! Level up your skills with our support as we cover the cost of your certifications.
Remote Work :
No
Employment Type :
Full-time
About Company
Blend360 is an award-winning provider of data, analytics, and talent solutions for Fortune 500 companies. The company has made the Inc. 5000 list of Fastest Growing Companies every year they have been in business and has been awarded a world-class ranking in client satisfaction for th ... View more