Data Migration Engineer – Onsite – Atlanta, GA
W2 ONLY (NO C2C)
PUBLIC TRUST CLEARANCE REQUIRED
Required Skills: API Design: Intermediate Data Migration: Advanced Data Modeling: Advanced ETL Architecture & Development: Advanced SQL: Advanced 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
Never miss an opportunity! Create an alert based on the job you applied for.
