Data/Integration Engineer
About The Position
The Data/Integration Engineer designs and supports the data architecture connecting DOT financial, contracting, service-management, planning, and external-provider data required for the WCF solution. The engineer integrates and standardizes data from Delphi, PRISM, ServiceNow, Oracle EPM/IMPACT, spreadsheets, CSV files, and other Government-approved sources into a common analytical structure. The position supports DOT's transition from Microsoft to Google through a modular, nonproprietary, and transition-ready architecture. The Data/Integration Engineer preserves the authoritative roles of existing systems of record while configuring approved interfaces, extracts, staging, validation, reconciliation, and reporting data flows within the environment authorized by OCDIO.
Requirements
- Design and support the data architecture connecting DOT financial, contracting, service-management, planning, and external-provider data required for the WCF solution.
- Integrate and standardize data from Delphi, PRISM, ServiceNow, Oracle EPM/IMPACT, spreadsheets, CSV files, and other Government-approved sources into a common analytical structure.
- Support DOT's transition from Microsoft to Google through a modular, nonproprietary, and transition-ready architecture.
- Preserve the authoritative roles of existing systems of record while configuring approved interfaces, extracts, staging, validation, reconciliation, and reporting data flows within the environment authorized by OCDIO.
Responsibilities
- Design and maintain the common financial and operational data structure supporting the WCF solution.
- Integrate data from Delphi, PRISM, ServiceNow, Oracle EPM/IMPACT, and approved external sources.
- Develop documented source-to-target mappings, crosswalks, data dictionaries, and interface specifications.
- Profile incoming datasets to understand field definitions, formats, identifiers, units, quality, and reporting grain.
- Standardize external Government and commercial provider datasets into a consistent schema.
- Develop controlled intake processes for spreadsheets, CSV files, scheduled reports, database extracts, and other approved formats.
- Design validation rules for required fields, duplicates, invalid values, customer mappings, service mappings, and control totals.
- Reconcile processed datasets to provider control totals and applicable authoritative financial totals.
- Design and maintain exception-handling workflows for invalid, unmatched, incomplete, or changed-format records.
- Support structured staging, transformation, and processing of larger or more complex datasets.
- Develop and maintain metadata, lineage, schema-version, and source-system documentation.
- Support automated and scheduled data movement using DOT-approved technologies and interfaces.
- Work with OCDIO on interface configuration, identity and access, platform dependencies, security requirements, and migration activities.
- Support the Microsoft-to-Google transition by identifying platform dependencies and reconfiguring data interfaces and processing components as required.
- Support development of reporting datasets and analytical views for financial analysts, executives, and Operating Administration customers.
- Perform integration testing, data reconciliation, defect analysis, and UAT support.
- Prepare technical runbooks, interface documentation, data dictionaries, and knowledge-transfer materials.
- Provide Level 2 data and integration troubleshooting while coordinating privileged platform issues with OCDIO.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Education Level
No Education Listed
