Data Transformation Analyst

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

Job summary

A leading data solutions firm in the UK seeks a Data Transformation Analyst for a fully remote, 6-month contract. The role involves designing data models in Power BI, building interactive reports, and conducting advanced analysis using Excel. Ideal candidates will have strong skills in data modelling and visualization, alongside excellent communication skills for collaborating with stakeholders. This is a unique opportunity to influence business decisions through data-driven insights.

Qualifications

• Expertise in Power BI, including advanced data modelling and DAX skills.
• Proficiency in Excel, including advanced formulas and dashboard creation.
• Ability to cleanse and reshape data for reporting.

Responsibilities

• Design and maintain data models for large datasets in Power BI.
• Build interactive dashboards and reports.
• Collaborate with stakeholders for practical solutions.

Skills

Power BI Expertise

Advanced Excel Skills

Strong communication skills

Tools

Excel

Power BI

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