Job Description

Your Role

Key Responsibilities
A. IT Asset Lifecycle Management
•    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.
B. Asset Inventory and Reconciliation
•    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.
C. Advanced Excel Reporting and Data Analysis
•    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.
D. Asset Recovery and Employee Offboarding
•    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.
E. Reporting, Governance, and Compliance
•    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.
F. Stakeholder Coordination
•    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.

Your Profile

Qualifications and Experience
•    Bachelor’s degree in IT, Computer Science, Business Administration, Accounting, MIS, or related field.
•    At least 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.


Mandatory Advanced Excel Skills
•    XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF/IFS, IFERROR, and nested formulas.
•    PivotTables, PivotCharts, slicers, advanced filters, conditional formatting, data validation, and duplicate detection.
•    Power Query for cleaning, transforming, and combining data from multiple sources.
•    Interactive KPI dashboards, large-dataset reconciliation, and reporting automation.
•    Power Pivot, VBA macros, Power BI, and related automation are advantageous.


Job Details

Role Level: Associate Work Type: Full-Time
Country: Philippines City: Manila Metro Manila
Company Website: https://www.capgemini.com Job Function: Procurement & Vendor Management
Company Industry/
Sector:
IT Services and IT Consulting

What We Offer


About the Company

Searching, interviewing and hiring are all part of the professional life. The TALENTMATE Portal idea is to fill and help professionals doing one of them by bringing together the requisites under One Roof. Whether you're hunting for your Next Job Opportunity or Looking for Potential Employers, we're here to lend you a Helping Hand.

Disclaimer: talentmate.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at abuse@talentmate.com.


Talentmate Instagram Talentmate Facebook Talentmate YouTube Talentmate LinkedIn