business analysis

business analysis (89322)

Business & Functional Analyst

1-4 Yrs

Full Time Jobs

Market Rate

Frankfurt, Germany


Special Requirement
  • Creation of business and functional requirements
  • Creation of policies, procedures, and manuals
  • User acceptance testing
  • Proficient in the respective functional / business area 
Job Description:

1.Design ESG Data Model:

Design Data Model (Physical and Logical)

  • Data model should be aligned to business scopes (i.e. Investment, Private  and Corporate) and to transaction level (i.e. Loans, Bonds, Facilities, Mortgages,  Facilities, Derivatives, Assets Management, and Structured Products).
  • ESG data input points should match with ESG reporting requirements.
  • In-scope data points: Environmental, Social, Governance, Volume, Identified


2. Automate and build data upload solution

ESG Data Upload and Ingest capability

  • E-templates for Data upload capability in relation to Finance Reporting Solution will be used by Front Office teams for reporting on ESG positions as required at transaction level
  • Front Office workflow and process changes to operationalise upload
  • Finance Reporting workflow as well as process changes for ivoke ingest and consumption
  • Allignment of Revised Finance Reporting data model with ESG Data Model (Stream 1)
  • Bring changes in Finance Reporting tools for enabling e-template ingestion, data consolidation and staging in order to report consumption, including the consumption by other corporate systems


3. Business rules, Reporting, Data sourcing, and Data mapping definition

  • Perform data mapping by making use of  EU Data Taxonomy
  • Collaborate with Finance stakeholders for defining reporting requirements, data tables and data dictionary
  • Design Regulatory ESG reports
  • Develop business rules for transformation of data
  • Implement ETL Process
  • Perform Data validation, Reconciliation and Testing


4. Build reporting workflow

Basic ESG Reporting Workflow Capability:

Service based solution design that consists of GCP components:

  • Ingestion layer (internal sources only)
  • Service layer (business logic in order to deliver workflow capability for report generation, Which includes report review, approval, escalation and release capability. 
  • Solution architecture should be developed on GCP by using Big Query at the core for hosting the data layer
  • Anti-corruption layer to integrate with Data Quality framework and other corporate system data feeds
Similar Jobs

Senior Business Analyst (89182)

London, Uk

IT Analyst (88875)

Veldhoven, Netherlands

Senior IT Analyst (88872)

Veldhoven, Netherlands