Data Engineering & Reconciliation Strategist

AssurIT; Fairfax (VA); Hybrid; USD 100,000 - 150,000; Full time

Benefits offered by this job

Medical and dental coverage

Paid time off

Job summary

Assurit seeks a Data Engineering & Reconciliation Specialist to support a DoD FIAR data quality initiative. You will bridge project teams, system owners, control owners, and audit stakeholders to enhance data quality, reconciliation, and audit readiness across enterprise systems.

The role focuses on end-to-end data flow analysis, data rules development, evidence preparation, and AI-ready dataset creation for Power BI analytics.

Qualifications

• Bachelor’s degree or equivalent professional experience.
• 5+ years in data engineering, data quality, reconciliation, BI, or related tech initiatives.
• Experience analyzing end-to-end data flows and data lineage.
• Ability to translate business/audit requirements into data rules and mappings.
• Experience creating source-to-target mappings and reconciliation logic.
• Strong documentation and traceability skills.
• Clear communication with cross-functional teams.

Responsibilities

• Aggregate and review PCM content for processes and systems.
• Review third-party dependencies and SOC/CUECs for GRC alignment.
• Walkthroughs with system owners to trace data flows and validate controls.
• Identify reconciliation breakpoints, root causes, and impacts.
• Translate requirements into data rules, mappings, and validation needs.
• Design and maintain source-to-target mappings and exception rules.
• Support testing and prepare audit evidence packages and logs.
• Develop AI-ready datasets to support Power BI dashboards.

Skills

Data engineering

Data quality

Reconciliation

Audit readiness

Analytical skills

Communication

Documentation

Education

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

Tools

Python

SQL

R

Databricks

Scala

Visual Basic

Power BI

Job description

Assurit seeks a Data Engineering & Reconciliation Specialist to support a DoD FIAR data quality initiative. You will bridge project teams, system owners, control owners, and audit stakeholders to enhance data quality, reconciliation, and audit readiness across enterprise systems.

The role focuses on end-to-end data flow analysis, data rules development, evidence preparation, and AI-ready dataset creation for Power BI analytics.