(vi) Data / DBA / Backend Engineer – FACETS Data (SQL, ETL, Conversions)

System One; Baltimore (MD); Hybrid; USD 110,000 - 150,000; Full time

Job summary

System One invites experienced Data Engineers, DBAs, and Backend Engineers to support a large-scale FACETS migration and consolidation project in a hybrid work model in the Baltimore/Washington area. The role emphasizes data movement, validation, reconciliation, and production support for claims modernization.

Ideal candidates bring strong SQL Server/Oracle skills, ETL experience, and a solid grasp of healthcare claims data, including data migrations and conversions across FACETS platforms.

Qualifications

• Bachelor's degree in CS, IS, Eng, or related field.
• Strong hands-on experience with SQL Server and/or Oracle databases.
• Advanced SQL development including complex queries, joins, stored procedures, functions, performance tuning, and query optimization.
• Experience supporting enterprise data migration, data conversion, or ETL initiatives.
• Experience with large-scale, high-volume transactional data environments.
• Ability to troubleshoot and resolve complex data and database issues.
• Strong analytical, communication, and problem-solving skills.

Responsibilities

• Develop, maintain, and support SQL-based data processes for FACETS migration and consolidation projects.
• Perform data extraction, transformation, loading, and conversion from legacy claims systems into FACETS.
• Create and execute reconciliation, validation, and data quality processes for accurate data migration.
• Analyze and troubleshoot complex SQL queries, stored procedures, and database performance issues.
• Tune and optimize high-volume transactional and batch-processing systems.
• Collaborate with analysts, developers, architects, and stakeholders to define data requirements.
• Support release management, production deployments, cutovers, and post-implementation hypercare.
• Investigate and resolve data defects and integration issues; develop data mappings and validation procedures.
• Ensure compliance with data governance and quality standards.

Skills

SQL

SQL Server

Oracle

Data Migration

ETL

Performance Tuning

Data Validation

Batch Processing

Healthcare Data

Education

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

Tools

FACETS

NASCO FACETS

Informatica

Microsoft SSIS

Azure Data Factory

Job description

Data Engineer / DBA / Backend Engineer – FACETS Data

Location: Baltimore, MD / Washington, DC (Hybrid)
Type: Contract-to-Hire
Schedule: 40 Hours/Week (EST)
Industry: Healthcare / Health Insurance
Work Authorization: Must be authorized to work in the U.S.

Join a Major Healthcare Transformation Program

System One is supporting a large-scale healthcare modernization initiative and is actively building a pipeline of experienced Data Engineers, Database Administrators, and Backend Engineers with FACETS expertise.

This opportunity is part of the Clients Core Consolidation Program, a strategic initiative to migrate and consolidate four legacy claims platforms into FACETS. As multiple project teams ramp up over time, we are seeking professionals with strong data, database, and healthcare claims experience to support data conversions, integrations, migrations, and platform optimization.

If you have experience with FACETS or NASCO FACETS, we'd like to connect with you for current and upcoming opportunities.

Position Overview

The Data Engineer / DBA / Backend Engineer will play a critical role in supporting enterprise-scale FACETS migration and consolidation activities. The ideal candidate will have strong SQL and database skills, experience with ETL and data conversion initiatives, and a solid understanding of healthcare claims data.

This role is primarily focused on data movement, data validation, reconciliation, database development, troubleshooting, and production support activities related to claims system modernization.

Key Responsibilities

• Develop, maintain, and support SQL-based data processes for FACETS migration and consolidation projects.
• Perform data extraction, transformation, loading, and conversion activities from legacy claims systems into FACETS.
• Create and execute reconciliation, validation, and data quality processes to ensure accurate data migration.
• Analyze and troubleshoot complex SQL queries, stored procedures, and database performance issues.
• Tune and optimize high-volume transactional and batch-processing systems.
• Collaborate with analysts, developers, architects, and business stakeholders to define and implement data requirements.
• Support release management activities, production deployments, cutovers, and post-implementation hypercare.
• Investigate and resolve data defects, integration issues, and production support incidents.Develop technical documentation including data mappings, transformation logic, and validation procedures.
• Ensure compliance with organizational data governance and quality standards.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• Strong hands‑on experience with SQL Server and/or Oracle databases.
• Advanced SQL development skills, including:
  • Complex queries
  • Joins and subqueries
  • Stored procedures
  • Functions
  • Performance tuning
  • Query optimization
• Experience supporting enterprise data migration, data conversion, or ETL initiatives.
• Experience working with large-scale, high-volume transactional data environments.
• Ability to troubleshoot and resolve complex data and database issues.
• Strong analytical, communication, and problem‑solving skills.

Preferred Qualifications

• Experience working with FACETS or NASCO FACETS platforms.
• Understanding of FACETS data structures, workflows, integrations, and reporting feeds.
• Hands‑on experience supporting FACETS conversion or migration projects.
• Healthcare payer industry experience, including:
  • Claims processing
  • Eligibility data
  • Provider data
  • Membership data
• Experience with ETL and integration tools such as:
  • Informatica
  • Microsoft SSIS
  • Azure Data Factory
  • Similar enterprise ETL platforms
• Experience implementing reconciliation and data quality controls in regulated environments.
• Familiarity with batch processing frameworks and production support operations.

Technical Skills

Database Technologies

• SQL Server
• Oracle
• Stored Procedures
• Query Optimization
• Performance Tuning

Data & Integration

• ETL Development
• Data Conversion
• Data Migration
• Data Mapping
• Data Validation
• Data Reconciliation
• Batch Processing

Healthcare Technologies

• FACETS
• NASCO FACETS
• Claims Data
• Eligibility Data
• Provider Data