Senior Consultant - Data & Integration

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