Data Analyst Jobs

About The Position

Requirements

• Demonstrated proficiency and advanced functions within Excel, including pivot tables, creating and using macros and the ability to manage large volumes of data.
• 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.

Nice To Haves

• Experience with enrollment platforms and CRMs, preferred.

Responsibilities

• 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.

Benefits

• competitive salary
• PTO & paid holidays
• 401(k) with match
• exclusive discount programs
• health & wellness programs