Job Description
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: https://www.NFP.com.
As theData Analystat NFP, you will be responsible for supporting the Implementation Leads in converting data from legacy operating systems to NFP’s standard Operating systems. You will report directly to the Director of Data Conversions.
Responsibilities:
• Obtain data from source systems in various different formats. Must be able to format the data into a standard template, often using Microsoft Excel, Microsoft SQL, Alteryx or other analytics applications.
• Collaborate with the agency and/or Project leads to facilitate cleanup and complete mapping/translating the data from source to destination.
• Assist with the preparation and formatting of Carrier and Employee lists for discussions with the agency, finalize information for mappings, and configuration setup in the agency management system.
• May be required to attend on-site events with the agency during specific points in the implementation process.
• Validate data using various reports and conversion tools to determine any conversion issues or further cleanup as needed.
• Facilitate data reviews to ensure on-time completion and data quality.
• Become knowledgeable in the flow of information (data/documents/transactions/messages).
• Track conversion issues to ensure these are reported, fixed and validated.
• Collaborate with the development team on any tooling requirements for conversion projects.
• Ensure various milestones are met in accordance with the project plan and timeline.
Requirements:
• 2-3 years Brokerage / Insurance Agency Management System experience
• A Bachelor’s degree or higher.
• Ability to travel up to 20%.
• Occasional after hours and weekend work will be required.
• Advanced Microsoft Excel skills including lookups, other formulas and pivot tables.
• Strong analytical skills and creative problem-solving capabilities.
• Self-motivated with the ability to drive tasks to completion without major oversight.
• Ability to take on a variety of projects and adapt to changing business needs.
• Professional presentation skills and strong interpersonal skills.
• High attention to detail and ability to consider tasks from multiple angles to produce robust analyses.
Preferred Requirements:
• Alteryx experience.
• Microsoft SQL Server experience.
• Experience with conversion of data from one system to another.
• Prior involvement with a large organization’s system implementation.
• Reside within the East Coast time zone
What We Offer:
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 $85,000 to $100,000. 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.