Finance Data & Power BI Analyst

QUANTEAM - Portugal (RAINBOW PARTNERS Group); Porto; Hybrid; EUR 25,000 - 61,000; Full time

Benefits offered by this job

Health insurance

Extra holiday: Christmas Eve or New+>

Quanteam Academy access

Elevate Program

Consultant Expert support

Job summary

Quanteam, the founding entity of RAINBOW PARTNERS, is seeking a Finance Data & Power BI Analyst in Porto. The role blends finance expertise with business intelligence to design dashboards, consolidate data, and automate reporting in a hybrid 50% on-site/50% remote model.

You will work with Power BI, Power Query, DAX and Python for data processing, while supporting month-end closes and financial reconciliation. On-site onboarding is required for the first month.

Qualifications

• 3-4 years of experience in Finance, Financial Analysis, BI or Data Analytics.
• Advanced knowledge of Power BI including dashboard development and reporting.
• Strong skills in data integration, modelling, transformation and Excel-based analysis.
• Experience with data reconciliation and financial reporting processes.

Responsibilities

• Design, develop and maintain Power BI dashboards and reports from scratch.
• Consolidate data from multiple sources and build robust data models.
• Transform data using Power Query, DAX and Python where relevant for automation.
• Support financial closing activities and ensure data accuracy in reporting.

Skills

Power BI

Data integration

Python

Excel

Finance knowledge

Data modelling

Data transformation

Stakeholder management

Analytical mindset

English proficiency

Education

Degree in Finance, Economics, Accounting, IT, Data Analytics

Tools

Power BI

Power Query

DAX

Python

Excel

Job description

Quanteam, founding entity of RAINBOW PARTNERS, is a consulting firm specialized in Banking and Financial Services. With more than 1200 consultants across 10 countries, we combine business and IT expertise to support leading institutions in transformation projects.

Our core areas:

Operations & Finance

We are looking for a Finance Data & Power BI Analyst

Main Tasks

• Power BI Development: Design, develop and maintain Power BI dashboards and reports from scratch, supporting financial analysis and business decision-making.
• Data Integration & Modelling: Consolidate data from multiple sources, transform datasets and build robust data models to ensure data consistency, accuracy and reliability.
• Data Transformation & Automation: Use Power Query and DAX to transform data, develop calculations and optimise reporting processes. Apply Python where relevant to support data processing and automation.
• Financial Reporting & Analysis: Support financial closing activities, financial reporting and data reconciliation, ensuring the accuracy and consistency of financial information.
• Data Quality & Reconciliation: Identify discrepancies between data sources, investigate inconsistencies and ensure the integrity of financial data.
• Excel-Based Analysis: Perform advanced financial analysis and data manipulation using Excel.
• Stakeholder Management: Collaborate with internal stakeholders to understand reporting requirements, translate business needs into analytical solutions and present financial insights clearly.
• Continuous Improvement: Identify opportunities to improve financial reporting, dashboard performance and data management processes.

Main Skills & Requirements

• Professional Experience: Approximately 3-4 years of experience in Finance, Financial Analysis, Business Intelligence or Data Analytics, ideally combining financial knowledge with technical data skills.
• Power BI: Advanced knowledge of Power BI, including dashboard development, data visualisation and data modelling.
• Power Query & DAX: Hands-on experience with Power Query for data transformation and DAX for calculations and analytical measures.
• Python: Basic to intermediate knowledge of Python, with an interest in using it for data processing, analysis or automation.
• Microsoft Excel: Expert-level Excel skills, including advanced formulas, data manipulation and financial analysis.
• Finance Knowledge: Understanding of financial reporting, month-end closing processes and data reconciliation.
• Data Integration: Ability to consolidate, transform and analyse data from multiple sources and build reporting solutions from scratch.
• Academic Background: Degree in Finance, Economics, Accounting, Information Technology, Data Analytics or a related field. Candidates with a hybrid Finance & IT background are particularly relevant.
• Communication & Stakeholder Management: Strong interpersonal and communication skills, with a proactive approach to understanding and addressing internal stakeholders' needs.
• Analytical Mindset: Strong attention to detail, problem-solving skills and a structured approach to data validation and financial analysis.
• Languages: English proficiency required. French is considered a plus but is not mandatory.
• Location: Porto, Portugal.
• Hybrid Working Model: 50% on-site and 50% remote, subject to team and business requirements.
• Onboarding: 100% on-site during the first month.
• This role offers a gross annual salary between 24.500€ to 60.500€, defined according to the candidate’s experience and competencies.
• Permanent contract (CTI).
• Health Insurance.
• Extra holiday: Christmas Eve or New Year’s Eve.
• Access to Quanteam Academy for continuous learning and certifications.
• Elevate Program to support professional development and career growth.
• Ongoing follow-up and technical support provided by a Consultant Expert.

Hybrid position based in Porto