Senior Data Integration & Migration Engineer

Trucordia Insurance Services, LLC; Lindon, Northern (UT, KY); Hybrid; USD 100,000 - 160,000; Full time

Benefits offered by this job

Life Insurance and AD&D

FSA / HSA

Critical Illness

Hospital Indemnity

Supplemental Health Insurance

Employee Assistance Program (EAP)

Pet Insurance

11 Paid Holidays

Flexible PTO

401K

Job summary

Trucordia Insurance Services, LLC is seeking an Integration/Migration Engineer to own data conversions from source systems into AMS360. You will build and run ETL processes, perform data profiling and validation, and collaborate with the AMS360 Admin team to ensure accurate migrations for ongoing M&A activity.

The role focuses on agency migrations, with potential expansion into bulk data operations and CRM integrations. Strong SQL, API, and cloud data engineering skills are essential.

Qualifications

• 7+ years in data engineering, ETL/ELT, or integration engineering.
• Strong SQL skills with experience across SQL Server and PostgreSQL.
• Experience integrating RESTful and SOAP/XML APIs, incl. oData.
• Proficiency in Python/Node.js/TypeScript for data transformation.
• Cloud deployment experience (Azure) with Docker and CI/CD.

Responsibilities

• Design and run ETL pipelines moving data from multiple source systems into AMS360.
• Develop data transformation logic and mapping to Trucordia standards.
• Collaborate with AMS360 Admin team on validation and issue resolution.
• Produce ID mapping tables linking source records to AMS360 IDs.
• Ensure data quality through validation, profiling, and QA processes.

Skills

SQL

APIs (RESTful/SOAP)

Python/Node.js/TypeScript

Azure Cloud

Docker

CI/CD

Git workflows

Data migration

AI-assisted development

Tools

AMS360

EPIC

TAM

Applied

HawkSoft

oData

Job description

Trucordia Insurance Services, LLC is seeking an Integration/Migration Engineer to own data conversions from source systems into AMS360. You will build and run ETL processes, perform data profiling and validation, and collaborate with the AMS360 Admin team to ensure accurate migrations for ongoing M&A activity.

The role focuses on agency migrations, with potential expansion into bulk data operations and CRM integrations. Strong SQL, API, and cloud data engineering skills are essential.