Data Transformation Analyst – 6 Month FTC (Remote)

Davies Group; Liverpool; Remote; GBP 40,000 - 60,000; Full time

Job summary

A leading data solutions provider is seeking a Data Transformation Analyst to work fully remote on a 6-month fixed-term contract. The successful candidate will design data models using Power BI and create actionable insights through high-quality reporting solutions. Responsibilities include building dashboards, collaborating with stakeholders, and ensuring data consistency. Strong expertise in Power BI and Excel is essential for this role.

Qualifications

• Advanced data modelling with Power BI and proficiency in DAX.
• Strong Excel skills including advanced formulas and dashboard creation.
• Ability to cleanse and reshape data using Power Query.

Responsibilities

• Design and maintain data models for large datasets in Power BI.
• Build interactive dashboards and reports that are user-friendly.
• Collaborate with stakeholders to deliver practical solutions.

Skills

Power BI Expertise

Excel Mastery

Power Query

Strong communication skills

Tools

Power BI

Excel

Job description

Overview

FULLY REMOTE – 6 Month FTC

My client is looking for a Data Transformation Analyst who thrives on turning large, complex datasets into clear, actionable insights. This role is focused on building robust data models and delivering high-quality reporting solutions using Power BI and Excel. If you’re passionate about data modelling and creating scalable solutions that drive business decisions, this is the role for you.

Responsibilities

• Design and maintain data models for large datasets in Power BI.
• Build interactive dashboards and reports that are accurate, performant, and user-friendly.
• Use Excel for advanced analysis, reporting, and visualization.
• Collaborate with stakeholders to understand requirements and deliver practical solutions.
• Ensure data quality and consistency across reporting pipelines.

Qualifications

• Power BI Expertise:
  • Advanced data modelling (STAR schema, relationships, filter direction).
  • Strong DAX skills for measures and calculations.
  • Experience optimizing performance for large datasets.
• Excel Mastery:
  • Advanced formulas (SUMIFS, COUNTIFS, text functions).
  • Dashboard creation and data visualization.
  • VBA knowledge is a bonus.
• Power Query:
  • Ability to cleanse and reshape data for reporting.
• Strong communication skills to explain technical concepts clearly to non-technical audiences.