Position: Data Analytics
Category: SQL
English level: intermediate
Years of experience: 7


Main responsibilities:
·      development of reports, formation and presentation of management reporting, in particular:
·        development of a CASH-FLOW report on the bank's performance (in particular, growth / outflow in deposits and current accounts of individuals and legal entities, issued loans, growth in the credit card portfolio, available liquid funds at the beginning of the business day);
·        writing SQL queries for:
 formation of databases;
 data analysis and output of calculated information in the CASH-FLOW report (gains in liabilities, sales of loans / deposits);
 formation of a deposit portfolio in distribution by type of client, product, rate, term;
 formation of a loan portfolio in distribution by type of client, product, collateral, amount of debt, days of delay, client status, income;
·      automation of report generation and control of their execution;
·      preparation and provision of data for analysis to auditors, incl. external auditors;
·      preparing presentations and holding meetings;
·      participation in the implementation of new projects and processes, writing policy, regulations and methodology for liquidity management;
·      preparation of databases SQL and their processing for presentation in reports as part of the NBU inspections, in particular:
o   analysis of the business model in terms of generating data on regulatory capital, regulatory capital adequacy ratio (N2), capital adequacy ratio (N3), N7 standards (maximum credit risk per counterparty), N8 (large credit risks), N9 (maximum the amount of loans, guarantees and sureties provided to one insider) and limits on the total long / short open foreign exchange position;
o   to assess sustainability, providing data on the calculation of regulatory capital adequacy (N2) and capital adequacy (N3);
·      preparation of databases in SQL and their processing for presentation in reports as part of the audit of financial statements by BDO (calculation of standards, ratings and assessment of the financial condition of counterparty banks);
·       participation in the development of currency exchange functionality in the development of the O.Bank mobile application (setting limits, conducting their control, impact on an open currency position, cut-off limits (min, max value and in crisis situations), writing and setting technical specifications and monitoring it execution);