Data Transformation Analyst - 6 Month FTC Remote

About the RoleFULLY 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.

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