Data Integration Engineer - Federal Finance & Analytics

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

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.