Senior Facets Claims Architect - Remote ETL Expert

TechDigital Group

City of Rochester (NY)

Remote

USD 110,000 - 150,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

TechDigital Group is seeking a Senior Consultant with deep expertise in Facets Claims processing, Informatica, and SQL/PLSQL to support and enhance data integration for healthcare payer systems. The role involves troubleshooting, impact analysis, and collaboration with business and technical teams in a remote-capable setup.

The ideal candidate will design and optimize ETL workflows, analyze claims data, and mentor junior staff while ensuring SDLC compliance and robust data governance.

Qualifications

  • Strong knowledge of Facets claims processing and architecture.
  • Experience with healthcare payer systems and data integration.

Responsibilities

  • Provide SME in Facets Claims processing and architecture.
  • Analyze business requirements and translate them into technical solutions.
  • Design, develop, and support Informatica ETL workflows and mappings.
  • Develop and optimize complex SQL and PL/SQL queries, stored procedures, and database objects.
  • Support healthcare claims processing, adjudication, and data integration requirements.
  • Investigate and resolve production issues related to Facets, claims data, and ETL processes.
  • Collaborate with stakeholders, architects, analysts, and development teams.
  • Perform impact analysis for system enhancements and regulatory changes.
  • Ensure adherence to SDLC, coding standards, and data governance practices.
  • Participate in code reviews, testing, deployment, and production support activities.
  • Create and maintain technical and operational documentation.
  • Mentor junior team members and provide technical guidance.

Skills

Facets
Healthcare Claims
Informatica PowerCenter
SQL
PL/SQL
Healthcare Payer Systems
Data Analysis
Troubleshooting

Education

Bachelor's degree

Tools

Oracle Database

Job description

TechDigital Group is seeking a Senior Consultant with deep expertise in Facets Claims processing, Informatica, and SQL/PLSQL to support and enhance data integration for healthcare payer systems. The role involves troubleshooting, impact analysis, and collaboration with business and technical teams in a remote-capable setup.

The ideal candidate will design and optimize ETL workflows, analyze claims data, and mentor junior staff while ensuring SDLC compliance and robust data governance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Facets & Informatica Claims Consultant
Senior Facets & Informatica Claims Consultant

TechDigital Group • City of Rochester (NY)

On-site
USD 120,000 - 170,000
Senior Consultant - Facets Claims & Informatica
Senior Consultant - Facets Claims & Informatica

TechDigital Group • City of Rochester (NY)

On-site
USD 120,000 - 170,000
SR CONSULTANT
SR CONSULTANT

TechDigital Group • City of Rochester (NY)

Remote
USD 110,000 - 150,000
Facets Healthcare Architect: Claims & Data Integration
Facets Healthcare Architect: Claims & Data Integration

HCL Technologies Limited • San Antonio (TX)

On-site
USD 94,000 - 139,000
Medical insurance
Dental insurance
Vision insurance
+6
Remote Facets Configuration Specialist (Healthcare Payer)
Remote Facets Configuration Specialist (Healthcare Payer)

Tegria Services Group - US • United States

Remote
USD 90,000 - 140,000
Health insurance
Dental insurance
Vision insurance
+3
Facets
Facets

IPolarity LLC • Whippany (NJ)

Remote
USD 110,000 - 150,000
Facets Technical Lead - Healthcare Payer Solutions (Remote)
Facets Technical Lead - Healthcare Payer Solutions (Remote)

Cognizant • Dayton (OH)

Remote
USD 140,000 - 190,000
Senior Facets Developer (Remote) - .NET/SQL Expert
Senior Facets Developer (Remote) - .NET/SQL Expert

IPolarity LLC • Whippany (NJ)

Remote
USD 65,000 - 87,000
Remote work CST
Laptop provided
Background check initiated
Senior Facets Testing Engineer - Healthcare
Senior Facets Testing Engineer - Healthcare

TechDigital Group • Texas

Hybrid
USD 90,000 - 130,000
Pega Healthcare Claims Analyst – Facets, EDI 837/835
Pega Healthcare Claims Analyst – Facets, EDI 837/835

TechDigital Group • Raritan (NJ)

On-site
USD 85,000 - 120,000