Data Integration Specialist (Remote)

Work State US
Job ID
2022-208019
Work City
Anywhere
PCN
259246
Position Type
Regular Full-Time
Work Zip
00000

Overview

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. They must possess strong organizational and communication skills, work well with others at various levels, and manage several projects simultaneously. The applicant must understand Visual Basic for Applications (VBA), SharePoint (ASP.NET), Acosta Relay, GenWeb, Remote Desktop, Microsoft Word, and Excel.

 

This is a remote (work from home) position

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 Relay
    4. Monitor the ATB Sales Support Inbox for confirmation/exception of file loads.
    5. Maintain an instruction log of ATBs by Client containing detailed information on receipt of data from client and proper processing/uploading of that data to create the ATBs
    6. 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 to thoroughly 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 defined Service Level Compliance.
  • Authorized Product Listing (APL)

    1. Work with BMA to obtain store code listing from customer
    2. Define process for placing customer information to APL upload template for uploading
    3. Work error reports to find items that may need a cross reference set up (APL X-ref table)
    4. Work with BM/BMA on items that the X-Ref is not obvious.
    5. Upload corrected APL file.

  • Dovico Administration (Time Tracking)
    1. Set up clients/associates in Dovico system.
    2. Set up weekly branch reporting for P&L owners.
    3. Trouble shoot any associates issues.
    Contribute to the creation of Change Requests and Break/Fix's:
    1. By process improvement input, writing the technical documents, or both.
    2. Regression-test all Enhancements and Break/Fixes prior to deployment to production and participate in testing/signoff on production deployments.

  • Leadership Skills:
    1. Capable of Leading a Task Force to include assessing the scope of work, leading conference calls, assigning tasks, and collaborating with impacted parties to insure a successful deployment.
    2. Capable of Conducting Data Integration and Application Testing.
    3. Able to conduct and document monthly Team Calls.

    Lead other Special Projects for the company, branch or department as needed

  • Support additional Claims processes as requested by BPS operations.
    SharePoint Administration and Maintenance:

  • Must be able to build, administer and maintain SharePoint sites for the DMS department, and other Acosta Teams, as requested, by supporting sites and custom data views.

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 business
    2. Accepts accountability for job performance; proactively informs others when he/she encounters problems that may limit his/her ability to meet expectations
    3. Willing to accept change as a normal part of doing business, maintaining a positive attitude, and exhibiting constructive work behaviors during periods of transition
    4. Meets work and attendance expectation; informs others in advance when commitments cannot be fulfilled, maintaining objectivity
    5. Actively support organizational goals and values; align actions around organizational goals; give priority to organizational needs and concerns when making decisions
    6. Willing to set aside personal beliefs and assumptions while maintaining an objective point of view; keeps an open mind and listens to other thoughts and opinions
    7. Conveys ideas clearly and succinctly; tailor the message to the audience; deliver the information in a manner that is accurate and compelling
    8. 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 for demo purposes.
    10. High level proficiency in Microsoft ASP .NET web forms development, xml, and java script (SharePoint)

Acosta Sales & Marketing is an Equal Opportunity Employer

 

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://acosta.jobs/privacy-policy-ca/

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed