Job Description

Retail Values Analyst/ Hybrid Leeds

Who We Are

Solera is a global leader in data and software services that strives to transform every touchpoint of the vehicle lifecycle into a connected digital experience. In addition, we provide products and services to protect life\xe2\x80\x99s other most important assets: our homes and digital identities. Today, Solera processes over 300 million digital transactions annually for approximately 235,000 partners and customers in more than 90 countries. Our 6,500 team members foster an uncommon, innovative culture and are dedicated to successfully bringing the future to bear today through cognitive answers, insights, algorithms and automation. For more information, please visit solera.com.

The Role

Working within the Business Information and Analytics team at cap hpi, you will lead on supporting the Valuations team to produce data driven retail vehicle valuations. You will be responsible for analysing retail advertised data from a number of sources and assisting in producing accurate retail values for cars and LCVs. A full review of the current methodology and investigating alternative ways to produce dynamic values that reflect the automotive retail market is also a key part of the role, whilst also liaising with current and forecast valuation teams to provide proactive data analysis to maintain and improve accuracy of all valuation products.

What You\xe2\x80\x99ll Do

Key Activities:

• Research, maintain and offer recommendations to any market-led changes to cap hpi\xe2\x80\x99s retail values.
• Develop improved internal analytics/reporting allowing cap hpi valuations team to be proactive to changes in the retail market.
• Produce reports illustrating accuracy levels of retail values for both cars and LCV, by analyzing advert data and value evidence.
• Interrogate previously devised methodology for dynamic retail values, using SQL data analytics & provide recommendations on accuracy with a view of going to market with revised methodology.
• Using Power BI, create dashboards and promote self-service insights to support monthly editorials, webinars and PR.
• Produce analysis on \xe2\x80\x9cdays in stock\xe2\x80\x9d at retailers.
• Manage relationships with retail data suppliers, ensuring daily supply of data is maintained. Liaise with technical teams from cap hpi and suppliers as necessary.
• Provide analysis of regional differences of retail prices and days to sell.
• Assist editors with customer queries related to retail values.
• Provide analysis of differences between franchise dealers, independent retailers, car supermarkets and online sales outlets.
• Provide insight to the editorial team on new car discount levels at manufacturer and model level.
• Periodic review of cap hpi transactional values for insurance industry.
• Assist in developing a system to futureproof valuations for all vehicle types, including electric vehicles.
• Provide general analytics on age & mileage profile accuracy.
• Assist with general analytics for current & forecast values for cars & LCVs.

• Improve accuracy of cap hpi\xe2\x80\x99s published retail values.
• Assist in maintaining cap hpi\xe2\x80\x99s market leading valuation position.
• Provide transparency on valuation accuracy for internal and external presentation.
• Queries are dealt with quickly and efficiently.

• A background in, and an enthusiasm and passion for, data analysis.
• An interest or experience in the automotive industry is desired but not essential.
• Intermediate / Advanced T-SQL query writing and data extraction skills.
• Experience of Microsoft Power BI desired, to build automated dashboards and reports.
• An inquisitive and proactive approach to data and problem-solving.
• A keen attention to detail and ability to troubleshoot and problem solve.
• Experience of working both independently and collaborating as part of a team.
• Excellent organization skills and ability to prioritize time.
• Quick learner who pays attention to detail.
• Strong communication skills.
• A keen desire to develop and improve, to learn new tools and techniques that can enhance yourself and the business.
• Strong visualization and presentation skills.

Solera