Data Transformation Analyst - 6 Month FTC (Remote)

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.

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

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