Data & BI Business Analyst (SQL + Oracle)

QUANTEAM (RAINBOW PARTNERS Group); Porto; On-site; EUR 25,000 - 39,000; Full time

Benefits offered by this job

Health insurance

Extra holiday: Christmas Eve or New Yr

Access to Quanteam Academy

Job summary

Quanteam, the founding entity of RAINBOW PARTNERS, is seeking a Business Analyst – Data & BI based in Porto. You will write SQL queries, profile raw data, and translate business needs into technical requirements across Data Engineering, BI and Analytics teams.

The role requires 3+ years of BA experience in Data/BI, strong SQL, and English (C1). Portuguese C1 is highly desirable, with French a plus; permanent contract and health insurance offered.

Qualifications

• Write SQL queries to explore and analyze data within Oracle databases.
• Profile raw data to understand its structure, identify business rules, and detect anomalies.
• Collaborate with Data Engineering, BI, and Analytics teams to translate business needs into technical requirements.
• Prepare clear functional and technical specifications, including source-to-target data mappings.
• Support business stakeholders in defining requirements based on the data available in existing systems.
• Design and execute functional and technical test plans, including data reconciliation and validation.
• At least 3 years of solid experience as a Business Analyst, ideally within Data or BI projects.
• English proficiency at C1 level is mandatory.
• Portuguese proficiency at C1 level is highly desirable.
• French proficiency at B2 level is a plus.

Responsibilities

• Write SQL queries to explore and analyze data within Oracle databases.
• Profile raw data to understand its structure, identify business rules, and detect anomalies.
• Collaborate with Data Engineering, BI, and Analytics teams to translate business needs into technical requirements.
• Prepare clear functional and technical specifications, including source-to-target data mappings.
• Support business stakeholders in defining requirements based on the data available in existing systems.
• Design and execute functional and technical test plans, including data reconciliation and validation.

Skills

SQL

Analytical thinking

Communication

Stakeholder management

Tools

Oracle databases

SQL Developer

TOAD

DBeaver

PL/SQL Developer

Job description

Quanteam, the founding entity of RAINBOW PARTNERS, is seeking a Business Analyst – Data & BI based in Porto. You will write SQL queries, profile raw data, and translate business needs into technical requirements across Data Engineering, BI and Analytics teams.

The role requires 3+ years of BA experience in Data/BI, strong SQL, and English (C1). Portuguese C1 is highly desirable, with French a plus; permanent contract and health insurance offered.