Data Analyst

Purpose of role

• The Data Analyst is a key member of the Kilimanjaro TransformationPprogramme, 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 Managementand,Financeand 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