Senior Consultant - Data & Integration

PCI Technology & Mission Solutions Sector; Washington (District of Columbia); Hybrid; USD 110,000 - 150,000; Full time

Job summary

PCI Technology & Mission Solutions Sector seeks a Senior Consultant to support the U.S. Department of Transportation's transition to Oracle Cloud Fusion HCM.

This hybrid role focuses on HR data readiness, migration, integrations, and requirements, working with HR, data, payroll, and technical stakeholders to prepare DOT data and interfaces for the new Core HCM environment. You will analyze and improve HR data quality, document data and integration requirements, and coordinate testing and

Qualifications

• Bachelor's degree in IT, Data Analytics, Business, or related field.
• 5+ years of relevant experience supporting HCM/HRIS, data migration, systems integration, ERP, or enterprise technology transformation.
• Experience with data analysis, data quality, mapping, migration/conversion, or reconciliation.
• Experience gathering and documenting business, data, or integration requirements.
• Strong analytical, communication, and stakeholder facilitation skills.
• Ability to obtain and maintain a Public Trust security clearance.

Responsibilities

• Analyze and improve HR data quality across positions, org structures, employees, and actions.
• Support data profiling, cleanup, mapping, migration, validation, and reconciliation.
• Document HCM data, business, and integration requirements.
• Analyze data flows and interfaces between Oracle Cloud HCM and HR/payroll/timekeeping/learning systems.
• Support integration planning for FPPS and other DOT systems.
• Facilitate requirements sessions with HR and SME teams.
• Support data and integration testing, issue resolution, and readiness activities.
• Identify data risks, dependencies, decisions, and migration issues.

Skills

Data analysis

Stakeholder facilitation

Requirements gathering

Communication

Education

Bachelor's degree in IT/Data Analytics/Business

Tools

SQL

Excel

Power BI

Job description

The Senior Consultant, HCM Data & Integration supports the U.S. Department of Transportation (DOT) and reports to the Deputy Program Manager. This position is hybrid.

Role Summary

Support DOT’s transition to Oracle Cloud Fusion HCM, with a focus on HR data readiness, migration, integrations, and requirements. This is a hands‑on consulting role working with HR, data, payroll, and technical stakeholders to prepare DOT’s data and interfaces for the new federal Core HCM environment.

Key Responsibilities

• Analyze and improve HR data quality, including position, organizational, employee, and personnel action data.
• Support data profiling, cleanup, source-to-target mapping, migration, validation, and reconciliation.
• Document HCM data, business, and integration requirements.
• Analyze data flows and interfaces between Oracle Cloud HCM and existing HR, payroll, timekeeping, learning, and downstream systems.
• Support integration planning for FPPS and other DOT systems that will remain in operation.
• Facilitate requirements and data working sessions with HR and technical SMEs.
• Support data and integration testing, issue resolution, and implementation readiness.
• Identify and document data risks, dependencies, decisions, and migration issues.

Required Qualifications

• Bachelor’s degree in IT, Data Analytics, Business, or related field.
• 5+ years of relevant experience supporting HCM/HRIS, data migration, systems integration, ERP, or enterprise technology transformation.
• Experience with data analysis, data quality, mapping, migration/conversion, or reconciliation.
• Experience gathering and documenting business, data, or integration requirements.
• Strong analytical, communication, and stakeholder facilitation skills.
• Ability to obtain and maintain a Public Trust security clearance.

Preferred Qualifications

• Oracle Cloud Fusion HCM or other Oracle product experience.
• HCM/HRIS data migration and integration experience.
• Knowledge of HR, position, payroll, or timekeeping data.
• Federal HR transformation experience.
• Experience with SQL, advanced Excel, Power BI, or similar tools.
• Oracle Fusion Cloud HCM certification or relevant data certification.

PCI Federal (PCIF) and its subsidiaries are an equal‑opportunity employer. PCIF does not discriminate on the basis of age, sex, race, national origin, religion, marital status, sexual orientation or identity, Veterans or Disability status.

Preference may be extended to qualified Native American Indian candidates in accordance with applicable federal law.