Data Engineering & Reconciliation Specialist Assurit

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

Data Engineering & Reconciliation Specialist

Assurit is currently seeking an experienced Data Engineering & Reconciliation Specialist to support one of our clients.

About the Role:

Assurit is seeking a Data Engineering & Reconciliation Specialist to support a Department of the Air Force (DAF) Financial Improvement and Audit Remediation (FIAR) Data Quality initiative. This position serves as a key integration point between project teams, system owners, control owners, and audit stakeholders to improve enterprise data quality, reconciliation, traceability, and audit readiness.

The ideal candidate possesses experience analyzing end-to-end data flows, identifying reconciliation breakpoints, validating control execution, and translating business and audit requirements into actionable data engineering and reconciliation solutions. This individual will help strengthen data quality, improve control traceability, and support remediation activities across multiple enterprise systems.

Responsibilities:

• Aggregate and review Process Control Matrix (PCM) content for assigned business processes and systems.
• Review third-party system dependencies, including SOC reports and Complementary User Entity Controls (CUECs), and support incorporation of applicable CUECs into Governance, Risk, and Compliance (GRC) processes.
• Support walkthroughs with system owners to trace end-to-end data flows, validate control execution, and confirm evidence requirements.
• Conduct deep-dive analyses to identify reconciliation breakpoints, root causes, and downstream impacts.
• Translate business and audit requirements into data rules, mappings, reconciliation logic, and validation requirements.
• Design and maintain source-to-target mappings, reconciliation logic, and exception-handling rules.
• Support testing activities to validate the effectiveness of implemented solutions.
• Prepare evidence packages, traceability matrices, issue logs, and supporting documentation for audit and remediation activities.
• Develop reporting inputs and structured, AI-ready datasets to support Power BI dashboards and analytics.
• Collaborate with system owners, interface specialists, IT audit teams, data quality leads, and business stakeholders to ensure consistency and traceability across project deliverables.
• Maintain documentation of assumptions, dependencies, limitations, risks, and open issues.
• Support remediation tracking, solution validation, re-testing, and post-implementation verification.

Required Qualifications:

• Active Secret Clearance or Interim Secret Clearance with the ability to obtain and maintain a Secret Clearance.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Business, or a related discipline. Equivalent professional experience may be considered in lieu of a degree.
• Minimum of 5 years of relevant professional experience supporting data engineering, data analysis, data quality, reconciliation, business intelligence, enterprise reporting, or related technical initiatives. Candidates with 2+ years of highly relevant experience are also encouraged to apply.
• Strong ability to analyze technical data flows and business processes from end to end.
• Experience identifying data quality issues, reconciliation breakpoints, control gaps, and traceability challenges.
• Experience translating business and control requirements into technical solutions.
• Experience creating and maintaining source-to-target mappings, data lineage documentation, and reconciliation logic.
• Strong analytical and problem-solving skills with the ability to isolate issues across systems, interfaces, and data structures.
• Experience developing validation rules, reconciliation logic, and exception-handling processes.
• Strong documentation skills with exceptional attention to traceability, evidence quality, and accuracy.
• Experience collaborating across business, technology, audit, governance, and data management teams.
• Familiarity with data quality concepts, data profiling, and structured data for reporting and analytics.
• Excellent written and verbal communication skills.

Preferred Qualifications:

• Experience supporting data reconciliation, control traceability, audit readiness, or IT audit remediation initiatives.
• Experience working with enterprise systems, interfaces, or complex data integration environments.
• Experience creating and maintaining databases or developing data analytics solutions.
• Experience with one or more of the following: Python, SQL, R, Databricks, Scala, & Visual Basic.
• Experience supporting Power BI or similar enterprise analytics platforms.
• Experience working within Department of Defense (DoD) or Department of the Air Force (DAF) environments.
• Experience supporting enterprise data governance, audit remediation, or financial systems modernization initiatives.
• Data visualizations
• Data analytics reports
• Data cleansing scripts and processes
• Technical data analytics

Clearance:

• Active or Interim Secret Clearance Required

Assurit is an award winning, certified small business headquartered in Fairfax, VA. We offer a highly competitive compensation and benefits package inclusive of medical and dental coverage, as well as paid time off.

Founded in 2013, Assurit has become a trusted provider of cybersecurity expertise to customers across federal, state and local governments, as well as the commercial sector. We are an employee-centric organization that focuses on the growth and development of our greatest asset – our people. We believe that if our Team is trained and educated, we will always be able to deliver our promise of customer success. If you enjoy work environments focused on continuous learning and growth, Assurit will be a great fit for you.

Assurit is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.