Sr. Data Analyst - Remote
This position has the potential to sit anywhere in the U.S. Who We Are We're NFP, a five-time Best Places to Work award winner in Business Insurance for 2017, 2018, 2019, 2020 and 2021. We are also recognized as an Elite 2018 Agency award winner named as a Top Employee Benefits Firm. We are a leading Insurance Broker and Consultant that provides Employee Benefits, Property & Casualty, and Retirement and Individual Private Client solutions to help our clients reach and realize their goals because we believe business is personal. Our personal commitment to our team and our clients have created long-lasting and successful relationships across our growing 300
nationwide offices and 17 international locations. To learn more, please visit:
https:
//www.nfp.com/ The Role at NFP As the Senior Data Analyst at NFP, you will be responsible for supporting the Implementation Leads in converting data from legacy agency management platforms to NFP's standard Operating Platforms. 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. Interact directly with customers, hosting meetings and tracking progress on decisions and cleanup. Collaborate with the agency and/or Project leads to facilitate 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, corrected and validated. Determine where custom scripting may be required, clarify the details and validate the results. Liaise with our conversion vendor to ensure project requirements are specified and discuss any conversion questions and impacts. 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 A Bachelor's degree or higher. Ability to travel up to 20%. Occasional after hours and weekend work will be required. 5
years' experience working with formatting data in Microsoft Excel, SQL or other database software. Advanced Microsoft Excel skills including lookups and other formulas, pivot tables, fuzzy logic and VBA. 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. Proven record to meet critical deadlines and handle a diverse workload. Must possess personal and business integrity with an energetic style demonstrated by a positive attitude and a strong work ethic. High attention to detail and ability to consider tasks from multiple angles to produce robust analyses. Preferred Requirements Insurance and/or brokerage experience. Microsoft SQL Server experience. Alteryx experience. Familiarity with agency operating systems. Experience with conversion of data from one system to another. Prior involvement with a large organization's system implementation. What We Offer NFP is 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. NFP and You Better. Together. NFP is an inclusive Equal Employment Opportunity employer.
Salary Range:
$80K -- $100K
Minimum Qualification
Data Science & Machine LearningEstimated Salary: $20 to $28 per hour based on qualifications.
nationwide offices and 17 international locations. To learn more, please visit:
https:
//www.nfp.com/ The Role at NFP As the Senior Data Analyst at NFP, you will be responsible for supporting the Implementation Leads in converting data from legacy agency management platforms to NFP's standard Operating Platforms. 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. Interact directly with customers, hosting meetings and tracking progress on decisions and cleanup. Collaborate with the agency and/or Project leads to facilitate 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, corrected and validated. Determine where custom scripting may be required, clarify the details and validate the results. Liaise with our conversion vendor to ensure project requirements are specified and discuss any conversion questions and impacts. 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 A Bachelor's degree or higher. Ability to travel up to 20%. Occasional after hours and weekend work will be required. 5
years' experience working with formatting data in Microsoft Excel, SQL or other database software. Advanced Microsoft Excel skills including lookups and other formulas, pivot tables, fuzzy logic and VBA. 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. Proven record to meet critical deadlines and handle a diverse workload. Must possess personal and business integrity with an energetic style demonstrated by a positive attitude and a strong work ethic. High attention to detail and ability to consider tasks from multiple angles to produce robust analyses. Preferred Requirements Insurance and/or brokerage experience. Microsoft SQL Server experience. Alteryx experience. Familiarity with agency operating systems. Experience with conversion of data from one system to another. Prior involvement with a large organization's system implementation. What We Offer NFP is 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. NFP and You Better. Together. NFP is an inclusive Equal Employment Opportunity employer.
Salary Range:
$80K -- $100K
Minimum Qualification
Data Science & Machine LearningEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
