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 Description
Key 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.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Top Skills
Apache Nifi
AWS
Azure
Dbt
GCP
Snowflake
SQL
Talend
Similar Jobs
eCommerce • Healthtech • Kids + Family • Retail • Social Media
The Staff Media Revenue Analyst will drive advertising revenue growth through data analysis, insights, stakeholder collaboration, and development of reporting tools and models.
Top Skills:
PythonSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The Business Systems Analyst will analyze business and technical requirements, create user stories, communicate with stakeholders, and support development teams in a financial services context.
Top Skills:
APIsBitbucketConfluenceJIRAJSONWsdl
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
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.
