Data analytics and business intelligence
- Analyse data from multiple sources to identify trends, resolve issues and support business decisions.
- Develop and maintain BI dashboards, reports and visualisations.
- Use Google Cloud tools to access, process and analyse data.
- Build, maintain, run and sunsetting migration of Alteryx workflows to prepare data, automate processes and support reporting.
- Validate data and investigate discrepancies to ensure accurate outputs in all sections of the business.
- Translate business requirements into analytical solutions and communicate findings to stakeholders.
- Document data sources, workflows, reporting definitions and processes.
- Balance financial bordereaux required for regulated reporting.
- Prepare and produce quarterly CBR regulatory reports.
- Reconcile all required financial components with the Finance team.
- Meet with dealers to address analytics enquiries and explain relevant data and reports.
- Communicate data findings, trends and insights to dealers and Dealer Principals.
- Attend weekly meetings to discuss analytical findings, progress and relevant issues.
- Prepare and deliver presentations to management on analytics, findings and recommendations.
- Provide operational support for Ford Protect Customer Care, Claims and Vehicle Inspection, including monitoring shared mailboxes, handling calls and providing cover when required.
- Support the administration and monitoring of Ford Protect claims.
- Review claims data for completeness and accuracy, and investigate discrepancies.
- Analyse claims trends and prepare reports for management and relevant stakeholders.
- Liaise with dealers and internal teams to resolve claims-related enquiries.
- Reconcile claims data with Finance where required.
- Maintain accurate claims records and support compliance with applicable processes and reporting requirements.
Plan and retail administration
- Bulk-upload monthly retail files, including inclusive plans.
- Load Extended Service, Maintenance and Warranty plans onto GESB rom Alteryx Workflows and compare the accurate loadings of all policies.
- Upload retail and portal Files.
- Upload urgent manual plans on request.
- Review error logs and make system corrections.
Dealer bulletins
- Write and load dealer bulletins.
Experience required
- 3-4 years’ experience in a similar role.
- Automotive industry experience is desirable.
- Experience in data analytics, BI reporting, Google Cloud and Alteryx.
Skills and competencies
- Strong BI, reporting and data visualisation skills.
- Ability to analyse data, identify discrepancies and resolve problems.
- Exceptional attention to detail and commitment to data accuracy.
- Good organisational skills and the ability to manage competing priorities.
- Clear written and verbal communication skills.
- Ability to work independently and collaboratively with different stakeholder and teams.
System knowledge
Knowledge of the following systems would be advantageous:
- Excel Advanced
- BI
- Alteryx
- Google Cloud
- PowerPoint
Qualifications
- Bachelor’s degree or diploma in Data Analytics, Information Technology, Information Systems, Computer Science, Statistics, Finance or a related field.
Relevant equivalent qualifications and experience may also be considered.
MSX is an equal opportunities employer and encourages applications from suitably qualified and eligible candidates regardless of sex, race, disability, neurodiversity or other personal characteristics and backgrounds, age, sexual orientation, gender reassignment, religion or belief, or marital and parental status. As users of the Disability Confident scheme, we interview all disabled applicants who meet the minimum criteria for the vacancy.