Account Financial Analyst | EMEA

Colliers; Warszawa; Hybrid; PLN 100,000 - 160,000; Full time

Benefits offered by this job

Hybrid work Warsaw

International environment (English)

Private healthcare

Parental leave benefit

Training program

Job summary

Colliers International in Warsaw seeks a Financial Analyst to perform advanced financial analysis and modeling to support a client account. You will help optimize real estate strategies and present insights to clients in a cross-functional team environment.

The role requires strong Excel and analytical skills, experience with VBA, and the ability to communicate effectively in English within an international setting.

Qualifications

• BA or higher in finance or related areas.
• Exceptional analytical skills.
• Excel: advanced functions (lookup, index, sumproduct).
• Moderate VBA coding experience beyond macros.
• Proficiency with MS Access and other Office apps.
• Strong written and verbal communication skills.
• Experience in consulting, real estate, capital markets or banking.
• Proactive, able to prioritize and multi-task.

Responsibilities

• Utilize and improve highly-customized financial models to analyze occupancy alternatives.
• Optimize client's real estate strategy by providing customized analysis of different scenarios.
• Participate in regular client meetings to review alternatives and provide advice.
• Present financial models to clients; engage with Client and Account teams.
• Review lease documents for inputs in financial models and manage lease database data.
• Work in a project-based team environment with daily cross-team cooperation.

Skills

Analytical skills

Advanced Excel

VBA coding

MS Access

Communication skills

Industry experience

Prioritization

Education

Bachelor's degree in finance

Tools

MS Excel

MS Access

Job description

Company Description

Colliers International is a leading commercial real estate services company, providing a full range of services to real estate occupiers, developers and investors on a local, national and international basis. Services include brokerage sales and leasing (landlord and tenant representation), lease administration, real estate management, valuation, consulting, project management, project marketing and research. We provide our services across the core sectors (office, industrial, retail and hotel) as well as many specialised property types.

Job Description

Purpose of position

Perform financial analysis and other analytical work to support our Client Account based in Warsaw. Assist clients in optimizing financial models and bringing expertise and innovation.

Essential Responsibilities:

• Utilize and improve highly-customized financial models to analyze occupancy alternatives;
• Optimize client's real estate strategy by providing customized analysis to better illustrate different real estate scenarios;
• Provide active engagement in regular meetings with the client and client's customers in reviewing and advising alternatives;
• Client-facing, presentations of financial models, etc.;
• Ongoing communication with Client and Account team;
• Review of lease documents for inputs in financial models;
• Active work within the client's lease database;
• Possess an ability to work in a project-based team environment with continuous cooperation and interaction among the various team members on a daily basis.

Qualifications:

• BA or higher in finance or related areas;
• Exceptional analytical skills;
• Expertise with MS Excel, including advanced functions such as lookup, index, and sum product arrays;
• Moderate VBA coding experience (beyond recording of macros);
• Proficiency with other Microsoft Office products, including Access;
• Strong written and verbal communication skills;
• Experience in consulting, real estate, capital markets or banking industries;
• Proactive, ability to prioritize and multi-task.

Preferred:

• Experience in capital markets, including discounted cash flow / financial projections, asset reposition strategies, market analysis, risk evaluation and debt / capital structures;
• Relationships within the commercial real estate finance industry;
• Ability to explain complex financial problems to someone without financial or RE background.

What we offer:

• Hybrid work model(Warsaw office);
• International environment, working in English;
• Private healthcare with rehabilitation, 6 additional days of leave yearly for parents, cafeteria programme and other benefits;
• Internal training program;
• Job in a company that cares about the sustainable development of the organization;
• Working in a company with the titles: Best Employer 2017 and 2019 awarded by Kincentric (formerly AON) and Investor in Human Capital 2019, 2021-2025.