Business Analyst (Data Engineering)

Location: Trenton, New Jersey, United States; hybrid with 3 days onsite. Local candidates only. Work authorizations not requiring sponsorship now or in the future are required.

Salary: $70–$74 per hour.

Company

hirify.global is a global services firm with more than 9,000 associates, over 40 years of experience, and solutions for public and commercial-sector clients.

What you will do

• Design and maintain the PostgreSQL schema for the HR data model and manage version-controlled schema changes using Flyway or Liquibase.
• Partner with developers and architects on data access patterns and performance.
• Extract data from Oracle sources and build repeatable conversion and loading processes.
• Run conversion cycles, validate results, resolve data quality issues with business owners, and reconcile person and employee records between existing and new systems.
• Build drift detection, exception reporting, and resolution workflows for matching records across systems.
• Implement data masking for non-production environments and support database performance tuning, backup and recovery, and access management.

Requirements

• 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.
• 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 experience with a scripting language such as Python.
• Ability to work onsite three days per week in Trenton, New Jersey, and be a local candidate.
• Work authorization that does not require current or future sponsorship.

Nice to have

• Ability to read Oracle PL/SQL.
• Experience with change data capture tooling.
• AWS database certification or experience with Amazon Aurora.
• Experience with HR or personnel data.
• Experience within Human Services or Child Welfare programs.

Culture & Benefits

• Medical, dental, and vision insurance.
• Access to a 401(k) retirement account.
• Paid sick leave and/or other paid time off as provided by applicable law.
• Work includes sedentary computer-based activities with occasional movement around the office for meetings.