Data Transformation Analyst - Remote
Job Description
The information below covers the role requirements, expected candidate experience, and accompanying qualifications.
About the RoleFULLY REMOTE 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. xkybehq