NFP, an Aon company, is looking to solve the problem of converting data from legacy operating systems to NFP’s standard Operating systems
Requirements
- Advanced Microsoft Excel skills including lookups, other formulas and pivot tables
- 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
- Strong analytical skills and creative problem-solving capabilities
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
- 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
Other
- A Bachelor’s degree or higher
- Ability to travel up to 20%
- Occasional after hours and weekend work will be required
- Self-motivated with the ability to drive tasks to completion without major oversight
- Professional presentation skills and strong interpersonal skills
