Interim Excel Analyst
Posted 3 days ago by Trace – Expert Accountancy Recruitment
£55,000 Per year
Inside
Onsite
London Area, United Kingdom
Summary: The role of Interim Excel Analyst involves utilizing advanced MS Excel skills, particularly in Macro or VBA, to support a Global Asset Manager for a duration of 3-6 months. The position requires working on-site five days a week, focusing on developing Excel models and reconciling financial data. The ideal candidate will have a strong understanding of accounting principles and experience with large data sets. This role emphasizes Excel proficiency over accounting expertise.
Key Responsibilities:
- Develop and maintain robust Excel models to process Trade Blotter data.
- Apply accounting logic to generate DR/CR journal entries from trade data.
- Reconcile trade-related entries with the general ledger.
- Generate monthly Trial Balance reports for management review.
- Collaborate with the accounting team to ensure proper data mapping between Excel files and the accounting system.
- Assist in the preparation of financial statements and reports as required.
- Support data quality checks and implement error-handling procedures within Excel files.
Key Skills:
- Strong proficiency in Microsoft Excel, including advanced formulas (e.g. VLOOKUP, INDEX/MATCH, SUMIFS).
- Pivot tables and data transformation.
- Basic VBA (optional but advantageous).
- Understanding of accounting principles, particularly double-entry bookkeeping.
- Experience working with large data sets and reconciling financial data.
- Excellent attention to detail and organisational skills.
- Ability to work independently and meet tight deadlines.
Salary (Rate): £55,000.00 yearly
City: London
Country: United Kingdom
Working Arrangements: on-site
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: Other
Do you have advanced MS Excel skills to Macro or VBA level? Are you available on 2 weeks notice or less ? We are partnering with a Global Asset Manager who operate across 16 markets with $250billion of Assets under their management. Based out of stunning city offices, they need an Interim Analyst to join them for 3-6 months to work with the Financial Controller £250 - £280 p/day inside IR35 via Umbrella **Please note this role requires someone in the office 5 days a week and the priority in this role is someone with adavanced MS Excel rather than accounting**
Key Responsibilities:
- Develop and maintain robust Excel models to process Trade Blotter data.
- Apply accounting logic to generate DR/CR journal entries from trade data.
- Reconcile trade-related entries with the general ledger.
- Generate monthly Trial Balance reports for management review.
- Collaborate with the accounting team to ensure proper data mapping between Excel files and the accounting system.
- Assist in the preparation of financial statements and reports as required.
- Support data quality checks and implement error-handling procedures within Excel files.
Required Skills and Qualifications:
- Strong proficiency in Microsoft Excel, including: Advanced formulas (e.g. VLOOKUP, INDEX/MATCH, SUMIFS).
- Pivot tables and data transformation.
- Basic VBA (optional but advantageous).
- Understanding of accounting principles, particularly double-entry bookkeeping.
- Experience working with large data sets and reconciling financial data.
- Excellent attention to detail and organisational skills.
- Ability to work independently and meet tight deadlines.
At Trace, we are committed to fostering an inclusive and diverse workplace and believe that, in any business, it is imperative that all members of staff feel appreciated and respected in their roles. Our job is simply to find the best candidate on the market, regardless of their age, race, religion, disability, gender identity, sexual orientation or any other factor irrelevant to their qualifications and competencies. If you have any further questions regarding accessibility throughout the process, then please get in touch DEIB@tracerecruit.com or call a member of our DEIB Champions team.