REPORTING ANALYST (M/F)
DO Recruitment Advisors are recruiting a Reporting Analyst to join the reporting team of a leading Real Estate company in Luxembourg. Within the finance department, this team is responsible for the reporting linked to external and internal reporting requirements.
The ideal candidate will have 2-3 years of experience in a similar role, such as audit or advisory, preferably in Real Estate.
·Prepare quarterly financial covenant calculations and management reports for submission to banks;
·Build efficient monitoring process to track bank compliance with financing covenants, spot trends and provide scenario analysis;
·Coordination with property managers, asset managers, other corporate teams and facility and security agents;
·Maintain an overview of cash movements throughout the quarter, ensuring cash accounts are sufficiently topped up for interest payments, and more importantly cash is then moved correctly once interest has been settled;
·Quarterly interest calculations and reconciliations with the agents' interest notices;
·Maintaining an overview of each portfolio and allocated loan amounts, tracking repayments through disposals and drawdowns;
·Assist the team in looking for efficiency strategies and developing new processes through our technology team and through more efficient use of our ERP system ('Yardi').
Internal and External Reporting:
·Rebuild process based on Yardi;
·Prepare Monthly Cash Balance Report (from Yardi);
·Prepare Legal Fee Report, Audit & Compliance Report, Material Banker Fees;
·Prepare other periodic or ad hoc reports required by other entities;
·Ensure distributions are in line with the tax mechanics, work closely with tax team and support management in tracking the amounts;
·Assist the FP&A team in building up the budget reports and Board books;
·Maintain communication lines between departments ensuring any cross over topics are fully communicated and all are aware (for ex. Excess cash following interest payments, amounts are communicated to the accounting teams).
THE CANDIDATE PROFILE:
·University degree in Accounting/Finance (CFA, ACCA is an asset);
·Minimum 2-3 years of work experience in a similar field, such as audit or advisory;
·Experience with real estate finance and bank reporting is a strong plus;
·Proficiency with MS Office standard applications and Power BI tools, Yardi experience a plus;
·Fluent in English is mandatory. French, German, Spanish or Dutch is a plus;
·Dynamic personality with a can-do and hands on attitude, and strong desire to learn;
·Solution oriented approach/ problem-solving attitude;
·High sense of organization;
·Detail orientation with also the ability to see the big picture;
·Ability to handle and prioritize a wide variety of situations and challenges;
·Ability to work independently but also be an excellent team player;
·Curiousity and enthusiasm for business related matters;
·Manages stress well and uses it as a positive motivator;
·High energy level; exhibits positive attitude and flexibility;
·Sense of ownership, accountability and urgency;
·Excellent communication skills (written and verbal);
·Ability to deal efficiently with people at different levels of hierarchy.
Our client is a large European Real Estate company.
At the final stages of the recruitment process, our client can ask the successful candidate to provide supporting documentation such as, for example, copies of diplomas or proof of previous jobs, and a standard criminal record check may also be requested.