Senior ETL & Data Integration Engineer

Trucordia; Lindon (UT); On-site; 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

Employee Assistance Program (EAP)

Pet Insurance

11 Paid Holidays

Flexible PTO

401K

Job summary

Trucordia is hiring an Integration/Migration Engineer to own data conversions from source systems into AMS360 via API and direct operations. You will design ETL pipelines, map data, and validate quality during migrations as part of a growing data and technology team.

You will collaborate with the AMS360 Admin team, build scalable transformation logic, and expand into broader data products, CRM integrations, and analytics across the organization.

Qualifications

• 7+ years of experience in data engineering, ETL/ELT, or integration engineering.
• Strong SQL with SQL Server, PostgreSQL, and Snowflake.
• Experience integrating with RESTful and SOAP/XML APIs.
• Proficiency in Python or Node.js/TypeScript.
• Cloud deployment in Azure; familiarity with Docker, CI/CD, Git workflows.
• End-to-end data migration or integration ownership.
• Strong communication and documentation skills.
• Experience using AI-assisted development tools in daily workflows.
• Ability to review AI-generated code for correctness, security, and maintainability.
• Hands-on AI as a productivity multiplier.

Responsibilities

• Design and build ETL pipelines that extract data from source systems, transform it to Trucordia standards, and load into AMS360.
• Work with AMS360 API products (oData, WSAPI 3.0, EMS) to manage customer records and related data.
• Develop transformation logic for mapping and deduplication across lines of business.
• Extract, profile, and validate source data, including backups from unfamiliar systems.
• Create validation/QA processes to ensure data quality during migration.
• Produce ID transformation/mapping tables linking source and AMS360 identifiers.
• Collaborate with the AMS360 Admin team on mapping decisions and issue resolution.

Skills

SQL

API integration

Python

Node.js/TypeScript

Azure Cloud

Docker

CI/CD

Git workflows

AI-assisted development tools

Code review for AI-generated code

Tools

Snowflake

REST API tooling

Job description

Trucordia is hiring an Integration/Migration Engineer to own data conversions from source systems into AMS360 via API and direct operations. You will design ETL pipelines, map data, and validate quality during migrations as part of a growing data and technology team.

You will collaborate with the AMS360 Admin team, build scalable transformation logic, and expand into broader data products, CRM integrations, and analytics across the organization.