Data Transformation Analyst – 6 Month FTC (Remote)

Davies Resourcing; Liverpool; Remote; GBP 40,000 - 55,000; Full time

Job summary

A dynamic consultancy is looking for a Data Transformation Analyst for a fully remote 6-month FTC. This role involves turning large datasets into actionable insights, focusing on building data models and delivering reporting solutions using Power BI and Excel. The ideal candidate has strong DAX and Excel skills, experience with data visualization, and the ability to communicate technical concepts effectively. This position allows for significant impact on data-driven business decisions.

Qualifications

• Advanced data modelling skills using Power BI.
• Strong DAX skills for various calculations.
• Experience in optimizing reporting performance.

Responsibilities

• Design and maintain data models for large datasets.
• Build interactive dashboards and reports.
• Collaborate with stakeholders to understand company needs.

Skills

Power BI Expertise

Strong DAX skills

Performance optimization for large datasets

Power Query knowledge

Excel Mastery

Dashboard creation

VBA knowledge

Strong communication skills

Tools

Power BI

Excel

Job description

About the Role

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.

What You’ll Do

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

What We’re Looking For

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