Business Analyst

This project is part of the business investment banking and financial services area, and currently has its technological hub in Portugal and is working on the development of innovative solutions and support for all operations related to the business.

We are looking for a Business Analyst to work in this project in Porto (Hybrid).

Requirements:

• SQL Knowledge: Ability to write queries (JOINs, subqueries, analytical functions, etc.) to query and analyze databases;
  
• Experience: 3+ years of solid experience as a Business Analyst;
  
• Oracle Environment: Experience working with Oracle databases (using tools such as PL/SQL Developer, TOAD, DBeaver, or SQL Developer);
  
• Data Analysis: Ability to analyze data models (tables, views, primary/foreign keys);
  
• Data Modeling: Basic understanding of data architecture concepts (Data Warehouse, Data Marts);
  
• Advanded level of English language is mandatory;
  
• Portuguese language: C1 level (very nice to have) and French language: B2 level (nice to have).
  

The mission consists of:

• Writing SQL queries to directly query and analyze tables within our database;
• Exploring and profiling raw data to understand its structure, underlying business rules, and to identify potential anomalies;
  
• Working closely with Data teams (Data Engineers, BI, and Analytics) to translate functional business rules into technical requirements;
• Drafting clear functional and technical specifications (source-to-target data mapping);
  
• Assisting business stakeholders in defining their requirements by providing a realistic view of the data actually available in the Oracle systems;
  
• Designing and executing test plans (both functional and technical data reconciliation).

What can you expect from us?

• Health insurance;
• A personalized training plan, with a budget to spend on the training you find necessary;
• Constant feedback so you can grow professionally;
• Remote onboarding process;
• Team events every semester so you can live new adventures;
• Culture of proximity and transparency. Your ideas and needs are heard and valued by us!