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.

In this job you will:

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.

Qualifications for the role:

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:

Remote
Occasional onsite possible - 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, 401k match, paid parental leave, 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.

A3 Consulting, LLC

Latest Jobs

Data Migration & ETL Engineer w/Top Secret Clearance