Extract, transform and map data from legacy agency systems into NFP platforms
Validate and reconcile converted data to find discrepancies and cleanup needs
Lead customer meetings and data review sessions to track decisions and cleanup
Serve as liaison with conversion vendors and resolve conversion issues
Track conversion defects through resolution and confirm the fixes are validated
From the employer’s posting
extraction, transformation, mapping, validation, and migration of data from legacy agency management systems
Carry out detailed validation and reconciliation of converted data through reports, queries, and conversion tools
Work directly with customers to facilitate data-related meetings, communicate requirements, track decisions, and supervise data cleanup activities through completion.
Serve as a liaison with conversion vendors to communicate requirements, address conversion questions, assess impacts, and support issue resolution.
Track conversion issues and defects through resolution, ensuring corrections are completed and subsequently validated.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
SQL
VBA
Alteryx
Excel
SQL Server
Where the posting names them
Convert this data into uniform conversion templates using Microsoft Excel, SQL, Alteryx, and other Microsoft data and analytics tools.
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.
Experience working with Microsoft SQL Server.
Advanced Microsoft Excel skills, including complex formulas, lookup functions, PivotTables, VBA and data analysis techniques.
Experience with Alteryx or comparable data preparation and transformation tools.
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. #LI-LL1 #LI-REMOTE 2591490
About NFP
People
About 60,000 in 2025, about the same as the year before.Annual report (SEC Form 10-K)
Company
Listed as AON.
Demand for Analyst roles
New Analyst postings at the employers we follow are up 25% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.