IT Asset Lifecycle & Data Analytics Specialist

Capgemini; Manila; On-site; PHP 350,000 - 650,000; Full time

Job summary

Capgemini Philippines is seeking an IT Asset Management Specialist to maintain and reconcile assets across laptops, desktops, monitors, and peripherals. You will manage lifecycle processes from procurement to retirement and collaborate with onsite IT teams to validate inventories.

The role emphasizes advanced Excel reporting, data analysis, and KPI dashboards. You will partner with HR, Finance, and Procurement to ensure audits pass and asset data remains accurate for regional leadership.

Qualifications

• Bachelor's degree in IT, Computer Science, Business Administration, Accounting, MIS, or related field.
• 2–3 years of experience in IT asset management, inventory control, IT operations, or data reporting.
• Experience with large inventory databases, hardware lifecycle management, and asset reconciliation.
• Familiarity with ServiceNow, ManageEngine, or similar ITSM/asset systems; multinational or shared-services experience preferred.
• Advanced Excel skills: XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF/IFS, IFERROR; PivotTables and dashboards.

Responsibilities

• Maintain accurate inventory records for laptops, desktops, monitors, peripherals, and other IT equipment.
• Track procurement, receipt, allocation, transfer, repair, replacement, recovery, disposal, and retirement.
• Record ownership, employee assignment, location, serial numbers, warranty details, and asset movements.
• Coordinate physical inventory validation with onsite IT teams and monitor aging assets and refresh needs.
• Reconcile physical stock, asset management databases, and employee allocation records.
• Investigate missing assets, duplicates, incomplete information, and mismatched records.
• Support periodic audits and verify returned, transferred, and disposed assets with appropriate audit trails.
• Maintain Excel-based inventory trackers, reconciliation reports, and management dashboards.
• Analyze large datasets to identify discrepancies, trends, risks, and improvement opportunities.
• Produce weekly and monthly reports on inventory accuracy, allocation, recovery, aging, and disposal.
• Automate repetitive reports and consolidate data from multiple sources.
• Track assets assigned to separating employees and coordinate timely recovery with HR, IT, Finance, and business teams.
• Maintain records of unreturned, lost, missing, and damaged assets; produce aging reports and escalate overdue cases.
• Support accountability and potential chargeback documentation; inspect and record returned equipment.
• Prepare management reporting and monitor agreed asset KPIs and outstanding discrepancies.
• Follow Capgemini asset management policies, security controls, and documentation requirements.
• Support internal/external audits, disposal approvals, and continuous process improvements.
• Collaborate with GOSS, HR, Finance, Procurement, and business representatives across Philippine locations.
• Provide accurate asset information to regional IT leadership and follow through on outstanding actions.

Skills

Advanced Excel

Data analysis

Data reconciliation

Asset management

Stakeholder collaboration

Education

Bachelor's degree in IT/CS/BA/MIS

Tools

ServiceNow

ManageEngine

Job description

Capgemini Philippines is seeking an IT Asset Management Specialist to maintain and reconcile assets across laptops, desktops, monitors, and peripherals. You will manage lifecycle processes from procurement to retirement and collaborate with onsite IT teams to validate inventories.

The role emphasizes advanced Excel reporting, data analysis, and KPI dashboards. You will partner with HR, Finance, and Procurement to ensure audits pass and asset data remains accurate for regional leadership.