Principal Specialist - Record to Report

Job Description

We are seeking a detail-oriented Accounts Payable (AP) Reporting & Analytics Specialist with strong expertise in Power BI, data mining, and dashboard development.

The role will own end-to-end AP reporting—from extracting and validating data from ERP and upstream sources to designing insightful dashboards and delivering comprehensive periodic reports

for Finance leadership. The successful candidate will translate AP data into actionable insights that improve cash visibility, vendor performance management, and operational efficiency.

Responsibilities

Accounts Payable Reporting:
Prepare and publish comprehensive AP reports (daily/weekly/monthly), including ageing, payment run status, vendor performance, holds, accrual/provision visibility, cash requirements and trend analysis.
Deliver executive-ready MIS packs and ad-hoc analysis for Finance/Business stakeholders with clear commentary, drivers, risks, and recommended actions.
Own periodic balance sheet schedule support and AP reconciliations (sub- ledger to GL), including reasonability checks, exception tracking, and ageing movement analysis.
Perform data mining on AP datasets to identify leakage, duplicate payments, ageing exceptions, recurring holds, approval bottlenecks, and process/control improvement opportunities.
Define, track, and monitor AP KPIs/SLAs (invoice cycle time, ageing buckets, first-time-right, holds, payment accuracy, productivity/agent performance) and publish scorecards/dashboards.
Support month-end close reporting activities (provisions/accruals, prepaid review, trial balance scrutiny) and ensure AP reporting aligns to the close calendar and audit expectations.
Power BI Dashboard Development:
Design, develop, and maintain interactive Power BI dashboards for AP KPIs (ageing, payment cycle time, holds, vendor performance, cash requirement forecasting), following best practices for usability and performance.
Automate data refresh and reporting workflows (datasets, refresh schedules, validations) to improve timeliness, accuracy, and reduce manual effort.
Integrate and transform data from multiple sources (ERP/Oracle/SAP, banking outputs, spreadsheets, master data) using Power Query/SQL as applicable; build robust data models (relationships, measures, DAX) and maintain clear documentation/data dictionaries.
Data Analysis & Insights:
Analyze AP data to explain variances, trends, and exceptions, using structured root-cause techniques and data mining methods.
Provide actionable insights and recommendations on payment cycles, vendor terms, working capital/cash flow, discount opportunities, and process efficiencies.
Partner with AP operations, Procurement, Treasury, and IT to gather requirements, validate definitions, and ensure consistent metric logic across reports and dashboards.
Process Improvement:
Identify and drive reporting-led process improvements (automation, standardization, controls), including reducing manual reporting and improving first-time-right processing.
Recommend enhancements to reporting architecture (data sources, definitions, automation, security) and contribute to the AP reporting roadmap and self-service analytics enablement.
Ensure reports and dashboards are audit-ready with clear logic, controlled access, versioning, and traceability from source data to outputs.
Collaboration & Communication:
Work closely with cross-functional teams (IT, Procurement, Treasury, HR, FP&A) to access data, validate master data, and maintain reporting accuracy.
Present insights through dashboards and comprehensive reports to senior stakeholders; explain drivers, risks, and actions in a clear data story.
Create user guides and provide training/guidance on interpreting KPIs, using dashboards, and adopting standard reporting packs.

Qualifications

Education:

Master degree in Accounting, Finance, Data Analytics, or a related field.
Relevant certifications (e.g., Microsoft Certified: Data Analyst Associate, Certified Accounts Payable Professional) are a plus.
8-12 years of rich experience from good MNC and required skill set.

Experience:

Proven experience in an accounts payable or financial reporting role with a focus on data analysis and…