Program Coordinator (Excel & Reporting)

Job Title: Program Coordinator (Excel & Reporting) Location: Seymour, CT. Type: Contract temp to hire. Salary: $24- 26hr. DOE + Excellent Benefits Job Summary Reporting to the Director Program Management, Technical Lead, the Program Management Analyst supports the execution of customer account management activities including tracking and reporting customer engagement metrics, preparing data for Quarterly Business Reviews, monitoring accounts receivable, excess inventory, forecast versus PO backlog planning, and other key business metrics. Reporting to the VP of Business Development, the Program Management Analyst also supports marketing and customer acquisition efforts through internet research, software tools, social media, webinars, email campaigns, and events. The role conducts market research, analyzes customer segments, competitor offerings, and market conditions to support business growth initiatives. Essential Job Functions Enter and close all SOWFs (quotes, hard orders, and rev ups). Deliver quotes and follow up for customer feedback. Process all new customer purchase orders. Complete contract reviews, including preparation of contract review packages, kickoff forms, purchase orders, and terms & conditions documentation. Obtain required approval signatures. Prepare PO Kickoff Forms. Assemble and scan complete contract packages to cloud storage. Enter sales orders and follow up for work order creation. Enter and document DPAS ratings for rated government orders. Create Manufacturing Change Notices (MCNs) and obtain supporting documentation. Execute work order and sales order revisions. Track consigned material deliveries and follow up with customers. Process inbound consigned materials and obtain PCR purchase orders. Resolve receiving discrepancies and coordinate customer approvals. Create PRE work orders for altered parts. Coordinate shipment requests for customer-owned parts. Schedule, initiate, and execute excess material sellbacks. Enter and transact ZZ lines. Manage all sales order dates. Create SOAR forms as required. Resolve and collect overdue accounts receivable with customer accounts payable departments. Request, upload, and process First Article Inspection (FAI) reports and associated billing. Enter and invoice milestone payments and document milestone discounts. Maintain customer FTP site access and transfer customer files as required. Run shortage reports and coordinate shortage resolution activities. Liaise between purchasing and customers on customer-supplied material purchase orders. Request and follow up on customer PO change orders. Process all PO updates. Make and document changes to sales orders and work orders. Scan purchase order change orders to cloud storage. Secure approval and funding for unforeseen NRE expenses and process associated billing. Send shipment notifications to customers. Respond to customer requests and inquiries. Knowledge, Skills & Abilities (KSAs) Ability to work independently in a fast-paced environment. Strong multitasking, organizational, and prioritization skills. Excellent verbal and written communication skills. Strong attention to detail and accuracy. Positive, professional, and customer-focused attitude. Strong analytical and problem-solving abilities. Qualifications Bachelor's degree in Marketing or a related field preferred. 3-5 years of sales and/or marketing experience. Experience with Microsoft Office applications. Experience with CRM systems and marketing automation software. Experience using social media platforms for business outreach. Physical Requirements Frequent standing, walking, sitting, reaching, handling, and communication activities. Ability to frequently lift and/or move up to 10 pounds and occasionally up to 25 pounds. Ability to perform work requiring close vision, distance vision, color vision, peripheral vision, depth perception, and focus adjustment. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions. Work Environment Primarily office environment with occasional exposure to moving mechanical parts. Reasonable accommodations may be made to enable individuals with disabilities to perform essential job functions. Personal Protective Equipment (PPE) Specific items of clothing and/or equipment may be required based on:Company policy. Safety Data Sheet (SDS) requirements. OSHA regulations. About Us Company Overview Founded in 2010, Top Prospect Group was created with a focus on matching high-quality candidates with top clients while fostering an environment where success is shared by all. In 2023, the company was acquired by HW Staffing Solutions, expanding its service offerings to include technology and professional services. #J-18808-Ljbffr Top Prospect Group