Data Entry Excel Jobs in Connecticut (NOW HIRING)

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: https://www.NFP.com.

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: https://www.ppibenefits.com

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 at carriers. The 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 timeframes 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, with accuracy and attention to detail, while protecting confidential information.
• Possess strong planning, organizational, problem-solving, time management, and decision-making abilities.
• Exhibit excellent oral and written communication skills, along with superior math and analytical skills.
• Be proficient in spreadsheet and database tools.
• Be self-directed, accurate, and detail-oriented, capable of operating independently, thinking creatively, and recommending enhancements to policies and procedures.
• Able to work from our Wallingford office on a hybrid schedule and when required.

• A Bachelor’s degree in Math or Data-related programs is preferred, along with 1-5 years of related work experience.

We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, at the end of the day, we exist to be there for others.

The base salary range for this position is $47,000.00 – $75,000.00. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

NFP and You... Better Together!

NFP is an inclusive Equal Employment Opportunity employer.