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
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Senior Total Rewards partner advising on org design, pay-for-performance, equity, and executive compensation. Lead annual merit, equity, and promotion budgeting and execution, build dashboards and automation, prepare Compensation Committee/Board materials, and collaborate with HR, Finance, Legal, and Talent Acquisition to drive compensation strategy across the company.
Top Skills:
Compensation Planning SoftwareWorkday
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead design and operation of Block's real-time, event-driven data systems. Build and run high-throughput streaming pipelines, turn Kafka event streams into low-latency data products, improve reliability and observability, mentor engineers, and define platform architecture and standards for projections, third-party data proxy, and graph data capabilities.
Top Skills:
AWSBlock-ForgeCloudeventsDatabricksDatahubDbtFlinkIcebergKafkaKotlinPrefectSnowflakeSparkSpark Structured Streaming
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Template job posting for a Canada-based role at Block. Responsibilities and qualifications are placeholders. The role would support corporate teams (People, Finance, Counsel, Hardware, Info Security, Platform Infrastructure Engineering), collaborating across business groups, time zones, and disciplines to enable company-wide initiatives.
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.

