Data Architect

Context

The Risk department has decided to redesign its regulatory and internal reporting tools for the entire Quintet Group. The target solution will be based on collecting data sources through our Microsoft Data Platform, as well as transforming the data and producing a large part of Group Risk reporting using the WKFS RiskPro tool and for a limited list of reports using Risk EUC and Power BI reports / Dashboard.

Functional & technical scope

• Risk reporting : IRRBB, Liquidity, Trading, Counterparty.
  


• Data source to integrate : Cognos reports, Standard & Poor, Bloomberg, Pension Funds, Intraday Liquidity.
  


• Technical skills : Azure Synapse analytics, Azure Data Factory, SQL/ELT, Power BI, Purview, CI/CD.
  

Main tasks

• Target Risk architecture to define, to detail and to document
  


• Define the list and characteristics of dataflow to implement
  


• Design data model requited for risk reporting (IRRBB, Liquidity, etc.) to facilitate data integration in WKFS Risk Pro
  


• Define Transformation rules (high level)
  


• Ensure the application of Group quintet standard (Security, data management, etc.)
  

Skills

• Architecture Azure
  


• Azure Synapse analytics
  


• Data modelisation
  


• ETL patterns
  


• WKFS Risk Pro knowledge
  


• Bank experience
  


• Risk reporting
  


• French/English