Data Analyst
Summary
Data Analyst in Hyderabad supporting Keyloop's Kilimanjaro Transformation Programme: mapping legacy SKUs to a new Product Index, validating product catalogue and pricing data in Salesforce CPQ, and reconciling data from legacy systems, the data warehouse, and Salesforce. Core tools are Excel, Salesforce/CPQ, and Power BI.
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
Skills
As published by lever · 13 questions · 10 written answers
Basics
Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL, Twitter URL, GitHub URL, Portfolio URL, Other website, What is your age range?, I identify my ethnicity asSelect all that apply, What gender do you identify as?, Do you consider yourself to have a disability or be differently abled?, Were you previously employed by Armed Forces?
Short answers (1)
- Please confirm type of right to work document
Pick from a list (2)
- Are you currently authorised to work in the country of the job without any restrictions? optional
- Will you now or in future require visa sponsorship to work in country of the job optional
Written answers (10)
- What is your experience with AI Tools like Claude? optional
- Are you ready to work as fixed term contract for 6 months?
- Since this is a hybrid role, you will be required to work from the Hyderabad office on a regular basis. Are you comfortable with that?
- What is your Current compensation
- What is your Expected Compensation
- Do you have hands-on experience with Salesforce CPQ, including product catalogue or pricing data?
- Have you worked on a large-scale CRM, ERP, or data migration programme?
- Do you have experience working with product or pricing data in a B2B SaaS environment?
- Are you proficient in Excel for data analysis, including lookups, pivot tables, data cleansing, and reconciliation?
- Do you have experience using Power BI for data analysis or reporting?