Data Engineer - Snowflake, DBT, EDW, PL SQL, P&C Insurance
About the role
Role: Data Engineer - Snowflake, DBT, EDW, PL SQL, P&C Insurance
Location: Toronto
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
-
Deep understanding of the Snowflake cloud data platform - writing procedures, functions, UDFs, snowflake window functions etc. (5+ years)
-
Strong hands-on experience with DBT for modular SQL development, testing, and deployment. (3+ years)
-
Proficient in writing complex, efficient, and maintainable SQL queries.
-
Experience with cloud environments (Azure, AWS etc.) and data management technologies.
-
Proven ability to design and implement data extraction, transformation, and loading processes.
-
Proven experience in Production support in Data warehousing
-
Experience in Property and Casualty Insurance Domain
-
Proficiency in using Git/ Azure Devops for version control of code.
-
Experience with IT automation, batch scheduling and DevOps principles.
-
Collaborate with cross functional teams to meet data driven business objectives.
-
Mentor junior resources and share knowledge, work as a team to get requirements delivered.
-
Stay updated with the latest Snowflake features and best practices.
13. Nice to have skills: Python scripting
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.
Data Engineer - Snowflake, DBT, EDW, PL SQL, P&C Insurance
About the role
Role: Data Engineer - Snowflake, DBT, EDW, PL SQL, P&C Insurance
Location: Toronto
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
-
Deep understanding of the Snowflake cloud data platform - writing procedures, functions, UDFs, snowflake window functions etc. (5+ years)
-
Strong hands-on experience with DBT for modular SQL development, testing, and deployment. (3+ years)
-
Proficient in writing complex, efficient, and maintainable SQL queries.
-
Experience with cloud environments (Azure, AWS etc.) and data management technologies.
-
Proven ability to design and implement data extraction, transformation, and loading processes.
-
Proven experience in Production support in Data warehousing
-
Experience in Property and Casualty Insurance Domain
-
Proficiency in using Git/ Azure Devops for version control of code.
-
Experience with IT automation, batch scheduling and DevOps principles.
-
Collaborate with cross functional teams to meet data driven business objectives.
-
Mentor junior resources and share knowledge, work as a team to get requirements delivered.
-
Stay updated with the latest Snowflake features and best practices.
13. Nice to have skills: Python scripting
About Atlantis IT Group
"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.
"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.
Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.
OUR PRODUCTS:
"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.
"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.
"BM-POS"
We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.