This range is provided by Sanderson. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range
Direct message the job poster from Sanderson
Location: Central London HQ – Hybrid Model – 2 days p/w on site
Duration: Initial 2 months – extensions highly likely
We are looking for a Reconciliation Analyst to help with a migration from Oracle Hyperion to OneStream. You will need to be ACCA, ACA, CA, CIMA, CIPFA qualified Accountant with experience of data reconciliations to be suitable for this role.
Experience Required:
* Proven experience in financial data migration and reconciliation
* Experience with OneStream or Oracle Hyperion Financial Management
* Strong analytical and problem-solving skills with a meticulous attention to detail.
* Excellent understanding of financial consolidation processes and principles.
* Proficiency in creating and utilizing VBA macros for data manipulation and automation within Excel.
* Strong Microsoft Excel skills, including the ability to create and utilize advanced formulae.
* Experience with data analysis and the ability to identify and resolve data quality issues.
Responsibilities:
* Data Migration and Reconciliation: Lead and execute the migration and reconciliation of financial data, ensuring data integrity and accuracy.
* Discrepancy Resolution: Collaborate closely with stakeholders to understand, investigate, and resolve data discrepancies identified.
* OneStream Configuration: Design, create, and maintain OneStream mapping/transformation rules and metadata/dimension members to facilitate accurate data migration and address data quality issues.
* OneStream Application Analysis: Analyse existing OneStream application rules to understand data calculation logic and propose necessary changes or enhancements to ensure accurate financial reporting.
* OneStream Process Development: Create and implement steps within OneStream workflows to optimize data processing and reporting.
* Automation and Efficiency: Develop and implement VBA macros to automate data migration and reconciliation activities, including the transformation of legacy system journals into OneStream-compatible formats.
* Reporting and Analysis: Create OneStream Excel add-in formulae to efficiently extract and analyse data from OneStream for reconciliation and reporting purposes.
Seniority level
* Seniority level
Mid-Senior level
Employment type
* Employment type
Contract
Job function
* Job function
Accounting/Auditing, Analyst, and Finance
Referrals increase your chances of interviewing at Sanderson by 2x
Get notified about new Reconciliation Analyst jobs in London Area, United Kingdom.
Investment Administrator - Reconciliations
Interim Finance Reconciliations Accountant
London, England, United Kingdom 14 hours ago
Redhill, England, United Kingdom 3 weeks ago
London, England, United Kingdom 1 week ago
City Of London, England, United Kingdom £400.00-£450.00 2 weeks ago
London, England, United Kingdom 2 months ago
London, England, United Kingdom 14 hours ago
Reigate, England, United Kingdom 2 weeks ago
London, England, United Kingdom 3 weeks ago
Head of Reconciliations and Reporting - Investment Operations
FCC Transaction Monitoring & Screening Operations Analyst
London, England, United Kingdom 4 days ago
Trade Operations Analyst – Exchange Clearing
Greater London, England, United Kingdom 2 weeks ago
Business Analyst - SME (Finance and Treasury)
London, England, United Kingdom 1 month ago
Transport and Trade Operations Analyst, EMEA
London, England, United Kingdom 1 week ago
City Of London, England, United Kingdom £65,000.00-£70,000.00 4 days ago
City Of London, England, United Kingdom 1 week ago
Finance Reporting Lead Analyst, Vice President
London, England, United Kingdom 1 week ago
Graduate Business Modelling Analyst - London - Up to £40,000 + amazing bonus/benefits package
London, England, United Kingdom £70,000.00-£85,000.00 18 hours ago
London, England, United Kingdom 1 week ago
Transaction Reporting Business Analyst-London
Financial Crime Compliance Operations Analyst (12-month Fixed-Term-Contract)
Greater London, England, United Kingdom 14 hours ago
Financial Crime Analyst - Detection Team
London, England, United Kingdom 2 weeks ago
Business Analyst (Trade & Transaction Reporting)
London, England, United Kingdom 3 weeks ago
Operations Analyst - Investment manager - Flexible working
Data Analyst / Data Operations Analyst - Asset Management / Investment Management
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr