Salary
💰 $52,000 - $81,000 per year
Tech Stack
JavaScriptSQLVBA
About the role
- Responsibility for all phases of new data exchange development; documenting, updating, and communicating business requirements, executing the configuration of the files, overseeing testing, and facilitating on-time launch
- Communication with clients and vendors regarding requirements gathering and analysis
- Coordination with project team members to understand client-specific benefits structure, file layouts, field mappings, and profiles
- Detailed documentation and configuration of files, along with secure file transfer setup and testing
- Coordination with client and vendor contacts for meetings, specifications layout and testing
- Coordination with project manager to maintain project tracking documentation and status reports
- Primary link between internal and external parties to document all requirements for specifications for data exchanges across assigned clients/vendors
- Use of industry file formats such as ANSI 834
- Use of tools such as JavaScript/XML/XLS; Beyond Compare, SQL, Access
- Peer assistance on quality assurance, defect tracking, and resolution
- Participation in status discussions raising risk as needed
- Engagement in a culture of continuous improvement
- Exceptional customer service to clients and internal teams
- Ownership of the transition process from the onboarding phase to the ongoing, steady-state (business as usual) environment, which includes documentation, detailed discussions, and issue resolution.
Requirements
- Administrative outsourcing analyst or equivalent industry experience; programming/coding experience within SaaS a plus
- Experience with variousprogramming languages (demonstrating the ability to learn – e.g. VBA, VBScript, JavaScript, macros and scripts)
- XML/XSL proficiency
- Intermediate Excel skills
- Understanding of payroll, EDI 834 file formats
- Strong organization skills and ability to interact with internal business partners (coordinating between functional requirements definition and other resources executing configuration)
- Ability to work independently with minimal guidance
- Ability to handle multiple client assignments, with overlapping timelines
- Critical thinking skills and ability to solve problems; detail-oriented with a high degree of accuracy and follow through
- Ability to work with large data sets, recognizing data patterns
- Ability to facilitate and conduct meetings with clients and vendors, capturing documentation and identifying action items
- Cross-functional project participation
- BS preferred, ideally in Business, Computer Science, or related field of study