HR Data Engineer & DBA for Modernization - Hybrid

CAI; Trenton (NJ); Hybrid; USD 96,000 - 102,000; Full time

Job summary

CAI is seeking a Data Engineer-DBA to design the HR data model, lead legacy data conversion, and reconcile person and employee records for HR modernization initiatives. The role is a full-time contract with a hybrid work arrangement (3 days onsite) in Trenton, NJ.

Candidate will maintain PostgreSQL schemas, manage migrations with Flyway/Liquibase, and collaborate with developers to optimize data access. Local candidates only, and sponsorship is not available.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience in data engineering or database administration.
• PostgreSQL schema design and migration tooling.
• Experience extracting data from Oracle sources.
• Experience with reconciliation and drift detection between two systems holding the same records.
• Experience with data masking for non-production use.
• Advanced SQL skills and Python scripting.

Responsibilities

• Design and maintain the PostgreSQL schema for the HR data model.
• Manage schema changes through migration tooling such as Flyway or Liquibase with version control.
• Partner with developers and architects on data access patterns and performance.
• Extract data from Oracle sources and design repeatable conversion and load processes.
• Run conversion cycles, validate results, and resolve data quality issues with business owners.
• Reconcile person and employee records between the existing system and the new platform.
• Build drift detection between two systems that hold the same records with exception reporting and resolution workflows.
• Implement data masking for non-production environments to protect sensitive information.
• Support database performance tuning, backup and recovery, and access management.

Skills

SQL

Python

Data modeling

Data integration

Education

Bachelor's degree in Computer Science or Information Systems

Tools

PostgreSQL

Oracle

Flyway

Liquibase

Amazon Aurora

Job description

CAI is seeking a Data Engineer-DBA to design the HR data model, lead legacy data conversion, and reconcile person and employee records for HR modernization initiatives. The role is a full-time contract with a hybrid work arrangement (3 days onsite) in Trenton, NJ.

Candidate will maintain PostgreSQL schemas, manage migrations with Flyway/Liquibase, and collaborate with developers to optimize data access. Local candidates only, and sponsorship is not available.