Data Migration Engineer

Required Skills:

• API Design
• Intermediate Data Migration
• Advanced Data Modeling
• Advanced ETL Architecture & Development
• Advanced SQL

Preferred Skills:

Agile Software Development Methodology

Intermediate Federal Acquisition Regulation (FAR)

Foundation Oracle Database: Advanced Requirements Collection and Management: Intermediate Verbal Communication/Presenting: Advanced

Day-to-day Responsibilities:

The Federal Acquisition Data Migration Developer will play a key role in extracting data from an Appian-based contract writing solution to a format provided by the client to ingest into a legacy acquisition database as defined by the client. This role entails designing, developing, and executing data migration processes for acquisition-related data, ensuring compliance with federal regulations and agency-specific guidelines. The ideal candidate possesses experience working with federal acquisition data sources and understands the rigor required for secure, auditable, and high-integrity data migrations. Key

Responsibilities:

• Data Migration Design & Execution - Design and build migration solutions for federal acquisition data, including contract and procurement information, mapping complex data structures.
• ETL Process Development - Develop, test, and deploy robust Extract and Transform processes for structured and unstructured acquisition data using federal-compliant tools and methods.
• Source-to-Target Mapping - Analyze and document mapping between legacy federal acquisition systems (e.g., FPDS-NG, PRISM, SAM.gov) and target environments, accounting for data quality, normalization, and transformation needs.
• Compliance & Security - Ensure all migration processes strictly adhere to federal data privacy and security standards (e.g., FISMA, FedRAMP, NIST 800-53), providing for audit traceability and compliance reporting.
• Data Quality Assurance - Identify and resolve data quality issues, perform data cleansing for accuracy and completeness, and support acceptance testing with business users.
• Collaboration & Documentation - Collaborate closely with federal acquisition SMEs, functional analysts, and technical teams to understand requirements and address migration challenges. Maintain clear, comprehensive solution documentation.
• Performance Monitoring & Tuning - Monitor data migration jobs and optimize for efficient, error-free execution, troubleshooting and addressing technical issues promptly." Expected Deliverables: Input into prime's status reporting processes; weekly timecards Education: BS or equivalent