Data Modeler & Data Engineer (Guidewire)

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 Canada.

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.

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 Canada.

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, including data quality, metadata management, lineage, security, compliance, and role-based access controls.
• Partner with business stakeholders and technical teams to deliver scalable, secure, and high-performing data solutions that support strategic insurance initiatives.

Requirements

• 8+ years of experience in Data Architecture, Data Modeling, or Data Engineering within enterprise environments.
• Strong expertise in conceptual, logical, physical, and dimensional data modeling, including Star Schema and Snowflake Schema design.
• Extensive hands-on experience with Snowflake architecture, data modeling, query optimization, and performance tuning.
• Advanced SQL development skills and strong programming experience with Python and PySpark.
• Proven experience designing and supporting ELT/ETL pipelines and modern cloud-based data platforms.
• Hands-on experience with AWS technologies, including S3, Glue, and Lambda.
• Solid understanding of Medallion Architecture and modern data lakehouse concepts.
• Deep knowledge of Guidewire data models, including PolicyCenter, ClaimCenter, and BillingCenter.
• Strong Property & Casualty (P&C) insurance domain expertise, including policy administration, underwriting, claims management, and billing processes.
• Excellent analytical, communication, collaboration, and problem-solving skills, with the ability to translate business requirements into scalable technical solutions.

Benefits

• Permanent remote working model.
• Flexible work arrangements based on employee and business needs.
• Opportunity to work on large-scale cloud data transformation initiatives.
• Exposure to cutting-edge technologies including Snowflake, AWS, and Guidewire platforms.
• Collaborative and inclusive work environment.
• Welcome Back Program supporting professionals returning after extended health or family leave.
• Career growth opportunities within a rapidly expanding organization.
• Diverse and inclusive culture that values innovation, collaboration, and professional development.

How Jobgether works: We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best!  Why Apply Through Jobgether?    Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.     #LI-CL1