The Guidewire Data Engineer will design schemas in Snowflake, develop ETL processes, optimize SQL queries, and integrate Guidewire with data platforms.
Company Description
Describe what makes your company great
Job DescriptionKey Responsibilities:
Snowflake Expertise:
- Design and develop schemas and data models within the Snowflake platform.
- Write and optimize complex SQL queries for data extraction and transformation.
Guidewire Claims Center:
- Apply hands-on experience with Guidewire Claims Center to support claims management workflows.
- Integrate Guidewire with data platforms to enable seamless data exchange.
ETL/ELT Processes:
- Utilize ETL/ELT tools (e.g., Apache Nifi, Talend, dbt) to design and execute efficient data transformation and loading processes.
Data Warehousing:
- Build and optimize cloud-based data warehouses for scalable storage and analytics.
SQL and Data Querying:
- Write advanced SQL queries for data aggregation, reporting, and analysis.
Cloud & Data Integration:
- Leverage cloud platforms (AWS, Azure, GCP) to enable system connectivity and data synchronization.
All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Artificial Intelligence • Software
Lead full-cycle strategic sales in Canada for Fieldguide, building relationships with major audit and advisory firms. Drive net-new revenue, orchestrate multi-regional account strategy, manage complex technical sales cycles, deliver executive presentations, coordinate cross-functional stakeholders, develop international playbooks, and represent the company at industry events. Expected travel up to 30%.
Gaming
Lead development of core client systems and engine-level infrastructure in Unity/C#. Diagnose and fix cross-cutting performance issues, upgrade third-party SDKs, evolve build tooling, produce design docs, scope multi-week infrastructure initiatives, mentor engineers, and drive profiling, optimization, and architecture changes to enable future features.
Top Skills:
AndroidAWSC#DatadogGitiOSKubernetesUnity
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own and optimize Okta identity infrastructure and Google Workspace, build Workato automations (OWL-IT), support IAM initiatives (RBAC, provisioning, SCIM), act as Tier 3 escalation for identity incidents, ensure StateRAMP/FedRAMP compliance, document runbooks, and collaborate with Security/GRC to strengthen identity security.
Top Skills:
ConfluenceGemini EnterpriseGoogle Apps Manager (Gam)Google Cloud Platform (Gcp)Google WorkspaceIgaOktaOkta WorkflowsOwl-ItPamPythonRbacRest ApisSaviyntScimSplunkSsoTerraformVertex AiWorkatoWorkato Connector SdkWorkato One
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
