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 dashboard reporting.
- Proficiency in Power BI for data visualization, dashboard creation, and reporting.
- Familiarity with ERP systems (e.g., SAP, Oracle, NetSuite) and experience extracting data for reporting purposes.
- Strong knowledge of accounts payable processes, financial reporting, and KPI tracking.
- Technical Skills:
- Advanced Power BI skills (data modeling, DAX measures, Power Query transformations, performance optimization, publishing and workspace management).
- Advanced Excel skills (Power Pivot, pivot tables, complex formulas) to support analysis, reconciliations, and validations.
- Strong SQL (preferred) and/or other data tools for extraction and data mining; exposure to Tableau/other BI tools is a plus.
- Understanding of ETL concepts, data governance, and controls (master data, metric definitions, data quality checks) for reliable reporting.
- Soft Skills:
- Strong analytical skills with the ability to interpret complex data and translate it into actionable insights.
- Excellent communication and collaboration skills to present findings and work with diverse teams.
- Detail-oriented and highly organized with a strong focus on data accuracy and reporting consistency.
BGV:
- Employment with WSP India is subject to the successful completion of a background verification (“BGV”) check conducted by a third-party agency appointed by WSP India.
- Candidates are advised to ensure that all information provided during the recruitment process — including documents uploaded — is accurate and complete, both to WSP India and its BGV partner”.
About Us
WSP is one of the worlds leading professional services consulting firms. We are dedicated to our local communities and propelled by international brainpower. We are technical experts and strategic advisors including engineers, technicians, scientists, architects, planners, surveyors and environmental specialists, as well as other design, program and construction management professionals. We design lasting solutions in the Transportation & Infrastructure, Property & Buildings, Earth & Environment, Power & Energy, Resources and Industry sectors, as well as offering strategic advisory services. Our talented people around the globe engineer projects that will help societies grow for lifetimes to come.
With approximately
4,000 talented people across 3 locations (Noida, Bengaluru & Mumbai offices) in India and more than
73,000 globally, in 550
offices across 40 countries, we engineer projects that will help societies grow for lifetimes to come.
At “WSP” we draw on the diverse skills and capabilities of our employees globally to compete for the most exciting and complex projects across the world and bring the same level of expertise to our local communities. We are proud to be an international collective of innovative thinkers who work on the most complex problems. Unified under one strong brand, we use our local expertise, international reach and global scale to prepare our cities and environments for the future, connect communities and help societies thrive in built and natural ecosystems. True to our guiding principles, our business is built on four cornerstones:
Our People, Our Clients, Our Operational Excellence and Our Expertise.
www.wsp.com
We are
- Passionate people doing purposeful and sustainable work that helps shape our communities and the future.
- A collaborative team that thrives on challenges and unconventional thinking.
- A network of experts channeling our curiosity into creating solutions for complex issues.
Inspired by diversity, driven by inclusion, we work with passion and purpose.
Working with Us
At WSP, you can access our global scale, contribute to landmark projects and connect with the brightest minds in your field to do the best work of your life. You can embrace your curiosity in a culture that celebrates new ideas and diverse perspectives. You can experience a world of opportunity and the chance to shape a career as unique as you.
Our Hybrid Working Module
With us, you can operate in a flexible, agile, yet structured work environment and follow a Hybrid Work Model.
- Maximize collaboration.
- Maintain product quality and cultural integrity.
- Balance community, collaboration, opportunity, productivity, and efficiency.
Health, Safety and Wellbeing
Our people are our greatest asset, and we prioritize a safe work environment. Health, safety, and wellbeing are integral to our culture, with each of us accountable for fostering a safe workplace through our “Making Health and Safety Personal” initiative. Our Zero Harm Vision drives us to reduce risks through innovative solutions, earning recognition for our global health and safety practices with the prestigious RoSPA Health and Safety Awards for six consecutive years.
Inclusivity and Diversity
WSP India is dedicated to fostering a sustainable and inclusive work environment where our greatest strength - Our People -feel valued, respected, and supported. We ensure an unbiased approach in hiring, promotion, and performance evaluation, regardless of age, gender identity, race, religion, sexual orientation, marital status, physical ability, education, social status, or cultural background.
Imagine a better future for you and a better future for us all.
Join our close-knit community of over 73,300 talented global professionals dedicated to making a positive impact. Together, we can make a difference in communities both near and far.
With us, you can.
Apply today.
NOTICE TO THIRD PARTY AGENCIES:
WSP does not accept unsolicited resumes from recruiters, employment agencies, or other staffing services. Unsolicited resumes include any resume or hiring document sent to WSP in the absence of a signed Service Agreement where WSP has expressly requested recruitment/staffing services specific to the position at hand. Any unsolicited resumes, including those submitted to hiring managers or other business leaders, will become the property of WSP and WSP will have the right to hire that candidate without reservation – no fee or other compensation will be owed or paid to the recruiter, employment agency, or other staffing service.