Data Modeling

Req ID: 358240 Solstice Analytics strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Modeling to join our team in Anywhere, Karnātaka (IN-KA), India (IN). Role Summary We seek an accomplished Manager – Data Modeling to lead enterprise‑grade data modeling and information architecture for our insurance portfolio, with preference for specialty lines experience. You will define conceptual, logical, and physical models; standardize data across core domains; partner with underwriting, claims, actuarial, finance, and engineering; and enable analytics/AI use cases that drive measurable business value. Key Responsibilities 1) Strategy & Architecture Own the data modeling strategy across the insurance value chain (underwriting, rating, policy admin, claims, billing, reinsurance, finance, distribution). Define and maintain enterprise conceptual, logical, and physical models and canonical structures ; align to business and digital roadmaps. Shape target‑state DWH/lakehouse/semantic architectures and integration patterns with core platforms and data products. 2) Data Modeling & Design Design robust models for specialty products (e.g., E&O, D&O, Cyber, Marine, Aviation, Umbrella), including risk/exposure, coverage, limits, locations, modifiers . Deliver models for rating engines, pricing analytics, and actuarial studies ; implement 3NF, dimensional/star‑schema, data vault , and wide‑table patterns as appropriate. Create semantic layers and curated data products that accelerate BI and data science. 3) Governance, Quality & Standards Establish standards, naming conventions, conformed dimensions , and model versioning/release practices. Partner with Data Governance on glossary, metadata, lineage, access controls , and data quality rules/scorecards ; chair or co‑chair the Design Authority for models. 4) Delivery & Change Leadership Lead modeling for migrations and platform modernizations , including data harmonization across legacy and target cores. Guide engineering teams implementing models on cloud platforms (Azure/AWS/GCP) and modern lakehouse stacks; ensure performance, partitioning, and cost efficiency. Enable UAT/SIT for data products, manage risks (DQ, integration complexity, technical debt), and ensure on‑time, on‑budget delivery. 5) Stakeholder & People Leadership Engage senior stakeholders (underwriting, claims, actuarial, finance, technology) to prioritize use‑cases and value outcomes. Lead and mentor a team of data modelers/analysts (5–10+) ; build accelerators/playbooks and capability uplift. Communicate complex topics clearly to executive and non‑technical audiences; manage vendors/SIs where required. Required Experience & Skills Experience (must meet all minimums) 8+ years total in Data & Analytics. 5+ years in data modeling/information architecture/data design . 5+ years in the insurance domain . 5+ years working with or supporting specialty lines (preferred). 4+ years in leadership/people management , owning modeling workstreams and mentoring teams. 3+ years working with insurance core systems (e.g., Guidewire, Duck Creek, Majesco/Insurity, or equivalent). Technical Skills Expert in conceptual, logical, physical modeling; dimensional/star/snowflake , data vault , temporal/versioned data design. Strong SQL and proficiency Implementation experience on Azure/AWS/GCP and lakehouse paradigms (e.g., Delta/Iceberg); performance tuning, partitioning, indexing. Working knowledge of ETL/ELT (ADF, Glue, Talend, Fivetran, Airflow), semantic layers/BI (Power BI/Tableau/Looker), and MDM concepts. Domain Skills Deep understanding of policy lifecycle , coverages/endorsements , exposures/locations , claims & reserves , reinsurance (treaty/fac) , broker/bordereaux/distribution , and financial data flows . Ability to translate underwriting, actuarial, and claims requirements into scalable data designs and analytics‑ready structures. Proven experience in data standards, glossary, lineage and DQ rulebooks . Leadership & Consulting Skills Executive presence; structured storytelling and documentation. Stakeholder management across business and technology; design authority facilitation. Team development, workload planning, and delivery governance in Agile/hybrid models. Preferred Qualifications Specialty lines depth (e.g., Cyber, Marine, Energy, Financial Lines, E&S). Cloud certifications (Azure/AWS/GCP); experience with governance platforms (Collibra, Alation, Atlan, Purview). Experience with rating engines and underwriting workbenches . About Solstice Analytics Solstice Analytics is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the world's leading AI and digital infrastructure providers, with unmatched capabilities in