Account Financial Analyst | EMEA

Colliers International EMEA; Warszawa; On-site; PLN 120,000 - 180,000; Full time

Benefits offered by this job

Private healthcare with rehabilitation

6 additional days of leave yearly for

Cafeteria programme

Internal training program

Best Employer awards

Job summary

Colliers International is seeking a Finance Analyst to perform advanced financial modeling and analysis to support a Warsaw-based client account. You will optimize real estate strategies, participate in client meetings, and present financial insights to stakeholders.

The role requires strong Excel skills, VBA experience, and a background in finance or related fields, with experience in consulting, real estate, capital markets, or banking. Collaboration in a multi-disciplinary team is essential.

Qualifications

• BA or higher in finance or related areas.
• Exceptional analytical skills.
• Proficiency with MS Excel, including advanced functions such as lookup, index, and sum product arrays.
• Moderate VBA coding experience (beyond recording of macros).
• Strong written and verbal communication skills.
• Experience in consulting, real estate, capital markets or banking industries.
• Proactive, ability 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 to 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.
• Work in a project-based team environment with daily cooperation among team members.

Education

BA or higher in finance or related areas

Tools

MS Excel

VBA

Access

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

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