Sr. Data Conversion Analyst

New
J
JobgetherInsurance technology
Based in the United StatesFull-TimeSenior
SalaryAnnual base salary ranging from $90,000 to $120,000, depending on experience, education, credentials, certifications, skills, responsibilities, and geographic location.
Apply NowOpens the employer's application page

Job Details

Experience
More than 5 years of experience in data analysis, data transformation, data conversion, or related roles.
Required Skills
SQLData AnalysisMicrosoft SQL ServerMicrosoft Excel

Requirements

  • Bachelor's degree or an equivalent combination of education and relevant professional experience.
  • More than 5 years of experience in data analysis, data transformation, data conversion, or related roles.
  • Hands-on experience with Microsoft Excel, SQL, Alteryx, database tools, or comparable data technologies.
  • Advanced Microsoft Excel skills, including complex formulas, lookup functions, PivotTables, VBA, and data analysis techniques.
  • Ability to analyze large or complex datasets and identify data quality issues, inconsistencies, discrepancies, and patterns.
  • Ability to understand source and destination data structures and translate business needs into mapping and conversion requirements.
  • Ability to manage multiple priorities, meet deadlines, and drive activities to completion with limited oversight.
  • Written and verbal communication skills to lead customer-facing meetings and explain technical or data-related concepts to different audiences.
  • Ability to collaborate across business, technical, vendor, and customer teams.
  • Experience in insurance, brokerage, or agency management is preferred.
  • Experience with Microsoft SQL Server; familiarity with Microsoft Fabric, Dataflows Gen2, or comparable Microsoft data technologies is preferred.
  • Experience with agency management systems, enterprise data migrations, data mapping, validation, reconciliation, or conversion automation is preferred.

Responsibilities

  • Gather and analyze data from source systems and formats, and convert it into standardized templates using Excel, SQL, Alteryx, and other Microsoft data and analytics tools.
  • Organize customer data meetings, communicate requirements, document decisions, and coordinate data cleanup.
  • Map source data to destination platforms with agency partners and implementation and project leads, resolving mapping questions and discrepancies.
  • Prepare and format carrier, employee, and configuration data for agency review and destination system setup.
  • Validate and reconcile data using reports, queries, and conversion tools; identify discrepancies and cleanup needs.
  • Lead data review sessions with internal teams and agency stakeholders to maintain data quality and meet conversion milestones.
  • Track conversion issues and defects through resolution, and validate corrections.
  • Document requirements for custom conversion logic or scripting and validate converted information.
  • Coordinate with external conversion vendors and technical teams to resolve questions and issues and improve tools, automation, and processes.
  • Monitor conversion progress, risks, dependencies, and deliverables; maintain documentation of mapping decisions and validation results.
View Full Description & ApplyYou'll be redirected to the employer's site
Annual base salary ranging from $90,000 to $120,000, depending on experience, education, credentials, certifications, skills, responsibilities, and geographic location.
Apply Now