Vector Resourcing
Excel/Power Query Consultant
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Our client is looking for a Excel/Power Query Consultant to move merchandising data from Excel and BusinessObjects-based processes into Microsoft Fabric.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
You will define the existing data, transform it using Power Query and work with Merchandising, IT and Data teams to validate the migration.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
This role is focused on delivering accurate, usable data against a tight implementation deadline.
Responsibilities
- Map the merchandising data currently held in Excel and accessed through BusinessObjects.
- Work with merchandising users to define measures, calculations, dependencies and reporting requirements.
- Extract, cleanse and transform data using Excel, Power Query and SQL.
- Prepare data for migration into the Microsoft Fabric environment.
- Identify data-quality issues, inconsistent definitions and manual processes that could affect the migration.
- Reconcile migrated data against existing reports, spreadsheets and agreed business rules.
- Translate merchandising concepts, including margin and product performance measures, into clear data requirements.
- Coordinate migration activity with IT and Data teams, resolving discrepancies before sign-off.
- Document data sources, transformation logic, definitions and validation results.
- Deliver agreed migration work within the client’s implementation timetable.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location