Data Integration Administrator, TPA

Summary

Relation Insurance Services is an insurance services company seeking a Data Integration Administrator to support its Third-Party Administrator (TPA) systems and business applications. The role develops and maintains SQL-based ETL processes, monitors data quality and integration performance, troubleshoots issues, and improves the accuracy, reliability, and efficiency of data exchange.

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. Identifies and implements workflow automation and process improvements that reduce manual effort, strengthen controls, and improve operational efficiency
• 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

• High school diploma or equivalent required
• Minimum 3 years of experience in data integration, ETL development, database administration, systems integration, or a related technical function
• Experience developing and maintaining SQL queries and SQL-based ETL processes in relational database environments
• Experience supporting data integrations across relational databases, applications, APIs, EDI transactions, ETL tools, file exchanges, or workflow automation platforms
• Experience performing data validation, quality assurance testing, reconciliation, and analysis of data anomalies or processing failures
• Working knowledge of relational database concepts, data structures, data mapping, transformation logic, and data integrity controls
• Ability to document technical processes, integrations, workflows, and controls clearly and consistently
• Strong analytical, organizational, and problem-solving skills, with the ability to manage multiple priorities and communicate effectively with technical and nontechnical partners
• Four-year degree in Information Systems, Computer Science, Data Analytics, or a related field preferred
• Experience within a Third-Party Administrator (TPA), self-funded health plan, payer, healthcare administration, insurance, or employee benefits environment preferred
• Experience with systems, data exchanges, and healthcare EDI transactions supporting claims, eligibility, enrollment, billing, pharmacy benefit management, or related TPA functions preferred
• Familiarity with SOC controls, audit requirements, data security practices, and technical documentation standards preferred

Qualifications

Must Haves

• High school diploma or equivalent required
• Minimum 3 years of experience in data integration, ETL development, database administration, systems integration, or a related technical function
• Experience developing and maintaining SQL queries and SQL-based ETL processes in relational database environments
• Experience supporting data integrations across relational databases, applications, APIs, EDI transactions, ETL tools, file exchanges, or workflow automation platforms
• Experience performing data validation, quality assurance testing, reconciliation, and analysis of data anomalies or processing failures
• Working knowledge of relational database concepts, data structures, data mapping, transformation logic, and data integrity controls
• Ability to document technical processes, integrations, workflows, and controls clearly and consistently
• Strong analytical, organizational, and problem-solving skills, with the ability to manage multiple priorities and communicate effectively with technical and nontechnical partners

Nice to Haves

• Four-year degree in Information Systems, Computer Science, Data Analytics, or a related field preferred
• Experience within a Third-Party Administrator (TPA), self-funded health plan, payer, healthcare administration, insurance, or employee benefits environment preferred
• Experience with systems, data exchanges, and healthcare EDI transactions supporting claims, eligibility, enrollment, billing, pharmacy benefit management, or related TPA functions preferred
• Familiarity with SOC controls, audit requirements, data security practices, and technical documentation standards preferred

Benefits

• Family health and wellness programs
• 401K
• Employee assistance programs
• Paid time off
• Paid holidays
• Career advancement and development opportunities
• You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.