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

• Perform data mapping and transformation logic design, ensuring alignment with:

  • Chart of Accounts

  • Segments (Departments, Classes, Locations, Custom Segments)

  • Master data and transactional structures

• Ensure data integrity, consistency, and completeness through:

  • Validation checks

  • Reconciliation processes

  • Exception reporting

• Develop and maintain comprehensive documentation, including:

  • Data mapping files

  • Transformation logic

  • Data quality rules

  • Migration procedures

• Support data migration cycles, including:

  • Trial loads

  • UAT validation

  • Issue resolution and data correction loops

• Identify opportunities to improve and automate data processes, reducing manual intervention and increasing efficiency.

• Work closely with Finance teams to ensure data aligns with accounting and reporting requirements.

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

• ➡️ Check out our careers page to learn more!

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.