Data Integrations Engineer – ETL & API Migrations

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

Benefits offered by this job

Life Insurance

AD&D

FSA/HSA

Critical Illness

Hospital Indemnity

Supplemental Health Insurance

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 extraction to transformation and loading into AMS360 via APIs. You will design ETL pipelines, map data, and validate quality for agency migrations driven by M&A activity.

You’ll work with the AMS360 Admin team and apply AI-assisted development tools to accelerate coding, testing, and deployment in a cloud-enabled, collaborative environment.

Qualifications

• 7+ years in data engineering, ETL/ELT, or integration engineering building pipelines.
• Strong SQL skills with profiling, joins, and data quality analysis on SQL Server, PostgreSQL, and Snowflake.
• Experience integrating RESTful/SOAP/XML APIs and performing data loads via APIs and DB operations.
• Proficiency in Python or TypeScript for data transformation and automation.

Responsibilities

• Design and execute ETL pipelines extracting from multiple source systems and loading into AMS360.
• Work with AMS360 API products to create/update records, shells, attachments, and related data.
• Build mapping logic for carrier, employee/producer, and client deduplication.
• Profile, validate, and QA source data; develop validation processes.
• Produce ID mapping tables linking source to AMS360 identifiers.
• Collaborate with AMS360 Admin on mapping decisions and validation.

Skills

Data engineering

ETL/ELT

SQL

APIs

Python

Azure

Docker

CI/CD

Git workflows

AI tooling

Tools

AMS360 API

oData

WSAPI 3.0

EMS

SQL Server

PostgreSQL

Snowflake

Job description

Trucordia Insurance Services, LLC is seeking an Integration/Migration Engineer to own data conversions, from source extraction to transformation and loading into AMS360 via APIs. You will design ETL pipelines, map data, and validate quality for agency migrations driven by M&A activity.

You’ll work with the AMS360 Admin team and apply AI-assisted development tools to accelerate coding, testing, and deployment in a cloud-enabled, collaborative environment.