Job Description
Solution Architect – Data Migration & Analytics (Insurance)
Locations (Pune/Bangalore/Hyderabad/Chennai/Kolkata
Role Summary
We are hiring a Solution Architect to lead a strategic data modernization program involving migration from 14+ source systems (including Guidewire InsuranceNow) into a Snowflake-based Data Warehouse leveraging dbt . The role also includes driving a report rationalization initiative , consolidating legacy reports into a streamlined Power BI analytics layer .
This is a high-impact role requiring robust expertise in data architecture, large-scale migration, and insurance domain transformation .
Key Responsibilities
Architecture & Design
- Define end-to-end data architecture for ingesting structured and unstructured data into Snowflake .
- Architect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks .
- Establish scalable, secure, and performance-optimized data models.

Data Migration Leadership
- Design migration strategy for 14+ systems including InsuranceNow .
- Define data mapping, transformation logic,



and reconciliation frameworks .
- Implement data quality controls, auditability, and parallel validation mechanisms .

Analytics & Reporting Modernization
- Lead report rationalization and consolidation initiative.
- Design Power BI semantic layer and standardize KPIs.
- Eliminate redundant reports and enable unified, business-friendly dashboards.

Governance & Quality
- Establish data governance, lineage, and metadata standards .
- Ensure compliance with insurance regulatory and audit requirements .
- Define quality KPIs and monitoring frameworks .

Stakeholder Leadership
- Act as technical SME and advisor for business, data, and leadership teams.
- Drive architecture governance, design reviews, and delivery alignment .
- Identify and mitigate risks in a complex multi-source migration program.

Required Experience
- 10+ years in data engineering / data architecture , with enterprise-scale

📌 Solution Architect – Data Migration (Bengaluru)
🏢 Diverse Lynx India Private
📍 Bengaluru