Data Analytics Associate

Hanwha Techwin America • Teaneck, NJ

22h

About The Position

The Data Analytics Associate owns Hanwha Vision America's channel credit operations and day-to-day sell-out reporting. The role reviews distributor Ship & Debit, promotion, and rebate claim files in Excel; validates claims against approved price agreements and quotes; communicates results and follow-ups to distribution partners in English; and coordinates with Accounting (AR) to issue corresponding credits. The associate also supports the sales organization by answering ad-hoc sell-out questions from RSMs and sales leadership with clear, accurate analysis. Accuracy, reliability, organized documentation, and clear communication are valued. Training on the company's claim processes and templates is provided.

The position is temporary, located in Teaneck, New Jersey, and hiring is through the third-party agency Hanwha Vision America identifies as Hanwha Vision America (HVA), an affiliate of the Hanwha Group and an industry-leading provider of network video surveillance products and end-to-end security solutions.

Requirements

• Approximately 2 years of experience in sales operations, sales analysis, claims/billing/AR, order management, or channel (distributor) support.
• Working knowledge of Excel, including sorting and filtering, basic formulas such as SUM, IF, and VLOOKUP, and pivot tables.
• Fluency in written and spoken English.
• Strong attention to detail with numbers and an ability to check discrepancies.
• Organized, dependable follow-through, including tracking multiple open items to completion without reminders.
• Professional and courteous written communication suitable for external partners.
• Bachelor's degree or equivalent practical experience.

Nice To Haves

• Korean proficiency; preferred but not required.
• Experience in the security, electronics, or technology distribution channel.
• Exposure to an ERP system such as SAP or a CRM such as Salesforce.
• Experience supporting a field sales team with data requests and reporting.

Responsibilities

• Review monthly Ship & Debit, promotion, and rebate claim files submitted by distributors; validate claimed items, quantities, and amounts against approved price agreements and quotes in Excel.
• Identify discrepancies and over- or under-claims, document approval and denial reasons line by line, and prepare review summaries for manager approval.
• Communicate claim results to distributor counterparts in professional written English, explain denial reasons, request missing documentation or evidence, and follow up until each case is closed.
• Coordinate with Accounting (AR) to process approved credit and debit memos; track issued credits and reconcile open balances each month.
• Maintain organized monthly claim folders and raw-versus-reviewed trackers so reviews remain traceable and audit-ready.
• Prepare recurring channel reports, including monthly STEP sales reports with partner-level sell-out summaries and pivot tables, using established templates.
• Track distributor inventory levels and support monthly inventory analysis covering stock levels, weeks of supply, and aging, using provided data and templates.
• Work with RSMs, BDMs, and sales leadership to clarify ad-hoc sell-out questions, select relevant data, and deliver Excel summaries with a short written takeaway from request clarification through delivery.
• Support monthly sales data housekeeping and prepare presentation materials as needed.

What This Job Offers

• Career Level: Entry Level