Design and develop data models in Snowflake, implement ETL processes, and support Guidewire Claims workflows with SQL querying and cloud integration.
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.
Top Skills
Apache Nifi
AWS
Azure
Dbt
GCP
Snowflake
SQL
Talend
Similar Jobs
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Sr. Consultant will drive business insights through analytics, develop statistical models, and collaborate with various teams to optimize strategies and support sales efforts.
Top Skills:
ExcelPythonRSASSQL
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
The Workforce Management Analyst will support large contact centers by managing metrics, reporting, and collaborating across teams for strategic workforce solutions.
Top Skills:
AssembledExcelGoogle SheetsLookerNicePower BISQLTableauVerint
Fintech • Machine Learning • Payments • Software • Financial Services
The Senior Associate will analyze data for underwriting strategies, collaborate with teams to implement changes, and present findings to leadership.
Top Skills:
PythonQuicksightSQLTableau
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.
