Senior Treasury Analyst
- Microsoft Dynamics
- Coupa
- CMA
- Excel
- Pivot Tables
- D365
- Power BI
- SOX
Job Description:
Key responsibilities:
Primary Responsibilities:
ā Complete quarterly and yearly working capital forecasts to support strategic financial planning
ā Provide detailed monthly commentary to Commercial Finance on forecast submissions, highlighting variances and trends
ā Prepare and review monthly agencies aging reports and client exposure analysis; submit reviewed documentation to CMO, Controls, Treasury, and Credit teams
ā Process and evaluate internal credit limit applications for Dentsu officers and clients not covered by standard credit insurance
ā Submit credit applications for new or prospective clients, coordinated with agency finance operations teams and submitted with Dun & Bradstreet information
Net Position Management & Netting Process
The analyst is responsible for managing Dentsu's net position file on a bi-weekly basis, focusing on the company's largest clients. This critical function involves:
ā Position Consolidation: Aggregate and reconcile payables and receivables across multiple entities and currencies to establish true net exposure per client
ā Netting Calculations: Apply bilateral and multilateral netting methodologies to offset obligations and reduce overall working capital requirements
ā Client Coordination: Work with agencies and finance teams to facilitate netting agreements and ensure alignment on settlement procedures
ā Documentation & Reporting: Maintain accurate netting schedules and provide net position files to Treasury for cash forecasting and liquidity management
ā Risk Mitigation: Monitor netting agreements for compliance and identify opportunities to optimize net positions and reduce counterparty risk
ā Approve journals and payments in Microsoft Dynamics 365 accounting system
ā Manage transactions and approvals within the Coupa Bellin application
ā Oversee file payroll provider system to ensure accurate payment processing
ā Attend and actively participate in weekly vendor calls and bi-weekly AR calls
Knowledge and Qualifications
Qualifications
⢠Bachelor's or Master's Degree in Commerce, Finance, Accounting, Business Administration, Economics, ICWAI/CMA, CTP, MBA, or Semi-Qualified Chartered Accountant.
⢠7ā9 years of experience in corporate treasury, working captial management management, or related finance functions.
⢠Highly proficient in Microsoft Excel (advanced formulas, pivot tables, data analysis)
⢠Demonstrated ability to manage multiple priorities and meet strict deadlines
⢠Strong collaborative skills with ability to work effectively in cross-functional teams
⢠Adaptability to organizational, system, and process changes
⢠Excellent attention to detail and strong analytical capabilities
Systems and Tools
⢠Microsoft Dynamics 365 (D365) Approve journals
⢠Power BI ā AR aging reports, forecasting dashboards, and variance analysis.
⢠Coupa Treasury (Bellin) treasury management system for approval, routing, and reporting.
⢠Microsoft Teams ā daily coordination with Group Treasury, Credit teas and cross-functional partners.
Core Competencies
⢠Forecasting Accuracy ā the ability to manage multi-horizon forecasts and reduce variance through disciplined data analysis
⢠Group Treasury Communication ā clear, decisive communication with internal teams, banking partners, and insurers.
⢠Process Orientation ā commitment to documenting procedures, eliminating undocumented workarounds, and maintaining SOX/ICF compliance.
⢠Judgment and Prioritization ā ability to distinguish Treasury-owned decisions (risk and timing) from execution tasks that belong to partner functions.
Location:
BangaloreBrand:
BcoeTime Type:
Full timeContract Type:
PermanentSenior Treasury Analyst Ā· wd3:dentsuaegis:dan_global