2,348,292open jobs
147,256companies
285,762added this week
Browse all
Salary
$90k – $120k per year
Location
Remote (United States)
Seniority
Senior · 5+ years exp
Employment
Full-Time

First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match

NFP

NFP is a leading insurance broker and consultant providing specialized property and casualty, corporate benefits, retirement, and individual solutions through its licensed subsidiaries and affiliates. NFP enables client success through the expertise of over 7,400 global employees, investments in innovative technologies, and enduring relationships with highly rated insurers, vendors, and financial institutions. NFP is the 5th largest benefits broker by global revenue, 5th best place to work in insurance and 6th largest US-based privately owned broker (Business Insurance); 9th commercial lines agency by P&C commercial lines revenue and 10th largest property and casualty agency (Insurance Journal); and 12th largest global insurance broker (Best's Review).

This a Full Remote job, the offer is available from: United States, Texas (USA)

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-REMOTE

Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,348,292 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Similar stack
Same company
In your city
$95k – $105k per year · Remote (United States) · Secret · 5+ years exp · Bachelor's Degree
Analytics
Power BI
Management
SharePoint
Apply
$120k – $130k per year · Remote (United States) · Full-Time · 3+ years exp · United States
Management
Confluence
Jira
Agile
Apply
$174k – $205k per year · Equity · Remote (United States) · 3+ years exp · Los Angeles · San Francisco · Boston · New York
Python
SQL
Databases
Snowflake
Databricks
AI/ML
Cursor
Claude Code
Model Context Protocol
dbt
AI Agents
DevOps
AWS
GitHub
Analytics
Tableau
Power BI
Fivetran
Looker
Dimensional Modeling
Apply
Remote (Brazil) · Full-Time · Brazil
Python
SQL
AI/ML
Pandas
NumPy
Machine Learning
Analytics
Power BI
Dimensional Modeling
Apply
Remote (United States) · Full-Time
Python
SQL
Analytics
ETL/ELT
Apply
See all jobs
This is one of many
2,348,292 more open roles from verified company boards, updated every day.