Data/Migration Engineer with Security Clearance

Integral Federal, Inc.; Vienna (VA); On-site; USD 135,000 - 165,000; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

401(k) with immediate vesting in 401(k

Paid Time Off & Holidays

Professional Training Reimbursement

Employee Assistance Program

Job summary

Integral Federal, Inc. seeks a Data/Migration Engineer to lead data migration, cleansing, profiling, and transformation across VA environments (production to lower, legacy to BIP/AWS VAEC) to deliver secure, reliable IT solutions for VA/OIT.

The role requires 10+ years in data engineering, experience with ETL/ELT, DDL/DML updates, data masking/sanitization, test data creation, BI support, and cloud migration (AWS/VAEC).

Qualifications

• Bachelor’s Degree in computer science or IT with 10+ years of experience.
• Experience in data migration, data cleansing, profile analysis, ETL/ELT processing, and transformation.
• Experience executing DDL/DML updates, database refreshes, and data masking/sanitization.
• Experience supporting cloud migration efforts (AWS, VAEC) and legacy data modernization.
• Experience providing BI support, FinOps data analysis, and quality monitoring activities.
• Experience developing test data, managing database performance, and supporting migration tools.
• Knowledge of database migration tools (Liquibase, Flyway, DMS, GoldenGate, etc.) and cloud data services.
• Strong understanding of masking/sanitization techniques and compliance requirements for handling VA data.
• Public Trust Preferred: Use of Oracle; DMS, GoldenGate, AWS Glue, Pentaho; legacy modernization.

Responsibilities

• Executes data profiling, cleansing, and migration strategies, including test data creation.
• Maintains data governance-related artifacts and participates in peer reviews.
• Supports development and implementation of data migration strategies, plans, requirements, and testing.
• Maintains repeatable processes and scripts for masking/sanitization during production refreshes.
• Supports BI integration, FinOps reporting analysis, and data quality monitoring.
• Manages DDL/DML updates, database refreshes, and masking/sanitization processes.
• Supports creation and maintenance of Data Models, Data Dictionaries, Data Catalogs, and migration documentation.

Skills

Data migration

Data cleansing

Data profiling

ETL/ELT

Data transformation

BI support

Data quality monitoring

Test data creation

Cloud migration

Masking/sanitization

Database performance

Migration tooling

Education

Bachelor’s Degree in Computer Science or IT

Tools

Liquibase

Flyway

DMS

GoldenGate

AWS Glue

Pentaho

Job description

The Data/Migration Engineer is responsible for executing and supporting all data migration, cleansing, profiling, and transformation activities required to modernize systems and move data between environments (production → lower environments, legacy → modern VA platforms such as BIP/AWS VAEC) for the Department of Veterans Affairs (VA), Office of Information and Technology (OIT), Product Delivery Services (PDS), Benefits and Memorials (BAM), Memorial and Benefit Services (MBS) deliver secure, reliable, and effective Information Technology (IT) solutions that support the Department’s mission.

• Ensures data quality, prepares test data, manages database refresh operations, and supports BI, FinOps, and data governance initiatives.
• Execute data profiling, cleansing, and migration strategies, including creation of test data.
• Support development and implementation of data migration strategies, plans, requirements, and testing across environments.
• Maintain repeatable processes and scripts to mask/sanitize data when databases are refreshed from production.
• Detect and resolve data quality issues, performing analysis on causes, impacts, and remediation.
• Maintain Architecture Document Artifacts and participate in peer reviews.
• Support creation and maintenance of Data Models, Data Dictionaries, Data Catalogs, and migration documentation

• Manage DDL/DML updates, database refreshes, and masking/sanitization processes.
• Execute data profiling, cleansing, migration strategies, and test data creation.
• Manage DDL/DML updates, database refreshes, and masking/sanitization processes.
• Support BI integration, FinOps reporting analysis, and data quality monitoring.
• Qualifications Required: * Bachelor’s Degree in computer science or IT with 10+ years' experience
• Experience in data migration, data cleansing, profile analysis, ETL/ELT processing, and transformation.
• Experience executing DDL/DML updates, performing database refreshes, and implementing data masking/sanitization processes. * Experience supporting cloud migration efforts (AWS, VAEC) and legacy data modernization. * Experience providing BI support, FinOps data analysis, and quality monitoring activities. * Experience developing test data, managing database performance, and supporting migration tools
• Knowledge of database migration tools (Liquibase, Flyway, DMS, GoldenGate, etc.) and cloud data services
• Strong understanding of masking/sanitization techniques and compliance requirements for handling VA data
• Public Trust Preferred: * Use of Oracle; DMS, GoldenGate, AWS Glue, Pentaho; legacy modernization

Salary Range: $135,000 - $165,000 This position is in the proposal stage. The above salary range represents a general guideline. Integral Federal considers a number of factors when determining base salary offers, such as the scope and responsibilities of the position and the candidate's experience, education, skills, and current market conditions. Depending on the position, employees may be eligible for overtime, shift differential, and/or discretionary bonuses in addition to base pay.

Company Overview

Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure. Integral is headquartered in McLean, VA and serves clients throughout the country. We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal! Our package also includes:

• Medical, Dental & Vision Insurance
• Flexible Spending Accounts
• Short-Term and Long-Term Disability Insurance
• Life Insurance
• Paid Time Off & Holidays
• Earned Bonuses & Awards
• Professional Training Reimbursement
• Employee Assistance Program Equal Opportunity Employer/Protected Veteran/Disability