Guidewire Data Engineer

ShoreWise Consulting; Canada; On-site; CAD 80,000 - 100,000; Full time

Job summary

ShoreWise Consulting is looking for a skilled data engineer to design and develop schemas and data models on the Snowflake platform. This role requires advanced SQL skills and familiarity with ETL/ELT processes using tools like Apache Nifi and Talend.

The ideal candidate will also have hands-on experience with Guidewire Claims Center. Candidates must be able to build cloud-based data warehouses for efficient analytics.

Qualifications

• Strong experience in developing schemas and data models within the Snowflake platform.
• Proficient in writing and optimizing SQL queries.
• Hands-on experience with Guidewire Claims Center.

Responsibilities

• Design and develop schemas and data models within the Snowflake platform.
• Utilize ETL/ELT tools to design and execute data transformation processes.
• Build and optimize cloud-based data warehouses.

Skills

SQL

ETL/ELT tools

Guidewire Claims Center

Cloud platforms (AWS, Azure, GCP)

Tools

Apache Nifi

Talend

dbt

Job description

• Design and develop schemas and data models within the Snowflake platform.
• Write and optimize complex SQL queries for data extraction and transformation.
• 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.
• Leverage cloud platforms (AWS, Azure, GCP) to enable system connectivity and data synchronization.

All your information will be kept confidential according to EEO guidelines.