Data Integration Specialist REMOTE

Kentucky, USA
Apply Now

RESPONSIBILITIES

  • Automated Aged Trial Balance Reports for Claims (ATBs): 1. Obtain client’s ATB’s either from a client’s portal/proprietary system, or by user submission.2. Create or modify macros as needed to enable the conversion of the file to the correct format that will allow it to be saved in .txt format as required for ftp upload.3. Load saved .txt files to the ftp site for integration with Acosta Relay4. Monitor the ATB Sales Support Inbox for confirmation/exception of file loads.5. Maintain an instruction log of ATBs by Client containing detailed information onreceipt of data from client and proper processing/uploading of that data to create the ATBs6. Maintain the schedule for pulling/receiving client ATB’s

  • Promotion Integration:1. Requires knowledge of the fields used to create a plan and event in Acosta Relay, and the ability to relate that knowledge to data and allowances as stored in a customer’s proprietary system. 2.Requires the ability to work with a customer’s representative to define and request test files in the required format to successfully integrate with Acosta Relay. 3. Requires the ability tothoroughly test the integration points from inception thru production release.

  • Contracts, New Item Forms and Price Change Notifications: 1. Design, integrate and maintain all customer- required documentation, including creation and maintenance of workbooks for each Acosta Relay family to include detailed copies of all documents/mapping, revisions, allowances, contract questions, & calculations on each form.2. Create and maintain customer infrastructure records to include Direct/Division, Direct/Indirect X-Ref, Allowance Definitions, CQ and Lump Sum Tables.3.Possess working knowledge of all AR Main Menu database modules that integrate with forms (Client, Customer, Product, CBB, APL, ACust). Possess working knowledge of all Acosta systems that integrate with contracts (Order Entry, Promotion Table, Workflow, Security, and Event Scheduler, including daily monitoring of the Excel Output Servers for US, Military & Canada production, and test environments, to ensure that all servers are running at optimal levels. Track and report errors in real time. Monitor the Contract Director Queue as jobs are running to ensure that all servers are in rotation,and jobs are not backing up.4. Support the Automated Claims Template function by designing, mapping, and maintaining all Claims Templates (Repay Letters, Deduction Forms, Uncollectible Letters,Acosta MDF Letters, Invoice Discrepancies Letters, Check Request Letters, and Invalid Check Request Letters), to include thorough User Acceptance Testing (UAT) before moving to production. 5. Provide troubleshooting and support services to Forms Captains thru the Acosta Data Solutions site. Maintain excellent working relationships with Customers, Clients and Co-Workers by achieving a def QUALIFICATIONS

  • Experience Requirement (i.e. 5 yrs category mgmt or 3 yrs food brokerage):1. Three years sales support or customer service experience in the food broker environment required.2. Two years experience with SHARP Sales Planning and/or SHARP Claims Teams preferred

  • Knowledge, Skill and Ability Requirements (i.e. “plan-a-gram” software expertise, presentation skills):1. Ability to effectively participate in triage efforts whether they be onsite or via remote to ensure to ensure priority is given to issues considered critical by the business2. Accepts accountability for job performance; proactively informs others when he/she encounters problems that may limit his/her ability to meet expectations3. Willing to accept change as a normal part of doing business, maintaining a positive attitude, and exhibiting constructive work behaviors during periods of transition4. Meets work and attendance expectation; informs others in advance when commitments cannot be fulfilled, maintaining objectivity5. Actively support organizational goals and values; align actions around organizational goals; give priority to organizationalneeds and concerns when making decisions6. Willing to set aside personal beliefs and assumptions while maintaining an objective point of view; keeps an open mind and listens to other thoughts andopinions7. Conveys ideas clearly and succinctly; tailor the message to the audience; deliver the information in a manner that is accurate and compelling8. Must be comfortable working with Microsoft Office products (word, ppt and excel), possessing the ability to create v-lookups, pivot tables, and VBA.9. Must be comfortable conducting and leading video calls and screen-sharing fordemo purposes. 10. High level proficiency in Microsoft ASP .NET web forms development, xml, and java script (SharePoint) Acosta/ Mosaic North America is an Equal Opportunity Employer The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Mosaic reserves the right to modify all or part of any job descriptions at its discretion inorder to meet and or exceed the needs of the business. We are committed to providing accommodations for persons with disabilities. If you require accommodation, we will work with you tomeet your needs, to the extent required by law By submitting your application you agree with and accept the Acosta Privacy Statement and Terms of Conditions. US: http://acosta.jobs/privacy-policy-us/Canada: http://acost ABOUT US Acosta and Mosaic are the sales and marketing powerhouses behind the most recognized and proven brands with top retailers in the United States and Canada. We offer flexible services that maximize efficiency. Acosta has the talent and technology to build data-, reach- and relationship-driven strategies to execute those strategies, and the tools to monitor, track and optimize metrics-based results for customers and retailers. Acosta and its subsidiaries, in good faith, believes that this posted range of compensation is the accurate range for this role at the time of this posting. Acosta may ultimately pay more or less than the posted range depending on candidate qualifications and locations. This range may be modified in the future. Acosta et Mosaic sont les moteurs des ventes et du marketing derrière les marques les plus reconnues et éprouvées avec les meilleurs détaillants aux États-Unis et au Canada. Nous offrons des services flexibles qui maximisent l'efficacité. Acosta possède le talent et la technologie pour élaborer des stratégies axées sur les données, la portée et les relations pour exécuter ces stratégies, ainsi que les outils pour surveiller, suivre et optimiser les résultats basés sur des mesures pour les clients et les détaillants. A Data Integration Specialist is a self-starter with the ability to understand the flow of information from Acosta Master Data and from Client/Customer proprietary systems; and to control and govern the data integration processes used to support Acosta applications. He/she must possess strong organizational and communication skills and work with people at various levels and who can coordinate several projects simultaneously.- He/She must understand Visual Basic for Applications (VBA), SharePoint (ASP.NET), SHARP, GenWeb, Remote Desktop, FormFlow, Adobe LiveCycle, Microsoft Word and Excel. The ability to design, test, implement, debug and execute solutions that meet specifications is critical.- This position integrates with Hub Managers, Customer Managers, Business Managers, Business Manager Assistants, Claims Associates, Business Process Facilitators and others, and demands the ability to deliver exceptional customer service. A Data Integration Specialist works as part of a cohesive team that regularly integrates with and assists other teams. Acosta, and its subsidiaries, is an Equal Opportunity Employer Job Category: Sales Support Position Type: Full time Business Unit: Corporate Salary Range: $37,400.00 - $56,100.00 Req ID: 105

Apply Now