Dune (Dynamic Utility for Investment Earnings) Solution Lead

Job description

*

Whatever their stage of life, we provide over 108 million customers with the products and services they need to progress. From insurance to personal protection, and savings to wealth management, no matter the need we’re always there for them. And we’re always there for our employees. In 50 countries, we work hard to inspire pride and a sense of belonging in our people. To provide opportunities that challenge them, inspire them, and reward them. And to create a culture that’s open, supportive, and empowering. Because we know that’s the real secret to success – and the best way for us to keep building a better world for both our customers and the talented people who put them first.

Your work environment:

The headquarters of the AXA Group (GIE AXA) brings together our corporate activities. It provides guidance and support to subsidiaries around the world, to ensure the coordination and monitoring of the Group's global strategy, the application of its standards, the consistency of commercial approaches and the sharing of best practices. The headquarters gathers approximately 1000 employees and is distinguished by its strong international culture (45 nationalities), which makes it a rich and stimulating place to work.

Department description:

The DUNE teams operate with multiple suppliers (PBRC, RM, asset managers, Performance Controlling, Actuary, Group IT, etc.) and multiple clients (Group and local, finance, investment, risk, compliance, etc.)

The main challenges are:

• to manage the pricing complex investments, with new type of investments coming frequently,
• to manage the several accounting norms and their evolution
• to manage the multiple stakeholders using different inputs, output features and tools
• to have the solidity of a robust process under the scrutiny of various internal controls and the agility to adapt rapidly to market crisis or other circumstances.

Detailed missions and responsibilities:

Provide the Group Investment professionals and other stakeholders with earnings forecast process dedicated to investments, fed by quality data and providing reliable outputs.

The mission encompasses :

• Developpe and improve the process of earnings projection on financial assets across the group
• Contribute to the development of a tool taking a deterministic approach to forecast earnings, invested assets and cash flows to facilitate the building of strategic plans, sensitivities, impairments and other simulations.
• The mission encompasses the design and development of such a tool using SQL/Python in a Spark environment (Azure Databricks), the writing of a documentation and the creation of a dynamic restitution of the results using a web-based reporting tool with regular production of the outputs/reports, including quantitative controlled data
• Help in Coordinating the tool use and outputs/reports production with local investment teams

Key accountabilities:

• DUNE Technical Platform Expert
  • Produce of reliable, readable, version controlled, documented & commented code in SQL/Python
  • Maintain a comprehensive and up to date documentation of the code/project.
  • Ensure the integrity & consistency of the tool while integrating new features (such as pricing methods)
  • Ensure architecture and Infrastructure proper evolution o Developpe the platform enhancement with new accounting norms
  • Provide support to entities on the solution.
  • Implement new functionalities based on user needs (tool ergonomics, outputs, API for local entity financial tools)
• Support for AXA Group teams and entities
  • Interaction and support for local entities, other department teams: Asset Liability Management Team (ALM), Group Investment Solutions (GIS)
  • Support for other departments notably Group Performance Controlling, Investor Relations, Accounting (PBRC) and local entities

Desired profile

Qualifications :

Technical knowledge :

·  Excellent knowledge of R/Python programming
·  Excellent knowledge of Spark SQL
·  Knowledge of a data visualization and analytics tools (such as Spotfire, Tableau, Rshiny,…)
·  Knowledge of Azure (Databricks, DevOps, Data Factory, Azure Storage Explorer) is a plus
·  Knowledge of SAS & SAS Risk Dimension is a plus
·  Good knowledge of financial markets / financial instruments and valuation is a plus
·  Fluent English

Various skills :

·  Excellent verbal and written communication skills
·  Strong organization skills with the ability to manage multiple tasks and deadlines simultaneously
·  Ability to work with attention to detail and follow-through

Experience

·  3 to 5 years' experience, with a background in:
·  Mathematics, Statistics, Data, Data science
·  Actuarial, Finance, Economics or Accounting