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.
Requirements
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.
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.
Tech Stack
ERP
ETL
Tableau
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