This is a remote position.
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.
Requirements
Experience (must meet all minimums)
• 12-15 years total in Data & Analytics.
• 8+ years in data modeling/information architecture/data design.
• 7–10 years in the insurance domain (mandatory).
• 5+ years working with or supporting specialty lines (preferred).
• 5–7 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; 3NF, dimensional/star/snowflake, data vault, temporal/versioned data design.
• Strong SQL and proficiency with modeling/metadata tools (e.g., erwin, ER/Studio, PowerDesigner, dbt for analytics engineering).
• 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.
Benefits
Diversity Inclusion:
At Exavalu, we are committed to building a diverse and inclusive workforce. We welcome applications for employment from all qualified candidates, regardless of race, color, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. We nurture a culture that embraces all individuals and promotes diverse perspectives, where you can make an impact and grow your career. Exavalu also promotes flexibility depending on the needs of employees, customers and the business. It might be part-time work, working outside normal 9-5 business hours or working remotely.. We also have a welcome back program to help people get back to mainstream after a long break due to health or family reasons.
