Snowflake Data Engineer – P&C Insurance Domain

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 5years

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Toronto (Hybrid - 2 days from Office)

KEY ACCOUNTABILITIES:

The associate should have good real-time hands-on experience with Snowflake DBT and EDW

Should have strong expertise in writing complex PL SQL queries

Should be well versed with Agile delivery and Property and Casualty Insurance domain experience.

1. Deep understanding of the Snowflake cloud data platform - writing procedures functions UDFs snowflake window functions etc. (5 years)

2. Strong hands-on experience with DBT for modular SQL development testing and deployment. (3 years)

3. Proficient in writing complex efficient and maintainable SQL queries.

4. Experience with cloud environments (Azure AWS etc.) and data management technologies.

5. Proven ability to design and implement data extraction transformation and loading processes.

6. Proven experience in Production support in Data warehousing

7. Experience in Property and Casualty Insurance Domain

8. Proficiency in using Git/ Azure DevOps for version control of code.

9. Experience with IT automation batch scheduling and DevOps principles.

10. Collaborate with cross functional teams to meet data driven business objectives.

11. Mentor junior resources and share knowledge work as a team to get requirements delivered.

12. Stay updated with the latest Snowflake features and best practices.

Nice to have skills: Python scripting

Required Skills:

Data Engineer - Toronto (Hybrid - 2 days from Office) KEY ACCOUNTABILITIES: The associate should have good real-time hands-on experience with Snowflake DBT and EDW Should have strong expertise in writing complex PL SQL queries Should be well versed with Agile delivery and Property and Casualty Insurance domain experience 1. Deep understanding of the Snowflake cloud data platform - writing procedures functions UDFs snowflake window functions etc. (5 years) 2. Strong hands-on experience with DBT for modular SQL development testing and deployment. (3 years) 3. Proficient in writing complex efficient and maintainable SQL queries. 4. Experience with cloud environments (Azure AWS etc.) and data management technologies. 5. Proven ability to design and implement data extraction transformation and loading processes. 6. Proven experience in Production support in Data warehousing 7. Experience in Property and Casualty Insurance Domain 8. Proficiency in using Git/ Azure Devops for version control of code. 9. Experience with IT automation batch scheduling and DevOps principles. 10. Collaborate with cross functional teams to meet data driven business objectives. 11. Mentor junior resources and share knowledge work as a team to get requirements delivered. 12. Stay updated with the latest Snowflake features and best practices. 13. Nice to have skills: Python scripting

Required Education:

Skills RequiredAdvanced Java Concepts Core JavaJob DescriptionBachelors degree in computer science or related least 6 years of professional experience as a Java experience with user interface design development using Angular React JavaScript with AG Grid and hands-on development experience designing building end to end web applications starting from front end design Rest APIs to interact with the interface data model to store ma

Toronto (Hybrid - 2 days from Office) KEY ACCOUNTABILITIES:The associate should have good real-time hands-on experience with Snowflake DBT and EDWShould have strong expertise in writing complex PL SQL queriesShould be well versed with Agile delivery and Property and Casualty Insurance domain experi...