Data Integration Administrator, TPA

This is a fully remote position, open to applicants in Oklahoma.

📋 Description

• Design, maintain, and support SQL-driven ETL processes, data integrations, interfaces, and automated workflows across TPA applications and business systems.

• Monitor scheduled integrations, file feeds, and automated processes; investigate and resolve failures, performance issues, data discrepancies, and processing exceptions.

• Conduct data validation, quality assurance testing, and reconciliation to ensure data accuracy, completeness, and integrity.

• Collaborate with Systems, Claims, Eligibility, Billing, Account Management, and other operational teams to define requirements, support implementations and conversions, and address data-related issues.

• Create and maintain data mappings, transformation logic, validation rules, technical specifications, process documentation, and troubleshooting procedures.

• Analyze datasets and integration outcomes to identify anomalies, root causes, control gaps, and opportunities for enhancing data quality and process reliability.

• Recognize and implement workflow automation and process enhancements to minimize manual effort, strengthen controls, and boost operational efficiency.

• Develop reports and assessments to monitor integration performance, data quality, and the operational impact of automation and process improvements.

• Ensure documentation and evidence are maintained in compliance with SOC requirements, internal controls, data security standards, and audit expectations.

• Utilize approved technology and Relation proprietary AI tools to enhance analysis, documentation, testing, troubleshooting, and process efficiency while safeguarding confidential and sensitive data.

• Undertake other assigned projects, duties, and tasks.

⛳️ Requirements

• High school diploma or equivalent is required.

• A four-year degree in Information Systems, Computer Science, Data Analytics, or a related field is preferred.

• A minimum of 3 years of experience in data integration, ETL development, database administration, systems integration, or a related technical function is required.

• Experience in a Third-Party Administrator (TPA), self-funded health plan, payer, healthcare administration, insurance, or employee benefits environment is preferred.

• Familiarity with systems, data exchanges, and healthcare EDI transactions that support claims, eligibility, enrollment, billing, pharmacy benefit management, or related TPA functions is preferred.

• Knowledge of SOC controls, audit requirements, data security practices, and technical documentation standards is preferred.

• Proficiency in developing and maintaining SQL queries and SQL-based ETL processes within relational database environments is essential.

• Experience in supporting data integrations across relational databases, applications, APIs, EDI transactions, ETL tools, file exchanges, or workflow automation platforms is required.

• Experience in conducting data validation, quality assurance testing, reconciliation, and analysis of data anomalies or processing failures is necessary.

• A working knowledge of relational database concepts, data structures, data mapping, transformation logic, and data integrity controls is important.

• Ability to document technical processes, integrations, workflows, and controls clearly and consistently is required.

• Strong analytical, organizational, and problem-solving skills, with the capacity to manage multiple priorities and communicate effectively with both technical and non-technical partners are essential.

🏝️ Benefits

• Competitive pay.

• Family health and wellness programs.

• 401K.

• Employee assistance programs.

• Paid time off.

• Paid holidays.

• Career advancement and development opportunities.

• Eligibility for a discretionary annual incentive program, subject to program rules and individual and organizational performance.