Finance Data Migration Analyst - Remote & Power BI Ready

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

Job summary

A leading data consultancy is seeking a Data Analyst for a remote, outside IR35 contract to support a finance reporting migration program. The role involves analyzing legacy reports and validating data while working closely with stakeholders. Ideal candidates should have strong SQL and advanced Excel skills, and experience in data migration and reporting transformation. This hands-on role requires problem-solving abilities and the capability to manage workload in a fast-paced environment.

Qualifications

• 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.

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

Strong SQL

Advanced Excel

Data migration experience

Reporting transformation

Problem-solving mindset

Data profiling and validation

Tools

Power BI

SQL

Excel

Job description

A leading data consultancy is seeking a Data Analyst for a remote, outside IR35 contract to support a finance reporting migration program. The role involves analyzing legacy reports and validating data while working closely with stakeholders. Ideal candidates should have strong SQL and advanced Excel skills, and experience in data migration and reporting transformation. This hands-on role requires problem-solving abilities and the capability to manage workload in a fast-paced environment.