Archived listing. The details below describe a past opening.
Posting Description Who We Are: NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance who has also earned the WORK180 employer endorsement. 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. Summary of Job As the Senior Data Analyst at NFP, you will support Implementation Leads throughout the data conversion lifecycle, including the extraction, transformation, mapping, validation, and migration of data from legacy agency management systems to NFP's standard operating platforms. This role works closely with agencies, project teams, conversion vendors, and development resources to ensure converted data is accurate, complete, and delivered in accordance with implementation achievements. Responsibilities Gather and examine data from source systems available in multiple formats. Convert this data into uniform conversion templates using Microsoft Excel, SQL, Alteryx, and other Microsoft data and analytics tools. Work directly with customers to facilitate data-related meetings, communicate requirements, track decisions, and supervise data cleanup activities through completion. Collaborate with agency partners, Implementation Leads, and Project Leads to map data from source systems to destination platforms and resolve mapping questions or data discrepancies. Prepare, analyze, and format carrier, employee, and other configuration-related data for agency review, mapping decisions, and setup within the destination agency management system. Carry out detailed validation and reconciliation of converted data through reports, queries, and conversion tools to uncover data discrepancies, conversion issues, and extra cleanup requirements. Lead data review sessions with internal teams and agency collaborators to support data quality and ensure conversion activities are completed within established timelines. Develop a strong understanding of data flows across systems, including data, documents, transactions, and messages, to support accurate conversion and issue analysis. Track conversion issues and defects through resolution, ensuring corrections are completed and subsequently validated. Identify scenarios requiring custom conversion logic or scripting, document business and data requirements, and validate the resulting converted data. Serve as a liaison with conversion vendors to communicate requirements, address conversion questions, assess impacts, and support issue resolution. Collaborate with development and technical teams to find opportunities for new or enhanced conversion tools, automation, and processes. Monitor conversion achievements, dependencies, and work progress to ensure alignment with the overall implementation project plan. Identify data quality risks, anomalies, and trends, and recommend appropriate cleanup or remediation actions. Maintain clear records of mapping decisions, validation outcomes, conversion challenges, and other essential data conversion tasks. Participate in on-site agency events during key phases of the implementation process, as required. Requirements Bachelor's degree or equivalent combination of education and relevant professional experience. Over 5 years of experience in data analysis, data transformation, data conversion, or related roles using Microsoft Excel, SQL, Alteryx, database tools, or comparable technologies. Advanced Microsoft Excel skills, including complex formulas, lookup functions, PivotTables, VBA and data analysis techniques. Demonstrated experience analyzing large or complex datasets and identifying data quality issues, discrepancies, and patterns. Strong analytical and structured problem-solving skills with excellent attention to detail. Ability to understand source and destination data structures and translate business requirements into mapping and conversion requirements. Proven ability to prioritize multiple tasks, meet critical deadlines, and drive assigned work to completion with limited oversight. Ability to adapt to changing project requirements and business priorities. Strong written and verbal communication skills, including the ability to lead customer-facing meetings and clearly convey technical or data-related concepts to various audiences. Strong interpersonal and collaboration abilities with the capacity to work effectively across business, technical, vendor, and customer groups. High degree of personal and business integrity, accountability, initiative, and professionalism. Ability to travel ~ 10%. Ability to support occasional after-hours or weekend activities during critical conversion and implementation events. Preferred Requirements Experience within the insurance, brokerage, or agency management industry. Experience working with Microsoft SQL Server. Experience working with Microsoft Fabric, Dataflows Gen2, or comparable Microsoft data technologies. Experience with Alteryx or comparable data preparation and transformation tools. Familiarity with agency management or insurance operating systems. Experience converting or migrating data from one enterprise system to another. Experience in data mapping, transformation, validation, and reconciliation. Experience supporting large-scale system implementations, migrations, or enterprise transformation initiatives. Experience building or employing automation to streamline data preparation, conversion, validation, and reconciliation processes. 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 $90,000– $120,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. 2591490 Who We Are: NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance who has also earned the WORK180 employer endorsement. 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. Summary of Job As the Senior Data Analyst at NFP, you will support Implementation Leads throughout the data conversion lifecycle, including the extraction, transformation, mapping, validation, and migration of data from legacy agency management systems to NFP's standard operating platforms. This role works closely with agencies, project teams, conversion vendors, and development resources to ensure converted data is accurate, complete, and delivered in accordance with implementation achievements. Responsibilities Gather and examine data from source systems available in multiple formats. Convert this data into uniform conversion templates using Microsoft Excel, SQL, Alteryx, and other Microsoft data and analytics tools. Work directly with customers to facilitate data-related meetings, communicate requirements, track decisions, and supervise data cleanup activities through completion. Collaborate with agency partners, Implementation Leads, and Project Leads to map data from source systems to destination platforms and resolve mapping questions or data discrepancies. Prepare, analyze, and format carrier, employee, and other configuration-related data for agency review, mapping decisions, and setup within the destination agency management system. Carry out detailed validation and reconciliation of converted data through reports, queries, and conversion tools to uncover data discrepancies, conversion issues, and extra cleanup requirements. Lead data review sessions with internal teams and agency collaborators to support data quality and ensure conversion activities are completed within established timelines. Develop a strong understanding of data flows across systems, including data, documents, transactions, and messages, to support accurate conversion and issue analysis. Track conversion issues and defects through resolution, ensuring corrections are completed and subsequently validated. Identify scenarios requiring custom conversion logic or scripting, document business and data requirements, and validate the resulting converted data. Serve as a liaison with conversion vendors to communicate requirements, address conversion questions, assess impacts, and support issue resolution. Collaborate with development and technical teams to find opportunities for new or enhanced conversion tools, automation, and processes. Monitor conversion achievements, dependencies, and work progress to ensure alignment with the overall implementation project plan. Identify data quality risks, anomalies, and trends, and recommend appropriate cleanup or remediation actions. Maintain clear records of mapping decisions, validation outcomes, conversion challenges, and other essential data conversion tasks. Participate in on-site agency events during key phases of the implementation process, as required. Requirements Bachelor's degree or equivalent combination of education and relevant professional experience. Over 5 years of experience in data analysis, data transformation, data conversion, or related roles using Microsoft Excel, SQL, Alteryx, database tools, or comparable technologies. Advanced Microsoft Excel skills, including complex formulas, lookup functions, PivotTables, VBA and data analysis techniques. Demonstrated experience analyzing large or complex datasets and identifying data quality issues, discrepancies, and patterns. Strong analytical and structured problem-solving skills with excellent attention to detail. Ability to understand source and destination data structures and translate business requirements into mapping and conversion requirements. Proven ability to prioritize multiple tasks, meet critical deadlines, and drive assigned work to completion with limited oversight. Ability to adapt to changing project requirements and business priorities. Strong written and verbal communication skills, including the ability to lead customer-facing meetings and clearly convey technical or data-related concepts to various audiences. Strong interpersonal and collaboration abilities with the capacity to work effectively across business, technical, vendor, and customer groups. High degree of personal and business integrity, accountability, initiative, and professionalism. Ability to travel ~ 10%. Ability to support occasional after-hours or weekend activities during critical conversion and implementation events. Preferred Requirements Experience within the insurance, brokerage, or agency management industry. Experience working with Microsoft SQL Server. Experience working with Microsoft Fabric, Dataflows Gen2, or comparable Microsoft data technologies. Experience with Alteryx or comparable data preparation and transformation tools. Familiarity with agency management or insurance operating systems. Experience converting or migrating data from one enterprise system to another. Experience in data mapping, transformation, validation, and reconciliation. Experience supporting large-scale system implementations, migrations, or enterprise transformation initiatives. Experience building or employing automation to streamline data preparation, conversion, validation, and reconciliation processes. 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 $90,000– $120,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.