Data Analyst
IT, Data Science · Contractor
Hyderabad, Telangana, India
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