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
Lead the Customer Experience Measurement Program by managing projects, analyzing customer feedback, and providing actionable insights to enhance user experience.
Top Skills:
AWSGoogle SuiteExcelMicrosoft PowerpointPythonSQLTableauTeradata
eCommerce • Software • Design • SEO
Lead and mentor a team of data scientists and ML engineers, driving product analytics and experimentation strategies to impact business growth.
Top Skills:
Data AnalyticsData ScienceMachine LearningStatistics
Enterprise Web • Fintech • Financial Services
The Senior Marketing Data Analyst will drive user acquisition and engagement through data analysis, optimizing marketing strategies, and reporting on key performance indicators across platforms.
Top Skills:
AWSGoogle AdsGoogle AnalyticsGoogle Marketing PlatformGoogle Tag ManagerLooker StudioPythonRSQLTableau
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal