Key skills
ERPETLTableauBIPower BI
About this role
Role Overview
- 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