The Onboarding Data Integrations Analyst works with project teams to implement data files for new client configurations. These integrations fall across one or more of the following areas: inbound HRIS census and benefits conversion data; outbound payroll deduction instruction files and reconciliation back feed files; outbound carrier eligibility and enrollment files; ad hoc inbound/outbound integrations for supplemental integrations like wellness, 401k, reporting, and various needs.
The Gig:
- Responsibility for all phases of new data exchange development; documenting, updating, and communicating business requirements, 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
What you need to make the cut:
- Administrative outsourcing analyst or equivalent industry experience; programming/coding experience within SaaS a plus
- Proven experience with payroll and/or export files
- Understanding of payroll, EDI 834 file formats
- Experience with various programming languages (demonstrating the ability to learn – e.g. VBA, VBScript, JavaScript, macros and scripts)
- XML/XSL proficiency
- Intermediate Excel skills
- 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
The pay range for this position is 60K to 81K per year (pay to be determined by the applicant’s education, experience, knowledge, skills, and abilities, as well as internal equity and alignment with market data).
This role is eligible to participate in the annual bonus incentive plan.