Small and micro business analyst at the Center for Analytics and Research in Bank Pivdenniy

Bank "Pivdenny" is one of the leaders of the financial market of Ukraine, which ranks third in the group of Ukrainian banks with private capital in terms of assets. "Pivdenny" has been a reliable financial partner for private and corporate clients for 31 years. The Pivdenny team consists of more than 1,700 active and purposeful employees throughout Ukraine. Four years in a row, the bank has been included in the ranking of the "50 best employers" according to Forbes magazine.

We offer:

• competitive wages;
• medical insurance or compensation for a gym membership;
• work in a functional, comfortable office with the possibility of remote work; 
• consultations of a corporate psychologist;
• opportunity for career growth and development;
• opportunity to take professional courses and training;
• opportunity to work in a stable and professional company with a friendly team.

What needs to be done:

• Collection, processing and analysis large data sets on small and micro business clients, their use of banking products and services
• Building reports and dashboards regarding:
  • credit volumes
  • passive balances
  • forex operations
  • acquiring
• Preparation of regular and ad-hoc analytics for management and product teams
• Setting technical tasks for the automation of reporting (description of requirements, formulas, logic, data sources)
• Cooperation with IT, product teams, marketing
• Automation of management reporting in the direction of small and micro businesses
  • development and support of reporting on the performance of planned indicators
  • creation of business requirements for automation of reporting (+testing for correctness and completeness)
  • participation in projects with automation
  • work with external data sources
  • financial modeling, portfolio forecasting

This will require:

Education: higher in economics, finance, applied mathematics, statistics, business analytics
Experience: 2+ years of banking experience. Relevant experience in analytics or automation will be a plus
Professional skills:

• Microsoft Excel - at a high level (formulas, summary tables, graphs)
• Knowledge of the PowerQuery/PowerPivot add-on will be a plus
• Understanding banking products, services and their accounting models in the bank balance sheet
• Skills in setting technical tasks, BRD/FRD
• Ability to build financial models and forecast portfolio indicators will be a plus
• Experience with Oracle Analytics (Oracle BI) will be a plus
• Basic SQL removal will be a plus