Forecasting & Planning Analyst

Sorry, this advert is now closed. Click here to view our live vacancies.

Our Scottish maritime client has an opening for a Forecasting & Planning Analyst with Public Sector / Transport experience to join them on a permanent contract.
 
THE SUCCESSFUL APPLICANT
 
Qualifications, Skills and Experience
 
  • Qualification in information management, business analysis, statistics etc or equivalent experience.
  • Minimum of 3 years’ experience in data management and/or business analysis role.
  • Experience in a range of business intelligence tools with focus on IBM Cognos preferred.
  • Strong SQL skills and demonstrate experience in querying and reporting data with large scale, complex databases.
  • Able to think latterly to identify issues not obvious on initial analysis of available data.
  • Experienced in undertaking structured and unstructured data analysis activities.
  • Experienced of using data analysis tools to produce a range of reports and presentation.
  • Experience of working in a self-motivating environment with minimal direct supervision.
  • Understanding of the data being stored and the architecture of the storage facilities used within the business to enable ad-hoc data analysis activities to be undertaken.
  • Evidence of excellent communication and negotiation/influencing skills with excellent reporting writing ability.
  • Exceptional analytical and Excel skills.
  • The ability to find ways of solving or pre-empting problems.
  • Experience of working within a reactive, fast moving environment.
  • Demonstrates excellent time management purposes and in setting and monitoring targets and performance indicators.
  • Driven and proactive with exceptional communication skills, written and oral, and able to work both collaboratively and autonomously.
  • Can demonstrate an orientation towards continuous improvement, particularly in operational process improvement.
  • Must be able to work independently and prioritise work effectively, as well as to function as an effective team member in a local and virtual team development environment.
  • Has ability to travel throughout the network as needed (may include overnight travel.)
 
Desirable –
 
  • Knowledge of operational environment of the ferry business.
  • Understanding of the Ferry networks, routes and operation.
  • Experience of working with Transport Scotland, CMAL and harbour authorities.
  • Insight into the strategic, political and environmental setting within which CFL operates and challenges this presents from a deployment perspective.
  • Wider transport industry business intelligence knowledge including current industry trends and challenges including data quality approaches.
 
JOB DESCRIPTION 
 
Working within the Service Delivery department, your key accountabilities will include:
 
Demand and Capacity Planning -
  • Carry out analysis to support the identification of opportunities to optimise capacity across the network and work with other stakeholders to implement any recommendation.
  • Work with business users to identify their business intelligence needs and jointly develop solutions through leveraging all available reporting options. This may include building prototype dashboards and reports to proactively demonstrate basic to advanced functionality to the business user.
  • Assist the Forecasting and Planning Manager in completion of the necessary analysis to support the development of the Seasonal Service Delivery Plans including vessel development and cascades associated with vessel overhaul and relief planning.
  • Work with stakeholders to define, develop and deliver a suite of demand management and capacity forecasting reports including associated CHFS commitments, annual reviews, future timetable changes, short-range forecasts and ad-hoc requests across the network.
  • Ensure that the data needs of all functions within Service Delivery Planning and the Regional Service Delivery teams are met in respect of demand management and capacity forecasting and that the data is accurate, complete and maintained effectively.
  • Ensure the quality and accuracy of all data analysis outputs and management reports.
  • Assist the Forecasting and Planning Manager in identifying opportunities and approaches for sensitivity and ‘What If’ analysis to identify actions that will lead to improved reliability, availability, reduced costs and in improved customer experience across the network.
  • Assist the Forecasting and Planning Manager in carrying out data analysis, interpretation and reporting activities in support of consultancy advice provided on an adhoc basis to Transport Scotland and other relevant parties as required.
 
Fuel Management –
 
  • Run Dashboard reports for each vessel on fuel efficiencies.
  • Review data from system for data anomalies and escalate to Roystons for investigation and resolution.
  • Produce and distribute a range of reports including KPI’s, dashboard, leader boards, trends, comparisons, ad-hoc analysis etc to provide relevant stakeholders with information required to improve fuel efficiency across the network.
  • Work with Roystons to review data and reports for accuracy and completeness and with a view to continuously improving reporting formats to derive maximum benefit for the business.
  • Champion the use of fuel monitoring data within the business as a means to drive efficiencies and make informed business decisions on fuel efficiency improvement initiatives.
  • Work with other areas of SDP to exploit the fuel information available to make considered business decisions on vessel deployment, passage times etc.
  • Work with Asset Management Team to use fuel management data to inform business cases for fuel efficiency initiatives and measure delivery of benefits upon completion.
  • Work with Marine Managers and Technical Managers to support the drive behavioural change in pursuit of increased fuel efficiencies, using the reporting tools available as a measure to direct improvements.
  • Work with IS as required on fuel management system supplier management, providing feedback on particular areas of concern and contributing to regular business reviews of Supplier SLA’s and KPI’s.
  • Identify and purpose fuel efficiency improvements and fuel cost saving initiatives across the business.
  • Ensure alignment with organisational developments in data and information management.
  • Establish and maintain strong and effective working relationships with all relevant departments (including but not limited to, IS, Commercial, Service Delivery, Retail Operations, Asset Management, and Harbour Improvements.)
 
Data Integrity and Continuous Improvement –
 
  • Liaise with the IS department and data warehouse to ensure data is stored within an appropriate location in line with the objectives of the wider business.
  • Identify those data sets which should be defined as “Master Data sets” where the same data is used within Service Delivery Planning and the wider business liaising with the IS department to ensure data is appropriately stored.
  • Support the culture of continuous improvement within the department.
 
REMUNERATION PACKAGE ON OFFER 
 
Competitive Salary and Benefits Package