Data Integration Engineer: ETL & Automation

Relation Insurance Services; United States; On-site; USD 74,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

Safe and healthy work environment

Career advancement opportunities

Job summary

Relation Insurance Services is seeking a Data Integration Administrator to develop, maintain, and support SQL-based ETL processes and data integrations across the company’s TPA systems and business applications.

The role monitors integration performance, troubleshoots issues, and partners with Operations and technical teams to improve data accuracy, reliability, and efficiency. SOC controls and audit readiness are emphasized.

Qualifications

• Requires a high school diploma or equivalent; a 4-year degree preferred in IS/CS/Data Analytics or related field.
• Minimum 3 years of data integration, ETL development, database administration, or related technical work.
• Experience in a healthcare admin/TPA environment is preferred.
• Experience with data exchanges and healthcare EDI transactions is preferred.
• Familiarity with SOC controls, audit requirements, data security practices, and technical documentation standards.
• Strong SQL skills and experience supporting data integrations across systems.

Responsibilities

• Develops, maintains and supports SQL-based ETL processes, data integrations, interfaces and automated workflows across TPA applications and business systems.
• Monitors scheduled integrations, file feeds, and automated processes; investigates and resolves failures, performance issues, data discrepancies, and processing exceptions.
• Performs data validation, quality assurance testing, and reconciliation to confirm data accuracy and integrity of exchanges between systems, clients, vendors, and third-party platforms.
• Partners with Systems, Claims, Eligibility, Billing, Account Management, and other teams to define requirements, support implementations and conversions, and resolve data issues.
• Creates and maintains data mappings, transformation logic, validation rules, and technical documentation.
• Analyzes datasets and integration results to identify anomalies, root causes, and opportunities to improve data quality and process reliability.
• Develops reports and assessments to monitor integration performance and impact of automation.
• Maintains documentation and evidence to SOC requirements and data security standards.

Skills

SQL

ETL development

Data integration

Workflow automation

Data quality monitoring

Documentation

SOC controls

Data analysis

Problem solving

Education

High school diploma or equivalent

Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field

Tools

SQL databases

ETL tools

APIs

EDI transactions

Job description

Relation Insurance Services is seeking a Data Integration Administrator to develop, maintain, and support SQL-based ETL processes and data integrations across the company’s TPA systems and business applications.

The role monitors integration performance, troubleshoots issues, and partners with Operations and technical teams to improve data accuracy, reliability, and efficiency. SOC controls and audit readiness are emphasized.