Return to Search →  Asia Pacific   Europe   Latin America   Eurasia & Africa   North America

Returning Applicants

Data & Analytics Manager, Retail Trade Management

The Coca-Cola Company

  • Location: Atlanta, GA - USA
  • Post Date: 4/1/2019
  • Job Type: FULL TIME
  • TRAVEL REQUIRED: 00% - 25%
Apply
Share This Job
Job ID: R-22990

Job Description Summary
Serve as the system owner/administrator and provide technical and analytical support for the reporting and analytics databases used in support of the retail trade payment and deductions management processes and DSD Odwalla. Supervises the activities of a team of finance professionals who analyzes and forecasts financial data to provide accurate and timely information for strategic and operational decisions; analyzes more data through complex systems, prepares reports, forecasts and recommendations; prioritizes and assigns tasks; responds to escalated enquiries. Leads/supervises a team of more than two professionals; typically, without budget or hire-fire authority; focuses on mentoring and coordination. Role has overall responsibility for the administration of processes and multiple systems used to support the Minute Maid Warehouse Retail, Minute Maid Canada, and DSD Odwalla trade settlement and deductions operations.

Key Responsibilities

  • Supervise and lead month-end, quarter-end, and year-end accounting period close activities that involve deductions, write-offs, and relevant journal entries within the Warehouse Retail, Minute Maid Canada, and DSD Odwalla
  • Lead the consolidation of Warehouse Retail and DSD Odwalla deductions data to facilitate a holistic view by customer within U.S. operations
  • Report, track, and monitor Small Balance Write-Offs that impact the overall Warehouse/DSD Odwalla P&L
  • Oversee the management of Unsaleables/ARP process end-to-end; including quarterly checks, accruals, and/or other reporting as needed
  • Conduct complex general ledger account and/or legacy customer account reconciliations utilizing SAP, Oracle, and AS400 systems
  • Forecast Disallowed Write-Offs and Small Balance Write-Offs; determine root causes/drivers in supporting monthly rolling estimates and/or ABPs
  • Manage efforts in undercovering potential duplicate payments/deductions and remediation of unclaimed property amounts
  • Ensure safeguards are in place around the clearing of deductions and/or payments processed by our third-party broker (Acosta) via 2% Audits
  • SME for knowing various systems (Oracle, AS400, EoStar, SAP) and their flows of information that impact p&ls
  • Seek out opportunities through collaborative efforts with other teams to maximize value and/or identify cost savings; i.e., customer behaviors, tax implications, unclaimed property, etc.
  • Successfully articulate results to client leadership
  • Partner with Acosta to identify and eliminate waste; focus on the work that matters most between and among teams
  • Identify and analyze root cause of deductions entering into multiple systems from SAP; expeditiously work to resolve any erroneous items

 

Competencies/Skills:

  • Excellent interpersonal and customer service skills
  • Strategic thinking and strategy development
  • Strong written and verbal communication
  • Problem-solving, innovation, and analytical skills
  • Ability to lead and develop teams with minimal direction
  • Proficient in Microsoft Applications, including Microsoft Access and Excel required (pivot tables, macros, VBA, and v-lookups)
  • Strong attention to detail
  • Ability to work independently without direct supervision in a fast-paced environment
  • Understanding of Generally Accepted Accounting Principles
  • Ability to quickly learn and understand legacy and web based data systems
  • Successful demonstrated use of Oracle Data Tables and SQL

 

Education:

  • Bachelor's degree in Finance and/or Accounting required

 

Related Experience:

  • 4+ years of experience in Accounts Receivable, Cash Application, Finance or Accounting
  • Prior experience partnering with internal clients and external customers to resolve finance, accounting or cash application issues required
  • SAP FI, Accounts Receivable experience strongly preferred
  • Prior experience developing and maintaining in depth Microsoft Access databases and SQL queries

Growth Behaviors:

  • GROWTH MINDSET: Demonstrates curiosity. Welcomes failure as a learning opportunity.
  • SMART RISK: Makes bold decisions/recommendations.
  • EXTERNALLY FOCUSED: Understands the upstream and downstream implications of his/her work. Tracks and shares external trends, best practices or ideas.
  • PERFORMANCE DRIVEN AND ACCOUNTABLE: Has high performance standards. Outperforms her/his peers.
  • FAST/AGILE: Removes barriers to move faster. Experiments and adapts. Thrives under pressure and fast pace.
  • EMPOWERED: Brings solutions instead of problems. Challenges the status quo. Has the courage to take an unpopular stance.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class. Apply
Back to Top
 
+ READ FULL JOB DESCRIPTION

Stay up to date on job openings that match your skills & experience.

Sign Up now
At A Glance

Become part of our professional community to receive company information, news and upcoming events.

Join Now
Who We Are: The Coca-Cola Company
Coca-Cola Millennial Voices
Multicultural Leadership Council