Data Analytics Associate
Temporary (agency-hired) data analyst at a video surveillance equipment maker: reviews distributor Ship & Debit, promotion, and rebate claims in Excel, validates amounts against price agreements, coordinates credit memos with Accounting, and produces sell-out, channel, and inventory reports for the sales team. Core tools are Excel (formulas, pivot tables) with optional SAP/Salesforce exposure.
- Compensation
- Not disclosed
- Location
- Teaneck, NJ, US
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 2+ years
- Category
- Data analytics
- Posted
Skills
Must have
- ~2 years in sales operations, sales analysis, claims/billing/AR, order management, or channel (distributor) support
- Working knowledge of Excel: sorting/filtering, basic formulas (SUM, IF, VLOOKUP), pivot tables
- Fluency in written and spoken English
- Strong attention to detail with numbers
- Organized, dependable follow-through on many small open items
- Professional written communication suitable for external partners
- Bachelor's degree or equivalent practical experience
Nice to have
- Korean proficiency
- Experience in the security, electronics, or technology distribution channel
- Exposure to an ERP system (e.g., SAP) or CRM (e.g., Salesforce)
- Experience supporting a field sales team with data requests and reporting
Full description
Position: Data Analytics Associate (Temp)
Location: Teaneck, NJ
Hire will be through 3rd party agency
Hanwha Vision America (HVA), formerly known as Hanwha Techwin America (HTA), is an affiliate of the Hanwha Group, a Fortune Global 500 company. HVA is an industry-leading provider of advanced network video surveillance products, including IP cameras, storage devices, and video management systems founded on world-class technologies. We offer end-to-end security solutions and have achieved global success across various industry verticals, including retail, transportation, education, banking, healthcare, hospitality, and airports.
The Data Analytics Associate owns Hanwha Vision America's channel credit operations and day-to-day sell-out reporting. The core of this role is reviewing distributor claim files (Ship & Debit, promotions, rebates) in Excel, validating claimed amounts against approved price agreements, communicating results and follow-ups to our distribution partners in English, and working with Accounting (AR) to issue the corresponding credits. The role also serves as a go-to analyst for the sales organization — fielding ad-hoc sell-out questions from RSMs and sales leadership and turning them into clear, accurate answers. This is a detail-driven operations and analysis role: we value accuracy, reliability, organized documentation, and clear communication. Training on our specific claim processes and templates is provided.
Key Responsibilities
- Claim review — Review monthly Ship & Debit (S&D), promotion, and rebate claim files submitted by distributors; validate claimed items, quantities, and amounts against approved price agreements and quotes in Excel.
- Validation & documentation — Identify discrepancies and over/under-claims, document approval and denial reasons line by line, and prepare clean review summaries for manager approval.
- Distributor communication — 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.
- Credit processing (AR) — Coordinate with the Accounting team (AR) to process approved credit memos and debit memos; track issued credits and reconcile open balances each month.
- Records & trackers — Maintain organized monthly claim folders and trackers (raw vs. reviewed), keeping every review traceable and audit-ready.
- Recurring sales reports — Prepare recurring channel reports such as the monthly STEP sales report (partner-level sell-out summaries with pivot tables), following established templates.
- Inventory analysis — Track distributor inventory levels and support monthly inventory analysis (stock levels, weeks of supply, aging) using provided data and templates.