Where the role sits
Commercial advice is only as good as the data it sits on. Before we can tell a client where their margin is leaking, where capital is trapped, or whether an acquisition assumption holds, we have to produce a version of their numbers that actually reconciles. Most of the time, client data arrives across multiple systems, in multiple formats, with overlapping definitions and inconsistent totals.
The Junior Data Coordinator owns the work of turning that material into a clean, reliable analytical base.
Core responsibilities
* Consolidating client data from accounting exports, CRM systems, pricing files, sales reports, and spreadsheets into unified working datasets
* Reconciling the same figure across sources and documenting why the numbers differ
* Building standard cuts that analysts can use straight away: realised price by customer, margin by product, contribution by channel, cohort performance, fixed versus variable cost splits
* Setting up file structures, naming conventions, and version control so engagement data is always findable
* Keeping a transformation log so any number in a client deliverable can be traced back to its source
* Preparing data for senior review meetings and adjusting in response to new requests, often under time pressure
What we need from you
Essential
* Strong spreadsheet skills. You are comfortable with lookups, pivot tables, conditional logic, basic array functions, and keeping large files organised. Excel or Google Sheets, either is fine.
* Comfort with structured data. CSVs, exports, and tables do not intimidate you. You can spot a formatting issue, a duplicate row, or a broken total.
* Accuracy as a default setting. You check your own work before handing it over. You do not round away problems to finish faster.
* Clear written English for documentation, file notes, and internal handovers.
* Organised by habit. Your folder structures make sense to other people, not just to you.
Helpful but not required
* Basic SQL. If you do not have it, you will need to pick it up in your first few months, and we will support that.
* Exposure to Power Query, Python (pandas), or another data-cleaning tool
* Any experience with accounting software, ERP systems, or CRM exports (Xero, QuickBooks, NetSuite, HubSpot, Salesforce, and similar all count)
* A degree or course of study in finance, accounting, economics, data, operations, or a related field
* Personal or academic projects involving data cleaning, analysis, or reporting
What we are not looking for
You do not need to call yourself a data analyst. You do not need a portfolio of dashboards. You do not need years of experience. If you have solid spreadsheet fundamentals, a careful working style, and you want to build real data skills on live commercial engagements, we want to hear from you.
What you will get out of the role
* Direct exposure to how commercial decisions are actually built from the data up
* A defined route into analyst work for those who prove the fundamentals
* Training and feedback from senior advisors, not from a handbook
* A team where accurate, methodical work is the thing that gets respected