

Search by job, company or skills

Data Architect – Insurance (Life & General Insurance)
Location: Mumbai / Pune
Work Mode: Hybrid
Experience: 10–18 years
Employment Type: Full-Time
About
the Role
We are seeking an
experienced and hands-on Data Architect with deep expertise in Insurance data
models across both Life Insurance and General Insurance domains. The ideal
candidate will have extensive experience designing enterprise data
architectures, insurance canonical data models, integration architectures, and
analytical data platforms.
This role requires strong technical capabilities
combined with domain expertise to define, govern, and implement scalable
insurance data solutions across policy administration, underwriting, claims,
billing, customer, and distribution systems.
Key Responsibilities
Data
Architecture & Design
· Define and
maintain enterprise data architecture and target-state data models for
insurance platforms.
· Design and
implement data architectures that support Artificial Intelligence, Machine
Learning, and Generative AI use cases.
· Design
conceptual, logical, and physical data models for Life and General Insurance
businesses.
· Develop and
maintain canonical insurance data models across applications and business
domains.
· Design
semantic data models and knowledge structures to improve discoverability and AI
usability of enterprise data.
· Define
strategies for preparing insurance data assets for AI-driven analytics and
intelligent automation.
Insurance
Domain Architecture
· Design data
models covering all key functional areas in Insurance from Policy to
Reinsurance
· Understand
insurance concepts including:
o Policy lifecycle
o Coverage and benefits
o Premium and billing structures
o Claims lifecycle
o Risk and underwriting data
o Regulatory reporting requirements
Data Integration & Modern Data
Platforms
· Design data
integration patterns across core insurance systems, digital platforms, APIs,
and external partners.
· Define
enterprise canonical models and API data contracts.
· Architect data
solutions for cloud data platforms and analytical ecosystems.
· Support
real-time, event-driven, and batch data integration architectures.
· Collaborate
with application, integration, and enterprise architects.
Retrieval and Knowledge
Architectures
· Experience
designing data architectures that support:
o Retrieval-Augmented Generation (RAG)
o Vector databases and embeddings
o Metadata-driven information retrieval
· Understanding
of approaches for combining structured insurance data with documents,
correspondence, policy wordings, claims documents, and underwriting content.
Agentic AI and
Intelligent Systems
· Familiarity
with Agentic AI concepts and AI agents that can consume enterprise APIs and
data services.
· Understanding
of how insurance data models and APIs can enable autonomous or semi-autonomous
business agents.
· Awareness of
Model Context Protocol (MCP), tool-based AI integrations, and AI orchestration
concepts is desirable.
Data
Governance & Quality
· Establish data
governance frameworks and data quality standards.
· Define data
lineage, ownership, stewardship, and metadata management practices.
· Support
regulatory compliance and audit requirements.
· Drive data
quality initiatives across business and technology teams.
Stakeholder Engagement
· Work closely
with business teams, architects, delivery teams, and external partners.
· Conduct data
model reviews and architecture governance sessions.
· Mentor
development and data engineering teams on best practices.
· Support
pre-sales, solutioning, and transformation initiatives where required.
Required
Experience
· 10+ years of
experience in Data Architecture, Data Modeling, or Enterprise Data Management.
· Minimum 5
years of experience in the Insurance industry.
· Strong
knowledge of both Life Insurance and General Insurance business domains.
· Hands-on
experience creating conceptual, logical, and physical data models.
· Experience
designing canonical data models and enterprise data architectures.
· Strong SQL and
database design skills.
· Experience
with relational and analytical databases.
Preferred Technical Skills
· Data Modeling
Tools (Erwin,ER/Studio/Sparx EA/PowerDesigner)
· Databases (
Oracle/SQL Server/PostgreSQL/Snowflake)
· Cloud
Platforms (AWS/Azure/GCP)
· Data
Technologies:
o Data Warehousing
o Data Lakes
o ETL/ELT tools
o API-based integrations
o Event-driven architectures
· Standards and
Frameworks:
o Data Governance
o Master Data Management
o Metadata Management
o Data Quality Frameworks
· Understanding
of Large Language Models (LLMs) and Generative AI concepts.
· Familiarity
with semantic search and embeddings.
· Knowledge of
knowledge graphs and semantic models
Preferred Industry Exposure
Experience working with
one or more of the following:
· Core Insurance
Platforms
· Insurance
Integration Platforms
· Regulatory and
Reporting Systems
Educational Qualifications
· Bachelor's
degree in Engineering, Computer Science, Information Technology, or related
field.
· Master's
degree is preferred.
· Relevant
certifications in Data Architecture, Cloud Platforms, or Data Management are
advantageous.
Personal Attributes
· Strong
analytical and problem-solving skills.
· Excellent
communication and stakeholder management abilities.
· Ability to
work across business and technology teams.
· Hands-on
approach with willingness to work on detailed data models and solution design.
· Ability to
lead architecture discussions and mentor teams.
iQuest Consultants, established in 2000, is one of West India's leading recruitment firms specializing in IT, Telecom, Manufacturing, Engineering, and BFSI hiring. The company serves leading organizations including Deloitte, IBM, KPMG, EY, Goldman Sachs, Tech Mahindra, Samsung, Mercedes-Benz, L&T, Hindalco, and many others. It also supports overseas recruitment for reputed Gulf-based companies. With specialized teams handling different industry verticals and an Executive Search division focused on VP, Director, and CXO-level hiring, iQuest operates through 9 offices across 6 Indian cities with over 150 recruitment consultants, delivering recruitment solutions across India and international markets.
Job ID: 151630177
Skills:
Azure Sql, Databricks, Sql, Azure Data Factory, Data Warehousing, Devops, Pyspark, Kafka, Power Bi, Python, Scala, Azure Event Hub, Microsoft Fabric, Data Lake architecture, Azure Data Lake Storage Gen2, Delta Lake, Azure Data Services, Synapse Analytics, CI CD pipelines, AI ML pipelines, Generative AI models
Skills:
Pyspark, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Python, Profisee Unity Catalog, Microsoft Purview, Delta Lake, Azure Blob Storage, Azure SQL Database
Skills:
snowflake , Data Security, Bi Tools, Data Warehousing, Jira, Sql, ELT, Agile, Data Governance, Etl, Airflow, cloud platforms, analytics architecture, dbt, Data Vault 2.0
Skills:
virtualization, Data Quality, Olap, Sql, Python, Computer Science, Information Management, metadata, Microstrategy, Analytics
Skills:
data engineering , Gcp, Data Architect, Etl, BigQuery