Role: Senior BI Architect
Location: Gurgaon/Pune
Overview
We are seeking a Business Intelligence Architect with 10+ years of experience to design and lead enterprise BI and analytics solutions. The ideal candidate brings deep expertise in Power BI, Tableau, modern data platforms, and insurance domain knowledge, along with strong capabilities in data governance and BI strategy.
---
Key Responsibilities
· Lead enterprise BI architecture, dashboards, and visualization frameworks using Power BI and Tableau.
· Define and drive BI strategy, partnering with stakeholders to translate insurance data (policy, claims, underwriting, premiums, loss ratios) into actionable insights.
· Design and optimize data models, ETL/ELT pipelines, and semantic layers for scalable analytics.
· Work with Snowflake, Microsoft Fabric (Lakehouse/Warehouse), and modern cloud platforms.
· Develop advanced DAX, Power Query (M), SQL, and Python-based data solutions.
· Implement and enforce data governance, data quality, security, and metadata management standards.
· Enable self-service BI and automate workflows using Power Automate.
· Establish CI/CD pipelines, deployment standards, and ensure performance optimization.
· Collaborate with data engineering teams and troubleshoot BI performance and data issues.
· Mentor BI developers, conduct code reviews, and promote best practices.
---
Required Qualifications
· Bachelor’s degree in Computer Science, Data Analytics, or related field.
· 10+ years of BI/analytics experience with strong expertise in:
o Power BI (DAX, Power Query, semantic models)
o Tableau
o SQL and data modeling
· Experience with Snowflake, Microsoft Fabric, and ETL/ELT processes.
· Proficiency in Python for data processing/automation.
· Strong understanding of data governance and enterprise BI architecture.
· Insurance domain experience is required.
---
Preferred Skills
· Experience with Azure/cloud platforms
· Knowledge of CI/CD and DevOps in BI
· Strong stakeholder management and leadership skills
ResponsibilitiesKey Responsibilities
· Lead enterprise BI architecture, dashboards, and visualization frameworks using Power BI and Tableau.
· Define and drive BI strategy, partnering with stakeholders to translate insurance data (policy, claims, underwriting, premiums, loss ratios) into actionable insights.
· Design and optimize data models, ETL/ELT pipelines, and semantic layers for scalable analytics.
· Work with Snowflake, Microsoft Fabric (Lakehouse/Warehouse), and modern cloud platforms.
· Develop advanced DAX, Power Query (M), SQL, and Python-based data solutions.
· Implement and enforce data governance, data quality, security, and metadata management standards.
· Enable self-service BI and automate workflows using Power Automate.
· Establish CI/CD pipelines, deployment standards, and ensure performance optimization.
· Collaborate with data engineering teams and troubleshoot BI performance and data issues.
· Mentor BI developers, conduct code reviews, and promote best practices.
QualificationsRequired Qualifications
· Bachelor’s degree in Computer Science, Data Analytics, or related field.
· 10+ years of BI/analytics experience with strong expertise in:
o Power BI (DAX, Power Query, semantic models)
o Tableau
o SQL and data modeling
· Experience with Snowflake, Microsoft Fabric, and ETL/ELT processes.
· Proficiency in Python for data processing/automation.
· Strong understanding of data governance and enterprise BI architecture.
· Insurance domain experience is required.
---
Preferred Skills
· Experience with Azure/cloud platforms
· Knowledge of CI/CD and DevOps in BI
· Strong stakeholder management and leadership skills
Skills Required
- Bachelor's degree in Computer Science, Data Analytics, or a related field
- 10+ years of BI or analytics experience
- Strong expertise in Power BI, including DAX, Power Query, and semantic models
- Strong expertise in Tableau
- Strong expertise in SQL and data modeling
- Experience with Snowflake, Microsoft Fabric, and ETL/ELT processes
- Proficiency in Python for data processing and automation
- Strong understanding of data governance and enterprise BI architecture
- Insurance domain experience
- Experience with Azure or cloud platforms
- Knowledge of CI/CD and DevOps in BI
- Strong stakeholder management and leadership skills
EXL Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about EXL and has not been reviewed or approved by EXL.
-
Healthcare Strength — Medical plan options include HSA, HRA, and PPO choices, with additional health-related programs such as disability coverage and an employee assistance program. Feedback suggests these options provide meaningful flexibility and coverage breadth for many roles.
-
Leave & Time Off Breadth — Up to 20 days of paid time off, plus federal holidays and paid sick and safe time, are highlighted. Feedback suggests this leave structure is a notable benefit alongside core compensation.
-
Retirement Support — A traditional and Roth 401(k) with up to a 3% company match and full vesting after one year is described. Feedback suggests this match and vesting timeline help bolster long-term savings.
EXL Insights
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
.png)
.png){kind=logo}
