Search jobs

Apply for this job

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!

Ref: #39225

Business Analyst Reporting SQL ETL 6 months rolling Latvia

  • Practice Data

  • Technologies BI/DATA Skills

  • Location Riga , Latvia

Business Analyst Reporting SQL ETL 6 months rolling Latvia

Business Analyst Reporting SQL ETL 6 months rolling Latvia

BA for AQR project

Project: BAU – Finance – Comprehensive Assessment (incl. AQR)

Duration: ASAP – 6 months

Location: Riga

Scope of work:

Business Analyst SQL Reporting is required to assist with ECB’s Asset Quality Review The assessment usually comprises two main pillars:

an asset quality review (AQR) – to enhance the transparency of bank exposures, including the adequacy of asset and collateral valuation and related provisions

a stress test – to test the resilience of banks’ balance sheets, performed in close cooperation with the European Banking Authority (EBA)

Business Analyst is required to assist with understanding what information is kept on the source servers, whether the information is present and what is quality of the data (in collaboration with Data Stewards). Business Analyst SQL Reporting must have an understanding of databases, where and how data is being manipulated, and be able to assess the qualitative requirements as well as legislative requirements defined by ECB. As the project needs to finalized within year 2020, the person should already have an understanding of the Banking industry terminology, basic understanding of Credit Risk and how it is measured, as well as reporting experience. Will include also, not conclusively:

Support project team in assessing data availability, data sufficiency, and reporting needs

Design and write data queries to extract credit data from various systems and conduct analysis and mapping towards the ECB & Business requirements

Provide support for portfolio credit risk oversight and governance by tracking the actual performance of risk appetite and credit risk management metrics against approved guardrails

Adhere strictly to compliance and operational risk controls in accordance with company and regulatory standards, policies and practices

Formulate & Assist on AQR specific testing.


Competence requirements:


Able to communicate clearly and fluently with different stakeholders

Able to build a shared understanding of the problems and determine potential solution

Able to work in a fast-paced environment with cross-functional project team

Able to be self-organized, balanced and show initiative

Is Detail oriented

Able to utilize Atlassian products seen as a plus.

Familiar with banking terminology

Experience in Credit Risk or Asset Management Risk/valuation seen as a benefit

Experience in Reporting seen as a benefit

Location: Riga


Able to navigate the Databases with ease.

Should be able to assess the quality of the data.

Assist in constructing success criteria

Knowledge of SQL required (JOIN, SUBQUERY, CASE, etc.)

Knowledgeable about databases (Oracle, MSSQL, PostgreSQL), previous working experience seen as a plus.

Knowledgeable about Data Warehouse and Reporting is a benefit.

For more information please call Dilan on 0207 324 1795 or email

Apply now