Data Modeler & Data Engineer (Guidewire)

About this role

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Data Modeler & Data Engineer (Guidewire) based in United States.
This is an outstanding opportunity for a senior data professional to design and optimize enterprise-scale cloud data platforms supporting the Property & Casualty insurance industry. In this role, you will combine data architecture, engineering, and modeling expertise to build scalable Snowflake solutions that power analytics and business intelligence. You'll collaborate with cross-functional teams to modernize data ecosystems, improve performance, and ensure high standards for governance and security. Working in a fully remote environment, you will play a key role in transforming complex insurance data into reliable, business-ready assets. This position is ideal for someone who thrives at the intersection of cloud technologies, data engineering, and enterprise architecture.


Accountabilities

• Design and develop conceptual, logical, and physical enterprise data models that support reporting, analytics, and operational business processes.
• Build and optimize Snowflake data architectures, implementing scalable schemas, clustering strategies, materialized views, and performance tuning initiatives.
• Translate complex business requirements into efficient data models using dimensional modeling techniques, including Star and Snowflake schemas.
• Collaborate with data engineering teams to design and implement robust ELT/ETL pipelines and modern data lakehouse architectures using Medallion principles.
• Model and integrate Guidewire data across PolicyCenter, ClaimCenter, BillingCenter, underwriting, policy administration, claims, billing, and customer domains.
• Design cloud-native data ingestion frameworks leveraging AWS services while ensuring seamless integration across enterprise data platforms.
• Establish and maintain enterprise data governance standards, incl...