Data Transformation Analyst - 6 Month FTC Remote

About the Role FULLY REMOTE  - 6 Month FTCMy 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.