**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. He/she must possess strong organizational and communication skills and work with people at various levels and who can coordinate several projects simultaneously. The incumbent 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.
**Responsibilities:**
Automated ATBs:
* Obtain client’s ATB’s either from a client’s portal/ proprietary system, or by user submission;
* 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.
* Load saved .txt files to the FTP site for integration with SHARP;
* Monitor the ATB SS Inbox for confirmation/exception of file loads.
* Maintain an instructions 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;
* Maintain the schedule for pulling/receiving client ATB’s
Promotion Integration:
* Requires knowledge of the fields used to create a plan and event in sharp, and the ability to relate that knowledge to data and allowances as stored in a customer’s proprietary system.
* Requires the ability to work with a customer’s representative to define and request test files in the required format to successfully integrate with SHARP.
* Requires the ability to thoroughly test the integration points from inception thru production release.
DBW Support:
* Maintain, add or remove templates from the automated runs;
* Batch-load storecodes to the GenWeb database for use in the automated DBW generation process and monitor related exception reports;
* Collaborate with Claims Management to constantly enhance the functionality of the DBW; as well as identify additional, external client proprietary expense group codes.
* Insure the integrity of the DBW code and related templates.
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 creating sites and custom data views.
Contracts, New Item Forms and Price Change Notifications:
* Design, integrate and maintain all customer- required documentation, including creation and maintenance of workbooks for each SHARP family to include detailed copies of all documents/mapping, revisions, allowances, contract questions, & calculations on each form.
* Create and maintain customer infrastructure records to include Direct/Indirect X-Ref; Division, Allowance Definitions, CQ and Lump Sum Tables.
* Possess working knowledge of all GenWeb 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 and PDF Output Servers for US, Military & Canada, production and test environments, to insure 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 insure that all servers are in rotation, and jobs are not backing up.
* 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 UAT testing before moving to production.
* Provide troubleshooting and support services to the user community thru the Event Scheduler/Forms CDHELP site. Maintain excellent working relationships with Customers, Clients and Co-Workers by achieving a defined Service Level Compliance.
Contribute to the creation of Change Requests and Break/Fix's:
* By process improvement input, writing the technical documents, or both.
* Regression-test all Enhancements and Break/Fixes prior to deployment to production and participate in testing/signoff on weekend production deployments.
Leadership Skills:
* 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.
* Capable of Conducting Data Integration and Application Testing.
* Able to conduct and document weekly Team Calls.
Lead other Special Projects for the company, branch or department as needed
* Participate in the design/publication of the official Department Newsletter on a rotating basis.
* Partner with Specialty Brokers as needed to support BPS operations.
* Support additional Claims processes as requested by BPS operations.
**Qualifications:**
* Three years sales support or customer service experience in the food broker environment required.
* Two years experience with SHARP Sales Planning and/or SHARP Claims Teams preferred
* Proficient in forms software – FormFlow, Adobe and Excel to include:
a) Design of complex, multi-page forms to meet customer requirements;
b) Ability to write the .txt mapping document to convert pdf documents to excel.
* Proficient in MS Office (Excel, Word, Outlook and ASP.NET).
a) Advanced proficiency with Excel including but not limited to:
I. Ability to create v-lookups and pivot tables
II. Ability to Read, Write and Debug Visual Basic code for Application (Excel)
III. Ability to regularly use conditional formatting and to manipulate data using excel functions
b) High Level proficiency in Microsoft ASP.NET web forms development; xml; and java script (SharePoint)
c) Minimum proficiencies Word: defined by Level 1 Acosta University Training
d) Minimum proficiencies Outlook: defined by Level 1 and Level 2 Acosta University Training
* Strong interpersonal, organizational, administrative skills and time management skills
* Effective communication skills, including proficient use of visual application sharing software, e.g. WebEx, Live Meeting, etc.
* Excellent problem solving skills
* Able to analyze problems and define workable solutions for users of shared data.
* Willingness/Ability to learn new programs/processes and ability to identify process improvements.
* Able to operate a calculator, computer, printer, telephone, fax machine, scanner and copier.
Acosta Sales & Marketing is an Equal Opportunity Employer
Job ID
2015-84672
**Work City**
Overland Park
**PCN**
161508
**Work State**
US-KS
**Position Type**
Regular Full-Time
**Work Zip**
66214
**Starting average hours per week**
37.5 +