Senior Consultant - Data & Integration

Fortis Industries, Inc. DBA - LTS, Inc.; Washington (District of Columbia); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Fortis Industries, Inc. DBA - LTS, Inc. seeks a Senior Consultant to support the U.S. Department of Transportation in migrating to Oracle Cloud Fusion HCM. The role focuses on HR data readiness, migration, integrations, and requirements across HR, data, payroll, and technical stakeholders.

This hybrid position involves hands-on work preparing DOT data and interfaces for the new federal Core HCM environment, with collaboration across multiple DOT systems and teams.

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

Skills

HCM/HRIS experience

Data migration

Requirements gathering

Data analysis

Stakeholder facilitation

Public Trust clearance

Education

Bachelor's degree in IT, Data Analytics, Business, or related field

Tools

SQL

Excel

Power BI

Job description

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.

Equal Employment Opportunity

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. Equal employment opportunity, including veterans and individuals with disabilities.

PI287741570