Overview
We are seeking a highly skilled Data Analyst to join our dynamic team. The ideal candidate will be responsible for interpreting complex data sets to inform strategic decision-making and optimise business processes. This role offers an excellent opportunity to work with cutting-edge tools and methodologies, contributing significantly to organisational growth and efficiency. The successful applicant will possess strong analytical capabilities, technical expertise, and a keen eye for detail, ensuring data integrity and actionable insights across various projects.
RThe Data Analyst is responsible for collecting, analysing, and interpreting operational and business data to improve efficiency, reduce costs, and support strategic decision-making. The role focuses on analysing container movements, fleet performance, delivery schedules, customer service metrics, fuel consumption, and financial performance to optimise haulage operations.
Key Duties and Responsibilities
- Collect, clean, validate, and analyse operational data from transport management systems (TMS), GPS tracking systems, ERP systems, and spreadsheets.
- Develop dashboards and reports to monitor key operational and financial performance indicators.
- Analyse container turnaround times, delivery performance, vehicle utilisation, and route efficiency.
- Monitor fleet productivity, driver performance, and fuel consumption.
- Identify trends, bottlenecks, and opportunities to improve operational efficiency.
- Support transport planners with route optimisation and resource allocation analysis.
- Produce daily, weekly, and monthly operational performance reports.
- Analyse customer service metrics, including delivery accuracy and on-time performance.
- Evaluate haulage costs and identify opportunities for cost reduction.
- Monitor Key Performance Indicators (KPIs) such as:
- On-Time Delivery (OTD)
- Vehicle Utilisation
- Fleet Availability
- Fuel Efficiency
- Container Dwell Time
- Driver Productivity
- Empty Running Percentage
- Perform ad hoc analysis to support management decision-making.
- Collaborate with operations, finance, customer service, warehouse, and commercial teams.
- Ensure data accuracy and maintain data governance standards.
- Identify opportunities for automation of reports and business processes.
- Prepare presentations and management reports highlighting key business insights.
- Support forecasting and budgeting activities using historical operational data.
- Assist in developing predictive models for demand planning and fleet utilisation.
- Ensure compliance with company policies and data protection regulations.
Required Skills
Technical Skills
- Strong Microsoft Excel skills (Pivot Tables, Power Query, Power Pivot, advanced formulas).
- Proficiency in SQL for data extraction and querying.
- Experience with Microsoft Power BI or Tableau.
- Knowledge of database management principles.
- Experience with Transport Management Systems (TMS).
- Understanding of ERP systems (e.g., SAP, Oracle, Microsoft Dynamics).
- Basic knowledge of Python or R for data analysis (desirable).
- Data visualisation skills.
- Statistical analysis and forecasting techniques.
- Knowledge of KPI development and performance reporting.
Operational Knowledge
- Container haulage operations.
- Fleet management.
- Transport planning.
- Port operations.
- Container tracking processes.
- Route optimisation.
- Fuel management.
- Logistics and supply chain operations.
Soft Skills
- Excellent analytical and problem-solving skills.
- Strong attention to detail.
- Critical thinking.
- Effective communication and presentation skills.
- Ability to explain complex data to non-technical stakeholders.
- Time management.
- Organisational skills.
- Teamwork and collaboration.
- Ability to work under pressure and meet deadlines.
- Continuous improvement mindset.
Experience
Essential
- 2–5 years' experience as a Data Analyst, Business Analyst, or Operations Analyst.
- Experience working within transport, logistics, shipping, freight forwarding, or supply chain environments.
- Experience creating dashboards and management reports.
- Experience analysing operational and financial data.
- Experience using SQL and Power BI.
Desirable
- Experience in container haulage operations.
- Experience with GPS fleet management systems.
- Experience with transport management software.
- Experience in predictive analytics.
- Experience in process improvement projects.
OR
Qualifications
- Master's degree in Data Analytics, Business Analytics, or Supply Chain Management.
- Microsoft Certified: Power BI Data Analyst Associate.
- Google Data Analytics Professional Certificate.
- Tableau Desktop Specialist or Tableau Certified Data Analyst.
- SQL certification.
- Lean Six Sigma Green Belt.
- Professional certification in logistics or supply chain management (e.g., CILT, APICS/ASCM).
Key Performance Indicators (KPIs)
- Report accuracy.
- Dashboard delivery timeliness.
- Data quality and integrity.
- Reduction in operational costs through data-driven insights.
- Fleet utilisation rate.
- On-time delivery performance.
- Fuel efficiency improvements.
- Container turnaround time.
- Customer satisfaction metrics.
- Report automation rate.
- Decision-support effectiveness.
Process improvement initiatives implemented
Pay: £38,420.00-£40,000.00 per year
Education:
Location:
- Dagenham RM9 6FF (preferred)
Work Location: In person
