Freelance BA

Freelance 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