Operations Analyst - Data​/EDI; Hybrid Wallingford, CT

Who We Are

NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit:

NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit:

This role will support PPI Benefit Solutions
, a part of NFP. PPI Benefit Solutions is a service-first company delivering end-to-end benefits administration services and technology, with a focus on client and partner needs. To learn more, please visit:

The Account Operations Data Analyst will perform a variety of processes in support of business activities, including data collection, aggregation, and analysis. You will provide technical support during and after the implementation of healthcare electronic data interchange applications. The role is responsible for processes such as imports/exports, data file creation, and testing with stakeholders, as well as reconciliation to ensure accurate eligibility and billing records both internally and  analyst will use Excel at an advanced level, along with various information systems, databases, and technology tools related to assigned areas.

Additionally, you will initiate appropriate and necessary communication with management, carriers, clients, brokers, and vendors.

This is a full-time opportunity working a hybrid schedule from our Wallingford, CT office.

• Perform testing, implementation, revision, and maintenance of electronic data files with trading partners and clients, including benefit eligibility data files, demographic files, and payroll deduction files.
• Follow procedures to resolve data discrepancies with clients and vendors weekly, requiring excellent follow-up and communication skills, with a focus on customer experience.
• Conduct data review and import/export activities for new client implementations and established client renewals and changes. Efficiently complete tasks such as comparing data from multiple sources using Excel and other formats, performing imports or exports to/from PPI and vendor systems, and reconciliation to ensure accurate records.
• Support trading partners’ file delivery through established FTP and SFTP procedures, troubleshooting collaboratively to ensure timely and successful data receipt. Assist with data entry of eligibility into various systems with high accuracy and within required time frames as needed.
• Analyze file transmissions and respond to inquiries regarding issues, potentially handling documentation and reports. Produce, maintain, and distribute reports in both production environments and on an ad hoc basis. Identify, develop, and document procedural and systematic recommendations to improve efficiency and quality.
• Provide ongoing updates to management and seek assistance as needed. Assist in developing business requirements for the department’s IT development projects. Act as a technical resource and assist in staff training as requested. Handle additional needs and special projects as directed.

• Demonstrated proficiency and advanced functions within Excel, including pivot tables, creating and using macros and the ability to manage large volumes of data.
• Experience with enrollment platforms and CRMs, preferred.
• Provide prompt, courteous, and excellent service at an acceptable cost to all customers, while operating in accordance with State and Federal law, the company’s Statement of Business Practices, Affirmative Action, and other standards.
• Actively cooperate and interact with all entities of NFP.
• Handle extensive employee and financial data, including premiums and PPI revenue,…