Full job descriptionFreelance Business Analyst (Real Estate Fund Accounting, Yardi)
We’re looking for a freelance Business Analyst with real estate fund accounting experience to join a global digital consultancy, working with a global investment manager’s real estate business.
The team is moving finance data from Yardi, Lucanet and Excel onto a new Snowflake platform. You’ll make sure the new data is right, reconcile it against the old, and get it through testing.
The role
*Start: Monday 23rd November
*Length: Until Monday 31st May 2027 (likely extension)
*IR35: Inside IR35 (umbrella only, no Ltd company or sole trader)
*Location: Farringdon, London
*Work set-up: Hybrid (2 days in-house per week mandatory, rest remote)
*Days: Full-time, 5 days a week
*Day rate: £600 per day
What you’ll do
*Plan and run UAT on financial data from the new Snowflake platform, including test cases, evidence, defect tracking and retesting
*Reconcile P&L, balance sheet, trial balance and NAV between old and new, and investigate breaks
*Analyse existing Excel models and Yardi and Lucanet inputs, document the data requirements and logic, and map them to the new data
*Coordinate testing and fixes across fund, finance and tech teams, with the fund teams signing off
*Report regularly on testing and reconciliation progress
*If there’s time, help document future-state processes and the operating model
What you’ll need
*Hands-on Yardi experience (essential)
*Real estate fund accounting experience (essential): property-level and fund-level accounting, NAV, trial balance
*Hands-on finance data reconciliation, variance investigation and UAT
*Advanced Excel, including complex financial models
*Clear at documenting data mappings, model logic and processes
*Strong stakeholder management across finance, fund teams and tech
*Snowflake or similar is a bonus. No SQL or Python needed.
How to apply
Send your CV and tell us which Yardi modules you’ve used and for which real estate fund or manager.
*Rates depend on experience and client requirements