Data Collections Analyst

Company: Aston Carter
Location: Corona
Posted on: September 15, 2023

Job Description:

The data collection analyst is responsible for the invoice-level data collects from its distribution network. This role is responsible for the integrity, alignment, cleansing and validation of the data. This data is used for reporting, forecasting, production, accruals, and promotional rebates across the enterprise. The data collection analyst acts as a subject matter expert on various business initiatives by providing guidance as necessary for data collection, maintenance, and analysis
Job Overview

• 
  
• 
  Analyze and audit depletion data against the reporting distribution partners internal systems to ensure data accuracy and data quality meet the agreed upon standards
  
  
• 
  Work with the bottler and VIP to identify the root cause of discrepancies
  
  
• 
  Audit case for case on a quarterly basis; a process that can take up to 4 weeks to complete for all 68 bottlers
  
  
• 
  Perform audits; daily, weekly, monthly, and quarterly volume and call point audits ensuring alignment in both internal and external systems
  
  
• 
  Manage the end-to-end process from creation to quarterly auditing of call points and their retail outlets ensuring alignment with outlet numbers, dba, address, class of trade, premise type, and reporting hierarchy
  
  
• 
  Responsible for auditing every call point on a quarterly basis. This will ensure proper reporting and accruals
  
  
• 
  Manage the matching process of reported outlets to the appropriate outlet master record
  
  
• 
  Work with leadership to write and maintain standard operating procedures for audits and assigned tasks
  
  
• 
  Protect information provided in confidence from outside sources (bottlers and other business partners) and ensure this information is not disseminated to any unauthorized parties
  
  
• 
  Protect information and materials provided to third parties (e.g., consultants, vendors, suppliers, bottlers) by ensuring appropriate procedures are followed and parties are bound by company confidentiality agreements as necessary.
  
  
• 
  Audit, Analyze, troubleshoot, and resolve errors and assist other team members or business partners with related data collection issues raised daily
  
  
• 
  Perform volume audits once a quarter, call point audits on a rolling 90 days (700+ call points) and analyze possible reporting issues and data alignments daily
  
  
  Skills & Qualifications:
  
  • 
    
  • 
    Bachelor's degree in statistics, business, data analytics or equivalent industry experience
    
    
  • 
    2+ years' experience of in-depth analytical and use of reporting tools with large data sets
    
    
  • 
    Highly effective analytical and problem-solving skill
    
    
  • 
    Proficiency in Microsoft Suite, including highly developed skills in Excel
    
    
  • 
    Ability to use and learn a variety of query and reporting tools
    
    
  • 
    Ability to respond to requests accurately and in a timely manner
    
    
  • 
    Ability to identify issues within highly detailed data
    
    
  • 
    Ability to develop a solution and/or business process
    
    
  • 
    Effective interpersonal and communication skills
    
    
  • 
    Strong organizational and analytical skills; decision making and problem solving
    
    
    About Aston Carter:
    Please Note: Scammers are posing as Aston Carter. We'll never contact you via Gmail, Telegram, or WhatsApp and we'll never solicit money from you.
    At Aston Carter, we're dedicated to expanding career opportunities for the skilled professionals who power our business. Our success is driven by the talented, motivated people who join our team across a range of positions - from recruiting, sales and delivery to corporate roles. As part of our team, employees have the opportunity for long-term career success, where hard work is rewarded and the potential for growth is limitless.
    Established in 1997, Aston Carter is a leading staffing and consulting firm, providing high-caliber talent and premium services to more than 7,000 companies across North America. Spanning four continents and more than 200 offices, we extend our clients' capabilities by seeking solvers and delivering solutions to address today's workforce challenges. For organizations looking for innovative solutions shaped by critical-thinking professionals, visit AstonCarter.com. Aston Carter is a company within Allegis Group, a global leader in talent solutions.
    The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
    If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888-237-6835 or email astoncarteraccommodation@astoncarter.com (%20astoncarteraccommodation@astoncarter.com) for other accommodation options. However, if you have questions about this position, please contact the Recruiter located at the bottom of the job posting. The Recruiter is the sole point of contact for questions about this position.

Keywords: Aston Carter, Corona , Data Collections Analyst, Accounting, Auditing , Corona, California