Operations & Data Analyst / Advanced Excel Specialist

Description

Join the Amanah Group of Companies as an Operations & Data Analyst / Advanced Excel Specialist based in Lahore. This role demands a highly analytical individual with advanced expertise in Microsoft Excel to support and enhance the billing and shipment reconciliation functions. The position requires meticulous handling of large datasets from various courier partners such as UPS and DPD, applying pricing matrices, calculating profit margins, and ensuring invoicing accuracy to prevent revenue leakage. The candidate will operate from the Amanah Mall office during afternoon and evening hours, focusing on detail-oriented tasks to maintain data integrity and financial accuracy. The ideal candidate must excel in processing complex Excel functions, master the reconciliation of manifests against courier invoices, and prepare detailed reports to highlight billing statuses and discrepancies. Strong numerical skills along with a thorough understanding of cost calculations and margin analysis are essential. Although the role does not involve managing a team, it requires effective collaboration with the operations team to resolve discrepancies and streamline billing processes. This position plays a critical role in safeguarding the company’s revenue through diligent data analysis and operational vigilance.

Responsibilities

• Process, clean, organize, and format raw Excel data files received from courier and logistics partners ensuring accuracy and consistency.
• Apply prescribed pricing matrices and courier costs to shipments, accurately calculating profit margins to support financial analysis.
• Merge, reconcile, and audit multiple courier invoices and reports into structured datasets to maintain accurate billing records.
• Maintain a centralized Master Excel Sheet tracking all customer-submitted shipment manifests and reconcile these against courier invoices.
• Identify and track billed versus unbilled shipments to guarantee all customer orders are invoiced correctly and documented.
• Audit manifests and shipment data to detect discrepancies such as missing invoices, incorrect charges, or rate mismatches.
• Investigate and coordinate with operations teams to resolve billing discrepancies, ensuring no shipment remains unbilled.
• Compile and deliver daily and weekly reports detailing billing status, shipment reconciliation outcomes, profit margins, and any identified anomalies.
• Ensure meticulous record keeping to support data integrity and ease of management review.
• Apply advanced Excel skills including VLOOKUP, XLOOKUP, INDEX/MATCH, Pivot Tables, and nested IF statements for complex data manipulation and analysis.
• Utilize data validation, cleaning, and reconciliation techniques proficiently to manage large and multifaceted datasets.
• Employ numerical and analytical skills to interpret percentages, cost calculations, and margin monitoring to optimize revenue protection.
• Communicate effectively in written and operational English to document processes, discrepancies, and collaborate with internal teams.
• Adhere to office timings and maintain consistent work attendance and discipline in an on-site environment.

Experience

2 Years

Apply By

Nov 14, 2026

Required Skills

• Advanced Excel Formulas
• Attention to detail
• Mathematics
• Analytical Skills
• Data Cleaning
• Data Validation
• Billing Auditing
• Margin Calculations
• Invoice Reconciliation
• Data Analysis
• Power Query Data Transformation
• Process Improvement
• KPI Reporting and Dashboarding
• Advanced Microsoft Excel

Nice to Have Skills

• Reporting
• Record Keeping
• Communication Skills
• Organizational Skills