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