Data & Automation Analyst - Porto

Hipoges; Porto; On-site; EUR 30,000 - 45,000; Full time

Job summary

A leading asset management company in Porto is seeking an Analyst to manage data entry, develop automated processes, and prepare reports. The ideal candidate should have strong knowledge of databases, ETL tools, and at least B2 level English proficiency. Responsibilities include database operations, analysis of cash flows, and onboarding new portfolios. Ideal candidates should be organized and have a minimum of two to three years of experience in a similar role.

Qualifications

• At least two/three years of experience in similar roles.

Responsibilities

• Manage data entry and prepare reports.
• Perform database operations and analyze cash flows.
• Develop automated processes to improve efficiency.
• Monitor reconciliation of different portfolios.
• Board new portfolios into the database.

Skills

Knowledge of databases (SQL language, PostgreSQL, MySQL)

Knowledge of ETL (Pentaho, PowerBI, PowerCenter, Talend)

Knowledge of Java (ELK)

Knowledge of Python

Advanced Excel skills

At least B2 level of English

Strong analytical skills

Organized, resilient, and able to meet deadlines

Education

Degree in Engineering, Mathematics, Statistics, or another relevant

Job description

Founded in 2008, Hipoges is one of the leading Asset Management platforms in the Iberian Peninsula, with over €48.5 billion in assets under management. With a presence in Spain, Portugal, Greece and Italy, and more than 1,800 employees worldwide, Hipoges works with leading financial institutions and international investors.

Hipoges provides a wide range of asset management-related services, including:

• Advisory services in the valuation and acquisition of portfolios;
• Design of processes and implementation of management tools;
• Development of servicing solutions for different types of assets;
• Advisory department supporting portfolio acquisition operations and co-investment alongside its clients.

BRIEF JOB DESCRIPTION

The Analyst position is responsible for managing data entry, developing new automated processes to improve the system, and preparing reports.

RESPONSIBILITIES

• Database operations;
• Automation of various processes;
• Developing new processes to avoid manual tasks;
• Analyzing cash flows and monitoring the reconciliation of different portfolios;
• Boarding new portfolios that the company begins to manage into the database.

SKILLS

• Knowledge of databases (SQL language, PostgreSQL, MySQL, entity-relationship model) - mandatory;
• Knowledge of ETL (Pentaho, PowerBI, PowerCenter, Talend) - preferred;
• Knowledge of Java (ELK) - preferred;
• Knowledge of Phyton - preferred;
• Advanced Excel skills are a plus;
• At least B2 level of English - mandatory;
• Strong analytical skills;
• Organized, resilient, and able to meet deadlines.

QUALIFICATIONS

• Degree in Engineering, Mathematics, Statistics, or another relevant;
• Experience: At least two/tree years of experience in similar roles.

Hipoges is an equal opportunity employer, promoting a discrimination‑free work environment where individuals are treated with dignity and respect. Hipoges does not discriminate in any aspect of employment based on race, ethnicity, nationality, religion, age, gender, sexual orientation, disability, or any other characteristic protected under applicable law. We adhere to these principles across all aspects of employment, including recruitment, hiring, training, compensation, promotion, and benefits.