Strategic Pricing & Portfolio Analytics Analyst

Ardonagh Europe; Dublin; On-site; EUR 60,000 - 80,000; Full time

Job summary

Orvia Underwriting, a pan‑European MGA launched by The Ardonagh Group, seeks a hands‑on Pricing & Portfolio Management Analyst to join the Actuarial & Portfolio Management team within the CUO office. You will gain broad exposure to diverse lines of business and grow into pricing work as the team scales.

You will build data pipelines, perform data cleaning, develop forward-looking KPIs, manage rating tools, and produce portfolio packs for carrier partners, while developing dashboards in Power BI

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 and data flows feeding portfolio management processes.
• Perform data cleaning, validation, and reconciliation, establishing robust checks.
• Assist with the development and refinement of forward-looking KPIs (e.g. price adequacy and risk adjusted rate change) under the guidance of more senior colleagues.
• Manage and maintain rating tools in close collaboration with underwriting colleagues: version control, testing, implementing rate changes, and supporting their digitisation into modern platforms.
• Lead the production of data submission packs and regular portfolio monitoring packs for carrier partners.
• Assist with exposure and mix analyses and with claim frequency and severity investigations.
• Build and maintain dashboards and MI (e.g. Power BI or similar).
• Document processes, tools, and data definitions as they are built, so the team scales on solid foundations.

Skills

Numeracy skills

Analytical approach

Coding/data skills

Power BI experience

Education

Part-qualified actuary (IFoA or equivalent)

Tools

Power BI

Python

SQL

Excel

Job description

Orvia Underwriting, a pan‑European MGA launched by The Ardonagh Group, seeks a hands‑on Pricing & Portfolio Management Analyst to join the Actuarial & Portfolio Management team within the CUO office. You will gain broad exposure to diverse lines of business and grow into pricing work as the team scales.

You will build data pipelines, perform data cleaning, develop forward-looking KPIs, manage rating tools, and produce portfolio packs for carrier partners, while developing dashboards in Power BI