Data Integration Administrator, TPA

Relation Insurance Services

United States

Sur place

USD 74 000 - 115 000

Plein temps

14 jours+

Obtenez une réponse de cet employeur

Votre CV et votre lettre de motivation, adaptés exactement à ce que l’employeur recherche.

Passez les filtres ATS

Avantages offerts par ce poste

Competitive pay
Safe and healthy work environment
Career advancement opportunities

Résumé du poste

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.

Responsabilités

  • 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.

Connaissances

SQL
ETL development
Data integration
Workflow automation
Data quality monitoring
Documentation
SOC controls
Data analysis
Problem solving

Formation

High school diploma or equivalent
Bachelor's degree in Information Systems, Computer Science, Data Analytics, or related field

Outils

SQL databases
ETL tools
APIs
EDI transactions

Description du poste

What We’re 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.

What We’re 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.

Note: The above is not all encompassing of the full position description.

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.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Relation, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is presented within this posting.

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.

$74,000.00 - $115,000.00

Obtenez votre examen gratuit et confidentiel de votre CV.

ou faites glisser et déposez votre fichier ici.

Similar jobs

Postes similaires à comparer

Data Integration Administrator, TPA
Data Integration Administrator, TPA

Edison Health Solutions, LLC • Oklahoma

Sur place
USD 74 000 - 115 000
Competitive pay
401K
Paid time off
+2
Data Integration Administrator, TPA
Data Integration Administrator, TPA

Relation Insurance, Inc. • Tulsa (OK)

À distance
USD 74 000 - 115 000
401K
Paid time off
Health benefits
Senior Account Executive, TPA
Senior Account Executive, TPA

Relation Insurance Services • États-Unis

Sur place
USD 65 000 - 112 000
401K
Paid time off
Family health and wellness programs
Senior Account Executive, TPA
Senior Account Executive, TPA

Relation Insurance Services • Tulsa (OK)

Sur place
USD 65 000 - 112 000
401K
Paid time off
Paid holidays
+2
Paralegal, TPA & COE
Paralegal, TPA & COE

Relation Insurance • Tulsa (OK)

Sur place
USD 76 000 - 129 000
Competitive pay
Excellent benefits package
Senior Account Executive, TPA
Senior Account Executive, TPA

Relation Insurance, Inc. • Tulsa (OK)

À distance
USD 65 000 - 112 000
Competitive pay
401K
Paid time off
+2
Manager, Financial Planning and Analysis
Manager, Financial Planning and Analysis

Relation Insurance Services • États-Unis

À distance
USD 109 000 - 175 000
401K
Paid time off
Paid holidays and wellness programs
Client Service Specialist, Small Business Unit - Employee Benefits
Client Service Specialist, Small Business Unit - Employee Benefits

Relation Insurance Services • Tulsa (OK)

Sur place
USD 28 000 - 54 000
Health benefits
401K
Paid time off
+1
Paralegal, TPA & COE
Paralegal, TPA & COE

Relation Insurance, Inc. - Corporate • Tulsa (OK)

Sur place
USD 76 000 - 129 000
Competitive pay
Benefits package
Career development
Senior Account Executive, TPA
Senior Account Executive, TPA

Edison Health Solutions, LLC • Oklahoma

Sur place
USD 65 000 - 112 000
Competitive pay
Comprehensive benefits
Career growth