Data / Integration Engineer

BizFirst; Washington; On-site; USD 83,000 - 124,000; Part time

Benefits offered by this job

Family Health Care

Family Dental

Family Vision

Time and materials bonuses

Lifetime Event Bonuses

401k matching

Unlimited Leave

Job summary

BizFirst is recruiting a Data / Integration Engineer to support the U.S. Department of Transportation program. The role focuses on controlled extracts, data mapping, and reconciliation across Delphi, ServiceNow, and PRISM in a Google-cloud and enterprise environment.

The candidate will implement data access controls, build transformation pipelines in Dataform/BigQuery, and provide runbooks and data dictionaries for government reperformance. Strong SQL, ETL/ELT, and hands-on delivery are required.

Qualifications

• 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.
• Experience reconciling financial systems against operational systems (ERP-to-ITSM, ERP-to-billing, or similar).

Responsibilities

• Own the controlled movement and reconciliation of data between government financial and operational systems.
• Design and maintain the common-key mapping layer for period, customer, service, and funding source.
• Engineer ServiceNow-to-Delphi reconciliation by period, customer, service, and transaction class across 11 Operating Administrations.
• Develop version-controlled transformation SQL with data-quality assertions that halt a load on failure.
• Implement data-layer access segregation to enforce OA data visibility.
• Build and maintain the exception-queue datamodel with owner, value, classification, and age.
• Produce data dictionaries, mapping documentation, and reconciliation runbooks.

Skills

Data engineering

SQL

ETL/ELT pipelines

Data validation

Data reconciliation

ServiceNow

Delphi

BigQuery

Looker

Power BI

Education

Bachelor’s degree in Computer Science / Information Systems / Data Analytics

Tools

Oracle Federal Financials (Delphi)

ServiceNow

PRISM

Dataform

Google Cloud (BigQuery)

Google Apps Script

Python

Power Query

SQL Server

Job description

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.