Analysis Skills, Claims Processing, Communication Skills, Computer Science, Consulting, Data Mapping, Data Migration, Data Quality, Data Structures, Database Administration, Database Extract Transform and Load (ETL), Database Programming, Health Insurance, Healthcare, Identify Issues, Informatica, Maintain Compliance, Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Azure, Migration Strategy, Operational Support, Oracle, Oracle Database, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Quality Metrics, Query Optimization, Reconciliation, Release Management/Engineering, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Sales Pipeline, Stored Procedures, Strategic Planning, Systems Engineering, Technical Writing
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
S
System One
Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives.
Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.
2,500 to 4,999 employees
Staffing/Employment Agencies