Freelance BA

Job Description

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 TPBN1_UKTJ