Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform complex datasets into actionable insights using Power BI and Excel.
- Company: Join a forward-thinking company that values data-driven decisions.
- Benefits: Fully remote role with flexible working hours and professional growth opportunities.
- Why this job: Make an impact by creating scalable data solutions that drive business success.
- Qualifications: Expertise in Power BI, advanced Excel skills, and strong communication abilities.
- Other info: Perfect for data enthusiasts looking to enhance their analytical skills.
The predicted salary is between 36000 - 60000 £ per year.
Job Description
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.
Data Transformation Analyst - 6 Month FTC (Remote) employer: Davies Talent Solutions
Contact Detail:
Davies Talent Solutions Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Transformation Analyst - 6 Month FTC (Remote)
✨Tip Number 1
Network like a pro! Reach out to people in your industry on LinkedIn or through professional groups. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data models and dashboards. This is your chance to demonstrate your Power BI and Excel expertise in a way that words alone can't.
✨Tip Number 3
Prepare for interviews by practising common questions related to data transformation and reporting. We recommend using the STAR method to structure your answers, so you can clearly show how you've tackled challenges in the past.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Transformation Analyst - 6 Month FTC (Remote)
Some tips for your application 🫡
Show Off Your Data Skills: Make sure to highlight your experience with Power BI and Excel in your application. We want to see how you've tackled complex datasets and created actionable insights, so don’t hold back on those examples!
Tailor Your Application: Take a moment to customise your CV and cover letter for this role. We love seeing how your skills align with what we’re looking for, especially in data modelling and reporting solutions.
Keep It Clear and Concise: When writing your application, clarity is key! Use straightforward language to explain your experience and avoid jargon unless it’s necessary. We want to understand your journey without getting lost in technical terms.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Davies Talent Solutions
✨Master the Tools
Make sure you brush up on your Power BI and Excel skills before the interview. Be ready to discuss your experience with advanced data modelling, DAX calculations, and any dashboards you've created. Practising these tools will help you speak confidently about your capabilities.
✨Know Your Data
Familiarise yourself with common data transformation techniques and best practices. Be prepared to explain how you would approach building a robust data model or cleansing data for reporting. This shows that you not only understand the tools but also the underlying principles of data management.
✨Communicate Clearly
Since you'll need to explain technical concepts to non-technical stakeholders, practice articulating your thoughts clearly. Use simple language to describe complex ideas, and think of examples where you've successfully communicated data insights in the past.
✨Prepare Questions
Have a few thoughtful questions ready to ask your interviewers. This could be about their current data challenges or how they envision the role contributing to their business decisions. It shows your genuine interest in the position and helps you gauge if it's the right fit for you.
