Data Analyst (SQL) in Pershiy Ukrayinskiy Mizhnarodniy Bank, AT / PUMB

Experience:< /p>

• Proficiency in tools: SQL and Excel.
• SQL: Writing database queries (Sybase IQ), JOINs (Inner, Left, Right), Working with data formats and their transformations,Window functions (... OVER… PARTITION BY…), Understanding how tables are created and modified (DDL), other
• Excel:  Basic formulas, Text and math functions, references and arrays, VBA and understanding the principle of operation of Excel macros, the ability to analyze simple code and modify it, Power Query, Power Pivot, Pivot tables
• Graphics, data visualization, preparation of materials for reports and presentations
• Experience in building a cohort analyst
• Proficiency in Power BI
• Availability of experience in automation and support of analytical reporting in the financial sphere
< li>Experience in working with regulatory requirements of the NBU (calculation of reserve, credit risk, work with the Credit Register, etc.) - desirable

Your role:

• Calculation of the reserve in accordance with the requirements of IFRS 9
• Description, testing, control of the implementation of logic and the quality of information filling for the Credit Register of the NBU
• Preparation of regulatory monthly reporting on credit risks for review by the Bank's Collegiate Bodies
• Participation in budgeting processes
• Building regulatory reporting units on work with overdue debt
• Monitoring the work of the automated decision-making system

What you get:

• One ​​of the best employers
• official job description
• Decent compensation
• Health insurance
• Remote work
< li style="font-weight: 400">Opportunities for career development
• Stable and perspective work in a leading bank of Ukraine;