APAM Seeks Data Analyst

The Company:
APAM Ltd seeks an Analyst to join their growing Investor Reporting team. The specialist UK property
asset management firm, which focuses on enhancing value in real estate investments across the UK,
currently has a multi-disciplined team of 40 professionals, with offices in London and Manchester.
The Role:
The role is broad however key responsibilities will include client reporting, performance
measurement, responding to investor queries and understanding value calculations. There will be
many opportunities to take on projects and process improvements. Specific responsibilities include
but are not limited to:
• Collect, collate, and upload information to data warehouse
• Verify commentary received from project teams against data as well as undertaking detailed
analysis of asset management information
• Developing and modifying excel reports using excel add in from database
• Importing, validating and modelling data
• Identify gaps in data and uniformity issues
• Construct tables and graphs to show trends, upcoming events etc
• Writing commentary in reports to explain trends and differences to budget
• Analysis of actual performance to underwritingTechnical Skills Required:
Technical Skills Required:
The successful candidate will have experience linking sets of data together using excel, and be
comfortable with advanced use of Excel including but not limited to the following:
• IF Functions
• Lookup Functions
• INDEX/MATCH Functions
• Pivot Tables
Candidate’s Qualities:
• Ability to work in a fast paced team environment with strict reporting deadlines
• Become the subject matter authority on the applicable data fields
• Ability to learn and apply concepts quickly
• Ability to work independently
• Strong verbal and written communication skills
Previous experience with VBA, Cash Flow Models, and financial statements within the Property/Real
Estate Industry would be desirable but not essential.
This is an opportunity to join an expanding Company in their London office which offers a
competitive salary and bonus package for successful candidates.
To apply for this position please email your CV to: admin@apamuk.com

Scroll to Top