What we’re about
Join the official Snowflake User Group Ireland Meetup!
Who is it for?
The Snowflake User Group is an open group. Everyone working in data is welcome. You will benefit from the group even if you are not a Snowflake user.
So if you have one of the following roles you are more than welcome to join.
Data engineers
BI engineers
Data architects
Data scientists
Data analysts
Data governance experts
Why join?
Stay up to date on the latest topics in the field of data management
Network with fellow Snowflake users in Ireland
Meet with Snowflake engineers and other Snowflake staff
Share best practices
Exchange tips and tricks
Have fun and chats
Grab some Snowflake swag
What events can you expect?
We aim to run 8-10 events per year with different types of content.
Presentations, content, and discussion on the latest feature announcements from Snowflake
Snowflake success stories. Implementation by customers
Informal events with chats and networking
Workshops and hands on sessions
Demos
Upcoming events
1
Scaling Reinsurance Compliance: The Engineering Behind PartnerRe’s "Overlay"
Clayton Hotel Charlemont, Charlemont St, Saint Kevin's, Dublin, D02 H9C1, Ireland, Dublin, IETo meet regulatory standards like Solvency II and LDTI, reinsurance firms must simulate how thousands of insurance policies perform under thousands of potential economic futures.
In data terms, this creates a "Cartesian explosion"—multiplying two manageable datasets creates a result set of billions of rows. This massive computational workload frequently overwhelms traditional on-premise infrastructure.
In this session, Zsolt Revay and Thomas Mager detail the engineering behind "Overlay," the internal data application PartnerRe built to solve this scaling challenge.
Overlay’s architecture decouples business logic from compute power. We use Datavirtuality as a semantic orchestration layer, while leveraging Snowflake strictly as a heavy calculation engine.
By using an aggressive SQL push-down strategy, we treat the database as a compute cluster. This allows us to process that Cartesian explosion of policy data and stochastic scenarios right where the data lives—without moving it across the network.
Key Technical Discussion Points:
- Optimisation: Handling massive joins via parallel processing and strategic table materialisation.
- Performance: Using Elastic Virtual Warehouses to achieve linear scaling, reducing processing time from hours to minutes.
- Economics: Using Auto-Suspend and Resource Monitors to keep this massive compute power cost-effective.
Attendees will learn how to architect a solution that balances the auditability required by regulators with the on-demand agility required by actuaries.
Event Details
📍 14th January | Clayton Hotel
18:00 | Food & Drinks 🍽️🥂
18:30 | Scaling Reinsurance Compliance: The Engineering Behind PartnerRe’s "Overlay"
19:15 | Drinks & Networking 🍻
Don’t miss this opportunity to connect with fellow data professionals and gain valuable insights into efficient Snowflake use, Gen AI applications, and proving the value of solid data modeling! See you there!
Speakers:
Zsolt Revay - Head of Data Engineering
Thomas Mager - Head Data and Analytics Platforms21 attendees
Past events
12
