Finance Data & Power BI Analyst

🤔Who are we?

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:

➡Quantitative Finance

➡Risk & Compliance

➡Operations & Finance

➡Transformation & Organization

➡ Information Systems.

🔎 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.

🎁 WHAT WE OFFER

• 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).
• Meal allowance.
• 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.
• Career progression plan.
• Ongoing follow-up and technical support provided by a Consultant Expert.

📍 Hybrid position based in Porto

🚀If you feel this opportunity is for you, send your CV and join our team!