Data-Driven Pricing & Portfolio Analytics Analyst

The Ardonagh Group; Dublin; On-site; EUR 60,000 - 90,000; Full time

Job summary

Orvia Underwriting is seeking a hands-on Pricing & Portfolio Management Analyst to join our Actuarial & Portfolio Management team within the CUO office. Working closely with senior colleagues, you will help develop the underwriting performance management framework and gain broad exposure to diverse lines of business.

You will build data pipelines, perform data cleaning and validation, support price change monitoring, and contribute to dashboards and BI tools, leveraging Python/SQL and Excel as

Qualifications

• Part-qualified actuary (IFoA or equivalent) making good progress with exams.
• A high level of numeracy skills and analytical approach to work is essential.
• Strong coding and data skills; advanced Excel and ideally experience with Python/SQL.
• Experience (or strong aptitude) with dashboarding/BI tools such as Power BI.
• Exposure to P&C insurance data; MGA/delegated authority or bordereaux experience is a plus.
• Understanding of, or keen interest in, pricing and portfolio management concepts such as rate change monitoring, technical price models, and ultimate loss ratio projection.

Responsibilities

• Build, maintain, and improve data pipelines feeding portfolio management processes.
• Perform data cleaning, validation, and reconciliation with robust checks.
• Assist with forward-looking KPIs such as price adequacy and risk-adjusted rate changes.
• Manage rating tools and support digitisation into modern platforms.
• Lead production of data submission packs and portfolio monitoring packs for partners.
• Assist with exposure/mix analyses and with claim frequency/severity investigations.
• Build and maintain dashboards/MI (Power BI or similar).
• Document processes, tools, and data definitions for scalable workflows.

Skills

Numerical analysis

Data analysis

Python/SQL

Excel (Advanced)

BI dashboards

Education

Part-qualified actuary (IFoA or equivalent)

Tools

Power BI

Job description

Orvia Underwriting is seeking a hands-on Pricing & Portfolio Management Analyst to join our Actuarial & Portfolio Management team within the CUO office. Working closely with senior colleagues, you will help develop the underwriting performance management framework and gain broad exposure to diverse lines of business.

You will build data pipelines, perform data cleaning and validation, support price change monitoring, and contribute to dashboards and BI tools, leveraging Python/SQL and Excel as