Sr. Data Conversion Analyst

Aon Plc
Austin, TX, United States
1 day ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$90,000 - $120,000
Working hours
Regular working hours

Tech stack

Microsoft Excel Data Analysis Big Data Data Cleansing Data Conversion Data Mapping Data Transformation Data Migration Data Structures Excel Formulas Microsoft Data Access Components Microsoft SQL Server
+10 more
Pivot Tables SQL Databases Data Streaming Enterprise Software Applications Microsoft Fabric Vba Programming Language Data Management Tools for Reporting Database Tools and Utilities Alteryx

Job description

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.

Benefits & conditions

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.

About the company

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: .

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…