Commercial Data Analyst
Job Description
We are looking for a commercially minded Commercial & Operations Data Analyst to help us better understand business performance across a multi-location service business.
What we are looking for
• 2–4 years’ experience in data analysis, business intelligence, commercial analysis or operational reporting
• Advanced Excel skills
• Good Power BI skills
• Working knowledge of SQL
• Strong numerical and analytical ability
• Comfortable working with large datasets
• Able to identify trends, exceptions and underlying drivers
• Strong attention to detail
• Clear written and verbal communication
• Able to explain data to non-technical managers
• Curious and willing to investigate beyond the first explanation
Responsibilities Duties:
You will work with operational, commercial and client data to identify what is happening in the business, what is driving the result, and where management should focus its attention.
You will work closely with Operations and senior management, turning large volumes of data into clear, useful insights.
Key responsibilities
• Analyse revenue, transactions, average transaction value and service mix
• Track actual vs target, MTD, YTD and year-on-year performance
• Analyse staff hours, booked hours, utilisation and productivity
• Review booking patterns by location, day and time
• Analyse cancellations, no-shows, waitlists and missed booking opportunities
• Identify capacity and scheduling patterns that may be affecting performance
• Analyse new clients, returning clients, retention, rebooking and frequency
• Compare performance across locations and identify meaningful variances
• Analyse employee productivity and service performance
• Build and maintain clear Power BI dashboards and management reports
• Reduce manual reporting through better automation
• Reconcile data and identify reporting or data-quality issues
• Support ad-hoc analysis for Operations and senior management.