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

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., * 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.

Work Authorization: Must be authorized to work in the U.S., If you have experience with FACETS or NASCO FACETS, we’d like to connect with you for current and upcoming opportunities., * 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

System One, and its subsidiaries including Joulé, ALTA IT Services, CM Access, TPGS, and MOUNTAIN, LTD., are leaders in delivering workforce solutions and integrated services across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible full-time employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

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.