Data Analyst

North Scout; Remote; GBP 80,000 - 100,000; Full time

Job summary

A leading recruitment firm is in search of a Data Analyst for a major finance data reporting migration project. The role involves analyzing legacy finance reports, validating data accuracy, and enabling teams to produce robust outputs in Power BI. Candidates should possess strong SQL and advanced Excel skills, with experience in data migration and reporting transformation. This is a fully remote role, outside IR35, intended for someone who thrives in a fast-paced environment and enjoys turning legacy data into actionable insights.

Qualifications

• Strong background in SQL and Excel essential for data analysis.
• Experience in data migration and reporting transformations required.
• Ability to clearly document logic and reverse-engineer reporting structures.

Responsibilities

• Analyse legacy finance reports and document business rules.
• Profile and validate data for accuracy and completeness.
• Conduct source-to-target mapping and document data flows.
• Extract and interrogate data using SQL and Excel.
• Collaborate with various teams to deliver outputs.

Skills

Strong SQL

Advanced Excel skills

Experience in data migration

Ability to reverse-engineer reports

Autonomous and delivery-focused

Tools

Power BI

SQL

Excel

Job description

Data Analyst – Finance Data & Reporting Migration

Outside IR35 (£380-480 per day) | 6-month contract | Fully Remote (UK) | Immediate start

North Scout is seeking a Data Analyst to support a major finance reporting migration programme. This hands‑on role focuses on analysing legacy reports, validating data, and enabling reporting teams to rebuild outputs in Power BI.

Responsibilities

• Analyse and reverse‑engineer legacy finance reports to uncover business rules
• Profile and validate data for accuracy and completeness
• Conduct source‑to‑target mapping and document data flows
• Extract and interrogate data using SQL, Excel, and internal systems
• Work with BAs, Engineers, Testing, and Power BI teams to deliver usable outputs
• Support creation of data dictionaries, specs, and process improvements

Skills & Experience – Essential

• Strong SQL and advanced Excel skills
• Experience in data migration, reporting transformation, or data platforms
• Able to reverse‑engineer reports and document logic clearly
• Autonomous, delivery‑focused, and confident liaising with stakeholders

Skills & Experience – Desirable

• Power BI experience
• Finance reporting knowledge
• Experience working alongside BAs or in hybrid BA / DA roles

You’ll need

curiosity, problem‑solving mindset, and ability to manage your workload in a fast‑paced environment.

This is a fully remote, outside IR35 contract for an experienced Data Analyst who enjoys turning legacy reporting into robust, actionable outputs.