Data Analyst

Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers. We empower car dealers and manufacturers to fully embrace digital transformation. How? By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs.   We use cutting-edge technology to link our clients’ systems, departments and sites. We provide an open technology platform that’s shaping the industry for the future. We use data to help clients become more efficient, increase profitability and give more customers an amazing experience. Want to be part of it?    

Purpose of role

• The Data Analyst is a key member of the Kilimanjaro Transformation Pprogramme, responsible for the accuracy, consistency and integrity of Keyloop’s product and pricing data, with a primary focus on legacy SKU mapping and catalogue validation 

• The Data Analyst works closely with Pricing, Product Management and, Finance  and Billing to ensure that legacy SKUs are accurately mapped to the Product Index architecture and that catalogue and CPQ data reflects the agreed pricing logic 

Key Duties & Responsibilities

• Own the mapping of legacy SKUs to the Product Index architecture, documenting the mapping rationale, dependencies and exceptions for each SKU 

• Investigate the commercial history of legacy SKUs (including contractual, pricing and billing context) and work with Pricing and Product Management to resolve ambiguities and agree the target mapping 

• Validate product catalogue and pricing data on CPQ against the Product Index and the agreed pricing rules; identify, log and drive the resolution of discrepancies 

• Design and run repeatable validation checks (e.g. mapping coverage, completeness, duplicates, price and unit consistency) to give confidence in data quality 

• Extract, cleanse and reconcile data from legacy systems, the data warehouse and Salesforce, ensuring a clear audit trail from source to target 

• Work with Billing and Finance to ensure that mapped SKUs remain consistent with contract and invoice data 

• Support data migration and validation activities as required by the programme 

• Maintain clear documentation (mapping rules, data definitions and decision log) and report progress, risks and open issues to the Pricing team and programme stakeholders 

Key Skills

• Proven experience in data analysis, data mapping and validation of large, complex datasets (ideally product, catalogue or pricing data) 

• Proficient in Excel, including advanced lookups, pivot tables, data cleansing and reconciliation 

• Comfortable with Salesforce or similar – including database manipulation, extraction and validation 

• Strong attention to detail, with a structured approach to investigating legacy data and resolving ambiguity 

• Strong written and verbal communication, with good stakeholder management across Pricing, Product, Finance and Billing 

• Able to work independently and deliver to programme deadlines in a fixed-term environment 

Desired, but not essential:

• Experience with Salesforce CPQ – including product catalogue architecture, pricing rules and data migration/validation 

• Experience working on a large CRM, ERP or data migration programme 

• Experience with B2B Software as a Service (SaaS) products and pricing 

• Comfortable with Power BI 

• Experience working in an international environment 

Why join us? We’re on a journey to become market leaders in our space – and with that comes some incredible opportunities. Collaborate and learn from industry experts from all over the globe. Work with game-changing products and services. Get the training and support you need to try new things, adapt to quick changes and explore different paths. Join Keyloop and progress your career, your way.   An inclusive environment to thrive We’re committed to fostering an inclusive work environment. One that respects all dimensions of diversity.  We promote an inclusive culture within our business, and we celebrate different employees and lifestyles – not just on key days, but every day.   Be rewarded for your efforts We believe people should be paid based on their performance so our pay and benefits reflect this and are designed to attract the very best talent. We encourage everyone in our organisation to explore opportunities which enable them to grow their career through investment in their development but equally by working in a culture which fosters support and unbridled collaboration.   Keyloop doesn’t require academic qualifications for this position. We select based on experience and potential, not credentials.   We are also an equal opportunity employer committed to building a diverse and inclusive workforce.  We value diversity and encourage candidates of all backgrounds to apply.   "At Keyloop, AI is a daily ally: We encourage and train every employee to use our AI tools to boost their creativity and productivity."