(vi) Data / DBA / Backend Engineer - FACETS Data (SQL, ETL, Conversions)
Job Description
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
#M- #LI-
Ref: #851-Rockville-S1