Description

Data Migration & ETL Engineer w/Top Secret Clearance

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:

• 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, 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.

PI280654953