Data Integration Administrator, TPA

Edison Health Solutions, LLC; Oklahoma; On-site; USD 74,000 - 115,000; Full time

Benefits offered by this job

Competitive pay

401K

Paid time off

Employee assistance programs

Health benefits

Job summary

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

The role monitors scheduled integrations, resolves failures, ensures data quality, and collaborates with multiple teams to improve data accuracy and process reliability while adhering to SOC controls and audit standards.

Qualifications

• Four-year degree in information systems, CS, data analytics or related field preferred.
• Minimum 3 years in data integration, ETL development or systems integration.
• Experience with SOC controls, data security practices and technical documentation preferred.

Responsibilities

• Develops, maintains and supports SQL-based ETL processes, data integrations and automated workflows across TPA applications.
• Monitors data quality, performance and resolves failures or discrepancies in data exchanges.
• Documents integrations, mappings, and controls to meet SOC and audit requirements.
• Collaborates with operations and technical teams to improve data accuracy and efficiency.
• Creates reports to monitor integration performance and impact of automation.

Skills

SQL ETL

Data integration

Data quality

Troubleshooting

Documentation

Education

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

Tools

SQL

ETL tools

Job description

WHAT WE’R LOOKING FOR

The Data Integration Administrator develops, maintains, and supports data integrations, SQL-based Extract, Transform and Load (ETL) processes, and automated workflows for Relation’s Third-Party administrator (TPA) systems and business applications. The individual in this role monitors data quality and integration performance, troubleshoots issues, and partners with operation and technical teams to improve the accuracy, reliability, and efficiency of data exchange. The Data Integration Administrator also maintains technical documentation and controls to support operational continuity, SOC requirements and audit readiness.

A GLIMPSE INTO YOUR DAY

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.

WHAT SUCCESS LOOKS LIKE IN THIS ROLE

High school diploma or equivalent required. Four-year degree in Information Systems, Computer Science, Data Analytics, or a related field preferred. Minimum 3 years of experience in data integration, ETL development, database administration, systems integration, or a related technical function. 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. 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.

WHY CHOOSE RELATION?

• Competitive pay.
• A safe and healthy work environment provided by our robust benefit program including family health and wellness programs, 401K, employee assistance programs, paid time off, paid holidays and more.
• Career advancement and development opportunities.

Relation Insurance Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

$74,000.00 - $115,000.00

Relation Insurance Services is a North American insurance brokerage that offers business insurance, Employee Benefits, Personal Insurance, Retirement Services, and Risk-management through our family of brands across the United States. More importantly, we’re a team of experienced professionals who genuinely care. Whether it’s for you, your family, or your business/organization, we want to be the relationship you trust for answers to your questions, solutions for your insurance needs, and peace of mind for your future.