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
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
Fintech • Machine Learning • Payments • Software • Financial Services
The role involves developing fraud strategies, analyzing data to prevent fraud losses, and collaborating across teams to enhance customer experiences. It includes deep dives into fraud trends using SQL and Python, alongside project leadership.
Top Skills:
PythonQuicksightSQLTableau
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
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.