Job Description
Overview
Specialist-Working Capital
Experience : 5-8 Years
Skill : Working Capital + Analytics
Location: Hyderabad/Bangalore
Shift:06:30 PM - 03:30 AM
We have a role for a Finance & Data Operations to oversee day today accounting transactions & Data operations for Omnicom Group US Finance. This might be a great fit if have strong accounting skills and would to be part of leading a growing team. You will be closely working with our Global and India Finance Teams.
A About Omnicom Global Solutions
Omnicom Global Solutions is an integral part of Omnicom Group, a leading global marketing and corporate communications company. Omnicoms branded networks and numerous specialty firms provide advertising, strategic media planning and buying, digital and interactive marketing, direct and promotional marketing, public relations, and other specialty communications services to over 5,000 clients in more than 70 countries.
Omnicom Global Solutions India plays a key role for our group companies and global agencies by providing stellar products, solutions, and services in the areas of Creative Services, Technology, Marketing Science (Data & Analytics), Advanced Analytics, Market Research, Business Support Services, Media Services, and Project Management.
Responsibilities
Client & Agency Service:
- Closely collaborate with other Working Capital Managers and Analyst to prepare monthly Working Capital (AR and AP) reporting for all Omnicom Media Group agencies.
- Run reporting and aggregate Working Capital data from multiple sources (Mediaocean, Microsoft D365, Cognos); create custom reports in Excel, as directed.
- Efficiently load Working Capital data to Hyperion Financial Management (HFM), identifying and resolving issues before submission while meeting internal deadlines.
- Reconcile Working Capital data to General Ledger data within HFM monthly.
- Monitor Accounts Receivable balances - Review ARs by agency/region/client and identify issues. Collaborate closely with Budget Project Managers (BPMs), Finance Directors (FDs), and other internal staff to optimize collections and ensure timely payment.
- Assess monthly cash forecast submissions by the BPMs for accuracy. Submit weekly updates on cash status to senior management.
- Ability to effectively summarize Working Capital data and provide detailed explanations of specific account balances, including past due amounts, unbilled media/revenue, negative working capital, and year-over-year investment variances, for monthly meetings with senior management.
- Organize and schedule AR and Cash Forecast status meetings with BPMs/FDs.
- Run inquiries on client credit viability through an external system (Allianz) and assist in establishing credit insurance limits; provide reports upon request.
- Monitor and assist in the reconciliation of unapplied cash through monthly meetings with BPMs and ad hoc inquiries.
- Identify potential offsets/write-offs on aging and work with BPMs to resolve.
Qualifications
This may be the right role for you if you have.
- Bachelors Degree in accounting or relevant field with Min 5 years of experience in accounting operations.
- Proficient knowledge of MS Office Suite and the ability to quickly learn new accounting softwares
- Experience in Microsoft D365, Media Ocean, and Hyperion experience is a plus
- Advanced Excel skills are required including knowledge of pivot tables, V-lookups and conditional formulas
- Good analytical ability and logical reasoning
- Strong oral and written communication skills
Job Classification
Industry: Film / Music / Entertainment
Functional Area / Department: Finance & Accounting,
Role Category: Finance
Role: Financial Analyst
Employement Type: Full time
Contact Details:
Company: Omnicom Media Group
Location(s): Hyderabad
Keyskills:
hyperion financial management
analytical
accounting operations
investment
accounting
media
microsoft
excel
analytics
hyperion
ocean
written communication
business process management
advanced excel
ms office suite
science
support services
communication skills