Senior Associate, Data Exchange Specialist

What You'll Do:
Integrate with TPAs and Ben Tech partners in support of eligibility, enrollment, remittance, and billing data for new and inforce business.
Serve as a consultative partner to clients and TPAs by educating them on data structure, file specifications, and the operational impact of their data across downstream administration systems.
Implement complex electronic interfaces based on established timelines while maintaining strict inventory control of active integrations, dependent file streams, and in-flight implementations.
Manage multi-file integration environments, ensuring files are received, validated, and sequenced appropriately for system ingestion and downstream processing.
Review, audit, and validate test data across multiple related files and data sources to ensure quality, completeness, and alignment with business rules prior to production implementation.
Identify root causes of file discrepancies, mapping errors, transmission issues, or data inconsistencies across merged files, and recommend corrective actions.
Understand and articulate end-to-end data flow, including how files are received, validated, transformed, merged across multiple sources, and processed within New York Life systems.
Balance New York Life/LDEX standards regarding layout, data, and transmission protocols with client requirements, delivering compliant and scalable solutions for complex client environments.
Prepare and maintain documentation confirming the method of data exchange between New York Life and client/TPA, including file dependencies, mapping logic, merge requirements, and audit controls.
Partner with Production Support and IT to ensure successful receipt, mapping, merging, and processing of data.
Articulate complex file mapping and merge logic requirements clearly to IT and technical partners.
Drive accountability with internal teams and Ben Tech partners to meet key deliverables and milestone deadlines.
Troubleshoot and diagnose issues related to electronic data exchange, multi-file integrations, and system processing impacts.
Track file status and ensure metrics are reported accurately within Salesforce.
Develop and maintain support documentation, SOPs, and training materials for complex integration processes and data governance practices.
Proactively review and suggest improvements to existing procedures to enhance efficiency, data integrity, and scalability of complex integrations.
Serve as a subject matter expert for complex data exchange implementations and National Account integrations, providing guidance and mentorship to peers.

What You'll Bring:
Bachelor's Degree strongly preferred or minimum of 3 years relevant work experience required.
Prior experience working with clients, producers, TPAs, or Ben Tech partners preferred.
Strong understanding of complex data structures, file layouts, and electronic transmission methods preferred.
Demonstrated ability to analyze, audit, and interpret complex and high-volume data files, including multi-file data environments.
Experience managing file dependencies, merge logic, and reconciliation across multiple data sources preferred.
Strong planning, project management, and inventory control skills.
Proficient/advanced Microsoft Excel skills required (VLOOKUP, Pivot Tables, Macros).
Proficiency in Access preferred.
Experience with mainframe TSO and JCL scripting preferred.
Excellent organizational skills with ability to manage multiple complex implementations simultaneously and meet tight deadlines.
Excellent written and verbal communication skills with the ability to explain technical concepts to non-technical audiences.
Strong interpersonal and consultative skills.
Demonstrated ability to drive results and meet key milestones.
Ability to work independently while collaborating effectively across internal business partners.
Demonstrated leadership capability in a fast-paced, evolving environment.
Proven adaptability and willingness to embrace change and continuously improve processes.

Pay Transparency
Salary Range: $75,000-$95,000
Overtime eligible: Exempt
Discretionary bonus eligible: Yes
Sales bonus eligible: No
Actual base salary will be determined based on several factors but not limited to individual's experience, skills, qualifications, and job location. Additionally, employees are eligible for an annual discretionary bonus. In addition to base salary, employees may also be eligible to participate in an incentive program.