Data Migration & ETL Engineer w/Top Secret Clearance

A3 Consulting LLC; Springfield (VA); Hybrid; USD 160,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) match

Paid parental leave

Job summary

A leading consulting firm is seeking a highly skilled Data Migration & ETL Engineer for a critical project in a government initiative. The role involves designing ETL processes for migrating large datasets to the ServiceNow platform, ensuring data integrity and developing scripts for data transformation. Candidates must have a bachelor's degree and 3 to 5+ years of relevant experience, particularly with ServiceNow systems, SQL, and Python. A robust benefits package is offered alongside a competitive salary range between $160,000 and $180,000.

Qualifications

• 3 to 5+ years of experience in a data engineering, ETL, or data migration role.
• Direct experience with large-scale data migration into the ServiceNow platform.
• Expert-level proficiency in SQL, including complex queries.

Responsibilities

• Design and develop the ETL process for migrating datasets to ServiceNow.
• Create detailed source-to-target data mapping documents.
• Implement data validation and reconciliation procedures.

Skills

Data migration

ETL processes

SQL

Python

Data analysis

PostgreSQL

Education

Bachelor's degree in Computer Science or related field

Tools

ServiceNow

ServiceNow Integration Hub

Job description

A3 Consulting, LLC is seeking a highly skilled Data Migration & ETL Engineer to execute a critical phase of a major DoD Insider Threat program. This position will be the hands‑on expert responsible for the analysis, mapping, and migration of vital data from a legacy system into a new, custom‑built application on the ServiceNow Public Sector Digital Services (PSDS) platform. If you are a data expert who understands the unique challenges of migrating data into the ServiceNow platform within a secure government environment, scalable solutions, this role is for you.

Responsibilities

• Design, develop, and execute the end‑to‑end ETL process for migrating large datasets from a PostgreSQL‑based legacy system into the ServiceNow platform.
• Create detailed source‑to‑target data mapping documents, defining the transformation logic required to align legacy data with the new ServiceNow application’s data model.
• Build and manage robust data loading solutions in ServiceNow, leveraging Import Sets, Transform Maps, and advanced scripting to ensure efficient and accurate data ingestion.
• Perform in‑depth analysis of the source data to identify potential quality issues, anomalies, and inconsistencies prior to migration.
• Implement rigorous data validation and reconciliation procedures to ensure data integrity and completeness between the source and target systems.
• Develop and execute scripts to cleanse and transform data, ensuring it conforms to the business rules and requirements of the new application.
• Develop processes to extract data from various sources, including direct database queries and external system APIs (REST/SOAP) for ongoing data integration needs.
• Write Python scripts to automate extraction, transformation, and data quality checks, improving the efficiency and reliability of the migration process.
• Collaborate with the Development Team to understand API endpoints and data structures for both legacy and future data integrations.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
• 3 to 5+ years of experience in a data engineering, ETL, or data migration role.
• Direct, hands‑on experience with large‑scale data migration into the ServiceNow platform, including deep knowledge of Import Sets, Transform Maps, and the ServiceNow data model.
• Proven experience working with ServiceNow Public Sector Digital Services (PSDS).
• Expert‑level proficiency in SQL, including writing complex queries for data extraction and analysis.
• Proven experience extracting data from relational databases (especially PostgreSQL).
• Strong scripting skills, particularly in Python, for data manipulation and automation.

Desired Qualifications

• Experience using ServiceNow Integration Hub for ETL processes.
• Familiarity with DoD data standards and policies.
• Knowledge of federal records management requirements (NARA).
• Experience migrating data for case management or analytical systems.

Clearance Level

• Active Top Secret

Location

• Hybrid
• Onsite Location TBD (Potential Sites – Crystal City, VA; Springfield, VA; or Ft. Meade)

Salary range

• The salary range of this position is $160,000 – $180,000 commensurate with experience and achievement.

Benefit Information

• A3 Consulting offers a robust benefits package to include but not limited to medical, dental, and vision benefits, flexible spending and health savings accounts, group life and AD&D, short‑term and long‑term disability, paid time off, 401(k) match, paid parental leave, and professional development.

A3 Consulting, LLC is an equal opportunity employer. We believe in hiring a diverse workforce and sustaining an inclusive, people‑first culture. We are committed to non‑discrimination on any protected basis, such as disability and veteran status, or any other basis covered under applicable law.