Sr. Data Conversion Analyst

NFP Corp•West Lake Hills, TX
•$90,000 - $120,000•Remote

About The Position

As the Senior Data Analyst at NFP, the Sr. Data Conversion Analyst supports Implementation Leads throughout the data conversion lifecycle, including extraction, transformation, mapping, validation, and migration of data from legacy agency management systems to NFP's standard operating platforms. The 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. The analyst gathers and examines data from source systems in multiple formats and converts it into uniform templates using tools such as Microsoft Excel, SQL, Alteryx, and other Microsoft data and analytics tools. The role facilitates customer-facing data meetings, supports mapping and cleanup decisions, prepares configuration-related data, and performs detailed validation and reconciliation. It also tracks issues through resolution, identifies risks and opportunities for automation, maintains conversion records, and monitors progress against implementation plans. Participation in on-site agency events may be required during key implementation phases.

Requirements

  • Bachelor's degree or an 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.
  • 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 ability to lead customer-facing meetings and explain technical or data-related concepts to varied audiences.
  • Strong interpersonal and collaboration abilities, including working effectively across business, technical, vendor, and customer groups.
  • High degree of personal and business integrity, accountability, initiative, and professionalism.
  • Ability to travel approximately 10%.
  • Ability to support occasional after-hours or weekend activities during critical conversion and implementation events.

Nice To Haves

  • Experience in 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 using automation to streamline data preparation, conversion, validation, and reconciliation processes.

Responsibilities

  • Gather and examine data from source systems in multiple formats and convert it 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 oversee data cleanup activities through completion.
  • Collaborate with agency partners, Implementation Leads, and Project Leads to map source data to destination platforms and resolve mapping questions or discrepancies.
  • Prepare, analyze, and format carrier, employee, and other configuration-related data for agency review, mapping decisions, and setup in the destination agency management system.
  • Validate and reconcile converted data using reports, queries, and conversion tools to identify discrepancies, conversion issues, and further cleanup needs.
  • Lead data review sessions with internal teams and agency collaborators to support data quality and keep conversion activities on schedule.
  • Develop an understanding of data flows across systems, including data, documents, transactions, and messages, to support conversion accuracy and issue analysis.
  • Track conversion issues and defects through resolution and validate completed corrections.
  • Identify scenarios requiring custom conversion logic or scripting, document business and data requirements, and validate resulting converted data.
  • Liaise with conversion vendors to communicate requirements, address questions, assess impacts, and support issue resolution.
  • Collaborate with development and technical teams to identify opportunities for new or enhanced conversion tools, automation, and processes.
  • Monitor conversion achievements, dependencies, and work progress for alignment with the overall implementation project plan.
  • Identify data quality risks, anomalies, and trends, and recommend cleanup or remediation actions.
  • Maintain clear records of mapping decisions, validation outcomes, conversion challenges, and other essential conversion tasks.
  • Participate in on-site agency events during key implementation phases as required.

Benefits

  • Paid time off
  • Paid holidays
  • 401(k) with match
  • Exclusive discount programs
  • Health and wellness programs
  • May be eligible for performance-based incentives
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service