Data Analyst

Square One Resources; London; On-site; GBP 125,000 - 150,000; Full time

Job summary

A leading recruitment agency in London is seeking a detail-oriented Data Analyst to support data cleansing and reconciliation in a finance function. The ideal candidate should be proficient in Advanced Excel and have experience with Oracle ERP financial data. Responsibilities include validating data, designing Excel templates, and collaborating with finance teams to resolve discrepancies. This position offers a salary of £300 outside IR35.

Qualifications

• Advanced user of Excel required for data manipulation and reporting.
• Experience with Oracle ERP systems for financial data management.
• Strong attention to detail necessary for data cleansing and reconciliation.

Responsibilities

• Cleanse, transform, and validate financial data from Oracle ERP.
• Perform detailed reconciliation of data between systems.
• Design and maintain Excel templates for data tasks.
• Collaborate with finance teams to resolve data discrepancies.
• Document data processes and reconciliation procedures.
• Implement data quality checks on financial data.
• Support ad-hoc reporting requests using Excel and Oracle ERP.

Skills

Advanced Excel skills

Data validation and automation (macros/VBA preferred)

Experience working with Oracle ERP financial data extraction, analysis, or reconciliation

Strong understanding of financial data structures

High attention to detail

Problem-solving abilities

Ability to work independently

Job description

Job Title: Data Analyst
Location: London
Salary/Rate: £300 outside IR35
Start Date: September

An exciting opportunity for a detail-focused Data Analyst to support data cleansing, reconciliation, and template creation within a finance function. The ideal candidate will be an Advanced Excel user with experience working with Oracle ERP financial data or similar ERP systems. Familiarity with Oracle ERP and its financial data structures will be a strong advantage.

Key Responsibilities:

• Cleanse, transform, and validate financial data extracted from Oracle ERP and other sources
• Perform detailed reconciliation of data between Oracle ERP and other finance systems or spreadsheets
• Design, develop, and maintain Excel-based templates for data entry, reconciliation, and financial reporting
• Collaborate closely with finance teams to identify and resolve data discrepancies within Oracle ERP datasets
• Assist in documenting data processes, reconciliation procedures, and template usage guidelines
• Implement data quality checks and controls to ensure accuracy and completeness of Oracle ERP financial data
• Support ad-hoc reporting and analysis requests leveraging Oracle ERP and Excel data

Essential Skills & Experience:

• Advanced Excel skills
• Data validation and automation (macros/VBA preferred)
• Experience working with Oracle ERP financial data extraction, analysis, or reconciliation
• Strong understanding of financial data structures such as GL, AR/AP, subledgers, trial balances
• High attention to detail with strong problem-solving abilities
• Ability to work independently and manage multiple priorities

Desirable Skills:

• Experience designing templates or automated workflows for Oracle ERP data
• Basic knowledge of SQL or scripting for data manipulation
• Familiarity with accounting principles and finance operations

If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.

Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.