FACETS Data Engineer & DB/Backend Specialist (Hybrid)

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

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.