Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support data migration to NetSuite using Power Query for automated data processes.
- Company: Join a diverse and inclusive team at FitFlop, a leader in innovative finance solutions.
- Benefits: Enjoy flexible working hours, generous holiday, and a birthday day off!
- Why this job: Make a real impact on financial data transformation while developing your skills.
- Qualifications: Advanced Excel and Power Query skills required; experience with data migration is a plus.
- Other info: Hybrid work model with opportunities for career development and wellbeing support.
The predicted salary is between 40000 - 50000 £ per year.
Please note this is a Fixed Term Contract until 31st August 2026. We are seeking a highly skilled Power Query Finance Data Analyst to support the migration of financial and operational data into our new ERP system, NetSuite, on a fixed term contract basis. This role is critical in designing and delivering automated, scalable data cleansing and transformation processes, with Excel Power Query as the core toolset. The successful candidate will be responsible for building structured, repeatable data pipelines that ensure high data quality, auditability, and efficiency throughout the migration lifecycle. You will work closely with Finance, IT, and Business stakeholders to translate data requirements into robust transformation logic, enabling accurate and controlled data migration into NetSuite.
The Responsibilities:
- Collaborate with cross-functional teams to define data requirements, structures, and mapping logic for NetSuite migration.
- Design, develop, and maintain Power Query-based ETL processes for:
- Data extraction from multiple sources (legacy systems, databases, Excel, SharePoint).
- Automated data cleansing and standardisation.
- Transformation and enrichment aligned with NetSuite data structures.
- Build reusable and scalable Power Query solutions to automate data preparation for CSV imports into NetSuite.
- Chart of Accounts.
- Segments (Departments, Classes, Locations, Custom Segments).
- Master data and transactional structures.
- Validation checks.
- Reconciliation processes.
- Exception reporting.
- Data mapping files.
- Transformation logic.
- Data quality rules.
- Migration procedures.
- Trial loads.
- UAT validation.
- Issue resolution and data correction loops.
The Person:
- Advanced Excel expertise with strong Power Query (M language) skills — this is a core requirement.
- Proven experience in data migration, data transformation, or ETL-focused roles, ideally within ERP implementations.
- Demonstrated experience in building automated data cleansing and transformation pipelines.
- Strong understanding of data structures in ERP systems, preferably NetSuite.
- Experience with CSV-based data imports and migration frameworks.
- Solid understanding of finance and accounting processes (e.g., GL, AP, AR, P&L structures).
- Strong analytical mindset with exceptional attention to detail and data quality.
- Ability to troubleshoot complex data issues and implement structured solutions.
- Excellent communication skills, with the ability to translate technical data concepts into business language.
- Experience working with large datasets across multiple sources.
- Knowledge of data governance and best practices in data management.
- Experience with NetSuite is essential, particularly data migration and CSV imports.
- Experience with MS Dynamics Navision, databases, Power BI, Tableau or data models is advantageous.
The Benefits:
- Product Allowance
- Hybrid and flexible working hours (3 days per week in the office)
- Summer Fridays (6 ½ days in July and August on Fridays)
- A day off for your Birthday
- 25 days holiday + Bank Holidays
- Work from anywhere for 2 weeks
- Workplace Nursery (salary sacrifice scheme to save money on your nursery fees)
- Wellbeing Program – Retail Trust, Sanctus Coaching and Calm App
- Career development allowance (personal allowance to use on career development)
- Private health care and or dental care (provided by AXA and DenPlan)
- Socials organised by Wellbeing and Feel Good group
Equal Opportunities:
FitFlop is an equal opportunities employer. We are committed to creating a diverse and inclusive workplace where everyone feels valued, respected, and supported. We welcome applications from people of all backgrounds, regardless of age, gender identity, sexual orientation, disability, neurodivergence, ethnicity, religion or belief, or any other characteristic protected by law. We actively encourage neurodivergent candidates and individuals with disabilities to apply. If you require any reasonable adjustments during the application or interview process, please let us know. We are committed to providing an accessible and supportive recruitment experience.
Finance Data Analyst employer: FitFlop
Contact Detail:
FitFlop Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Finance Data Analyst
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance and data analysis fields. You never know who might have a lead on a job or can refer you directly to hiring managers.
✨Tip Number 2
Prepare for interviews by practising common questions related to data migration and Power Query. We recommend using real-life examples from your experience to showcase your skills and problem-solving abilities.
✨Tip Number 3
Don’t forget to follow up after interviews! A quick thank-you email can leave a lasting impression and show your enthusiasm for the role. Plus, it keeps you on their radar.
✨Tip Number 4
Apply through our website for the best chance of landing that Finance Data Analyst role. We love seeing candidates who take the initiative to connect with us directly!
We think you need these skills to ace Finance Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your advanced Excel and Power Query skills. We want to see how your experience aligns with the data migration and transformation processes mentioned in the job description.
Showcase Relevant Experience: When writing your application, focus on your previous roles related to data migration and ETL processes. Share specific examples of how you've built automated data pipelines or worked with ERP systems like NetSuite.
Be Clear and Concise: Keep your application straightforward and to the point. Use clear language to explain your technical skills and how they relate to the role. We appreciate a well-structured application that’s easy to read!
Apply Through Our Website: Don’t forget to submit your application through our careers page! It’s the best way for us to receive your details and ensures you’re considered for this exciting opportunity.
How to prepare for a job interview at FitFlop
✨Master Power Query
Since this role heavily relies on Power Query, make sure you brush up on your skills. Familiarise yourself with the M language and practice building data transformation pipelines. Being able to demonstrate your expertise in a practical way during the interview will set you apart.
✨Know Your Data Structures
Understand the data structures relevant to ERP systems, especially NetSuite. Be prepared to discuss how you would approach data mapping and transformation logic. Showing that you can translate complex data requirements into actionable steps will impress the interviewers.
✨Showcase Your Analytical Skills
Highlight your analytical mindset by discussing past experiences where you tackled complex data issues. Prepare examples of how you ensured data integrity and quality in previous roles. This will demonstrate your attention to detail and problem-solving abilities.
✨Communicate Effectively
Practice explaining technical concepts in simple terms. The ability to communicate effectively with both technical and non-technical stakeholders is crucial. Think of examples where you've successfully bridged the gap between data and business needs, as this will resonate well with the interview panel.