MSX International Group is the leading global provider of outsourced business solutions for the automotive industry making business in more than 80 countries. MSXI’s deep industry expertise combined with advanced data analytics and custom software solutions improve the performance of automotive dealership networks by increasing revenue, reducing cost, and enhancing customer satisfaction. MSX are currently seeking a highly motivated, creative and experienced Data Analyst to provide departmental reporting to a premium automotive manufacturer. The service is to provide monthly deep dive reporting and analysis on retailer general and warranty topics including monitoring warranty audit, claim costs and repair activity. To understand anomalies, report on market dashboards and inhouse systems. To be available to visit retailers and discuss warranty topics and monitor activity, suggest changes and review KPI audits Report market trends within the warranty audit and health check programs. Use of several different data sources to ensure reports are consistent and accurate, the successful candidate will provide departmental insights, produce top level summaries, departmental dashboards and establish a structured reporting plan. Working within the Warranty and Technical area, this role will also require an in-depth understanding of the data with ability to provide ad-hoc intelligence to departmental Managers. This role will require a data professional to check the validity and integrity of the data being collated into the visualizations. Working alongside the OEM and data providers to establish where any data discrepancies are attributed and work to identify a corrective course of action. Attention to detail and quality control are key to this role. This is an excellent opportunity for the right candidate to build a career in the automotive industry, demonstrate their abilities, develop their skills and bring their own personality to the role. The role will have a hybrid office location between home, Colchester or Farnborough, and client premises. Qualifications * The ideal candidate will have a minimum of two years’ experience within a reporting and data analysis role and have an understanding of the automotive industry * Technical knowledge of dealer warranty process systems and DMS advantageous * Knowledge of business data with ability to analyse, understand and work with different and new systems * Solid and demonstrable high-level understanding of Excel * Ability to create visualizations and summaries to Senior Management level using PowerPoint * A strong understanding of databases and data structures to aid in the development of reports * Ability to be creative and create a robust reporting structure and top-level summaries * Experience in creating dashboards and providing data insights with recommendations based on findings * Experience with process improvement, identifying opportunities and implementation of approved changes. * Additional team support creating SharePoint, updating internal departmental process and data / file management, coordinating surveys and providing technical videos to the network * Logical and methodical approach to data analysis * Excellent time management skills with the ability to successfully manage own workload * Team player with good communication skills * Automotive / Technical background with aptitude to learn * Confident and proactive * Full UK Driving Licence as Retailer visits will be required (approx. 12 per annum) * Ability to attend client offices on an ad-ad-hoc bas Working pattern and location: 40 Hours Monday – Friday BMW Head Office, Farnborough or MSX Colchester Office Colchester What we can offer you: Salary up to £35,000 depending on experience Other company benefits include: 25 days annual leave Company contributory pension plan Cash back health care scheme Life assurance Car salary exchange scheme Potential to progress within the company, with global opportunities updated regularly. You can learn more about MSX International on our website: MSX International