Data Transformation Analyst - 6 Month FTC (Remote)

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.