Data Integration Engineer

Washington, United States | Posted on 08/06/2026 Security Clearance: Public Trust or the abilityto obtain one. Job Type: Part-time (W2) or 1099 independentcontractor Benefits: Our client provides full benefits toW2 employees, including part-time. Program Name: Working Capital Fund (WCF), Officeof Financial Management (OFM) - WCF IT Financial Management, Cost ModelDevelopment, and Systems Integration Support Agency name: U.S. Department of Transportation(DOT), Office of the Secretary (OST) Work Location (FYI): DOT Headquarters, 1200 NewJersey Ave SE, Washington, DC 20590 BizFirst is assisting our client with recruiting a skilled and experienced Data / Integration Engineer. Thisposition supports the following program: U.S. Department of Transportation(DOT), Office of the Secretary (OST), Working Capital Fund (WCF), Office ofFinancial Management (OFM) — WCF IT Financial Management, Cost ModelDevelopment, and Systems Integration Support. Our client is a boutiqueconsulting firm that employs consultants and professionals with unique skillsets to support the federal government with strategic execution, financialprocess enablement, IT systems, and Enterprise Resource Planning (ERP) softwareimplementation. What will you do Own the controlled movement andreconciliation of data between the Government’s financial and operationalsystems. This is the position that makes the numbers trustworthy: controlledextracts, common-key mappings, validation on load, and the ServiceNow-to-Delphireconciliation that every downstream product depends on. The client environmentis Google-based — Google Workspace (Sheets, Drive, Chat, AppSheet, Apps Script)and Google Cloud analytics (BigQuery, Dataform, Looker), alongside Delphi,ServiceNow, and PRISM. Candidates with Microsoft-stack depth (Power BI, PowerAutomate, Power Query, SQL Server) and the aptitude to transfer are strongfits; direct Google-stack experience is a significant plus. Responsibilities: Build and operate controlled, scheduled extracts from Delphi (Oracle Federal Financials), ServiceNow, and PRISM — with extractdates, row counts, and control totals recorded on arrival. Design and maintain the common-key mapping layer connecting financial and operational records: period, customer/OA, service,funding source, contract/CLIN, asset or configuration item, and transactionidentifiers. Engineer the ServiceNow-to-Delphi reconciliation by period, customer, service, and transaction class across 11 Operating Administrations; classify differences (timing, missing records, duplicates,catalog mismatches, mapping errors, manual adjustments, true variances) and quantify exposure by customer. Develop version-controlled transformation SQL with data-quality assertions that halt a load on a failed control — in Dataform/BigQuery, or in a governed spreadsheet environment with scripted validations where directed. Implement data-layer access segregation(BigQuery row-level access policies; column-level policy tags) so each OA sees only its own data regardless of the consuming tool. Build and maintain the exception-queue datamodel: every unresolved item carries an owner, a dollar value, a classification, and an age. Produce data dictionaries, mappingdocumentation, and reconciliation runbooks; support Government reperformance — the acceptance standard is Government staff reproducing the result without contractor assistance. Requirements: Security Clearance: Public Trust or the abilityto obtain one. Candidates whose experience is limited to advisory, strategic, or conceptual consulting will not meet this program's bar.The client explicitly requires demonstrated, hands‑on implementation experience— deployed cost models, executed billing cycles, delivered automations, and operational financial products. Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent additional experience. 5+ years of data engineering or systems-integration experience in financial data environments. Expert SQL; hands‑on ETL/ELT pipeline design with validation and error-handling discipline. Demonstrated experience reconciling financial systems against operational systems (ERP-to-ITSM, ERP-to-billing, or similar), including exception classification and disposition. Experience implementing data access controls(row/column-level security) in a multi-tenant or multi-customer reporting environment. Desired Skills Oracle E-Business Suite / Oracle FederalFinancials (Delphi) data structures; ServiceNow data model (CMDB, request/incident tables). Federal financial management context: Working Capital Funds, SFFAS 4, USSGL, month-end close, audit support. Apps Script or Python for pipeline glue; LookML/Looker exposure; Microsoft equivalents (Power Query, SQL Server, SSIS) with transfer aptitude. Benefits (provided by ourclient; W2 employees only, including part-time): Family Health Care (54% cost covered for theentire family) Family Dental (54% cost covered for the entirefamily) Family Vision (54% cost covered for the entirefamily) Overutilization bonuses for Time and Materials(T&M) contracts Lifetime Event Bonuses (e.g., child, marriage) Profit-sharing arrangement for any work brought into the company Unlimited Leave with Approval 401k 100% employer match on first 4% invested BizFirst LLC is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment. #J-18808-Ljbffr