SQL Data Integration Specialist

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

Benefits offered by this job

Competitive pay

401K

Paid time off

Job summary

Relation Insurance Inc. seeks a Data Integration Administrator to develop, maintain, and support SQL-based ETL processes and data exchanges across TPA systems and business apps.

You’ll monitor integration performance, validate data, and document controls to meet SOC requirements, audits, and security standards. Collaborate with Systems, Claims, Eligibility, Billing and Account Management to implement conversions, define mappings, and drive process improvements that reduce manual effort and

Qualifications

• Develops and maintains SQL-based ETL processes and data integrations across TPA applications.
• Performs data validation, QA testing, and reconciliation to ensure data accuracy.
• Supports implementations and conversions with cross-functional teams.
• Maintains SOC-related documentation and controls.

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 the accuracy, completeness, and integrity of data exchanged between systems, clients, vendors, and third-party platforms.
• Partners with Systems, Claims, Eligibility, Billing, Account Management, and other operational teams to define requirements, support implementations and conversions, and resolve data-related issues.
• Creates and maintains data mappings, transformation logic, validation rules, technical specifications, process documentation, and troubleshooting procedures.
• Analyzes datasets and integration results to identify anomalies, root causes, control gaps, and opportunities to improve data quality and process reliability.
• Develops reports and assessments to monitor integration performance, data quality, and the operational impact of automation and process improvements.
• Maintains documentation and evidence in accordance with SOC requirements, internal controls, data security standards, and audit expectations.
• Uses approved technology and Relation proprietary AI tools to improve analysis, documentation, testing, troubleshooting, and process efficiency while protecting confidential and sensitive data.
• Performs other projects, duties, and tasks, as assigned.

Skills

SQL

ETL

Data integration

Data quality

Analytical thinking

Documentation

Education

High school diploma or equivalent

Bachelor’s degree in Information Systems/Computer Science/Data Analytics or related field

Job description

Relation Insurance Inc. seeks a Data Integration Administrator to develop, maintain, and support SQL-based ETL processes and data exchanges across TPA systems and business apps.

You’ll monitor integration performance, validate data, and document controls to meet SOC requirements, audits, and security standards. Collaborate with Systems, Claims, Eligibility, Billing and Account Management to implement conversions, define mappings, and drive process improvements that reduce manual effort and