HR Systems Integration Lead

At APV, we’re more than a technology company — we’re a mission-driven powerhouse transforming organizations through advanced technology and human ingenuity. Our expertise spans AI/ML, data architecture, low-code/no-code development, Agile Dev Sec Ops , and cloud services, delivering scalable and meaningful solutions.

In our Emerging Technology Lab, innovation drives progress. Our teams create intelligent chatbots, AI-powered assistants, robotic process automation (RPA), essay graders, and data analytics platforms. If you’re passionate about solving complex challenges and shaping the future, APV is the place for you.

Since 2007, we’ve partnered with federal and state agencies to deliver IT, training, and consulting solutions that achieve mission-critical outcomes. Built on accountability, integrity, and quality, we go beyond expectations.

With 70+ prime contracts and a proven record of client success, APV continues to grow — and we’re looking for exceptional talent to grow with us.

At APV, we Always Provide Value.

Role:

The HR Systems Integration Lead will support the Department of Homeland Security (DHS) on the migration of enterprise Human Capital (HC) systems from legacy environments to a modernized target-state platform. The Senior Specialist owns assigned integration work streams across the migration lifecycle — including discovery, source-to-target mapping, interface design, data migration, environment management, cutover planning, and post-go-live hypercare — and serves as a senior point of contact for OCIO, vendor integration teams, source system owners, and component HR partners.

This role requires deep working knowledge of federal HR data and process flows, integration patterns, secure data movement, and federal cybersecurity and privacy requirements. The Senior Specialist designs interface specifications, leads data migration cycles, drives defect triage, mentors journeyman specialists, and produces the technical artifacts required for Authorization to Operate (ATO), privacy compliance, and audit readiness.

Duties:

• Lead source-to-target mapping for assigned HR data domains (personnel, position, pay, benefits, time and attendance, learning, recruitment, performance), including field-level mapping, transformation rules, reference data alignment, and exception handling.
• Design integration interfaces between legacy HC source systems (NFC EmpowHR, EPP/MyEPP, PCC
  2000, IRIS, USA Staffing, Fed Talent, eOPF, OPM Retirement Services Online, webTA, BENEFEDS, TSP) and target-state platforms using REST APIs, SOAP services, SFTP, iPaaS, ETL/ELT pipelines, and message-based patterns.
• Develop interface control documents (ICDs), API specifications, data dictionaries, and transformation rule documentation.
• Coordinate with OCIO architects, source system owners, target platform vendors, and DHS enterprise architecture on integration patterns, reference architectures, and approved technology stacks.
• Lead resolution of complex mapping issues, including conflicting data definitions, deprecated codes, historical data anomalies, and multi-source reconciliation.

• Lead data migration cycles, including extract, profile, cleanse, transform, load, and reconciliation activities across mock loads, dress rehearsals, and production cutover.
• Develop and execute reconciliation queries that validate record counts, control totals, balance integrity (leave balances, retirement service credit, benefits enrollments), and downstream impact (next-pay-period accuracy, eOPF document continuity).
• Coordinate data cleansing efforts with HR functional teams, including duplicate resolution, missing data remediation, and historical correction.
• Lead defect triage, root-cause analysis, and remediation across data and integration defects; track defects in Jira, Azure Dev Ops, or Service Now through closure.
• Produce migration run books, cutover playbooks, fallback procedures, and post-cutover validation checklists.

• Coordinate non-production environment management across development, integration,…