Data Engineer

Role Overview

• This role supports the large-scale modernization of legacy systems by leading the migration of over 10TB of documentation and records into a cloud-based environment.
• The position focuses on transforming document-heavy workflows into structured, digital processes, while enabling seamless data integration across systems using MuleSoft APIs.
• The work directly supports enhanced analytics, reporting, and operational efficiency for a mission-critical enterprise platform.
• Lead end-to-end data migration from legacy systems to cloud platforms, including data mapping, transformation, and validation (Salesforce-centric).
• Analyze and convert unstructured, document-heavy data into structured, analytics-ready formats using Document AI.
• Implement data quality processes (cleansing, deduplication, reconciliation) to ensure accuracy and completeness post-migration.
• Support phased migration and system cutover with minimal operational disruption.
• Design, build, and maintain MuleSoft integrations, including API development for real-time and batch data exchange.
• Apply data transformation logic (e.g., DataWeave) and troubleshoot integration/data flow issues across systems.
• Contribute to Salesforce Data 360 implementation, including data harmonization, identity resolution, and unified profiles.
• Ensure proper data ingestion, lineage, metadata management, and traceability across the ecosystem.
• Ensure compliance with data governance, privacy, and security requirements (e.g., PII).
• Collaborate in Agile teams; support testing, documentation, and audit readiness across migration and integration efforts.

Requirements

• U.S. Citizenship required due to federal contract requirements
• Ability to obtain and maintain a Public Trust clearance
• Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years
• 6+ years of experience in data engineering, data migration, or data integration roles
• Proven experience executing large-scale data migration efforts, including legacy system transformation
• 2+ years hands-on experience with Salesforce data migrations, including data modeling, data loading (e.g., Data Loader, APIs), and managing relational datasets
• 2+ years' experience implementing data quality, validation, and reconciliation processes during migration efforts
• Current or recent Public Trust or active Secret clearance
• Experience supporting DHS or other federal agencies
• 1+ year Experience using Informatica (e.g., PowerCenter, IICS) for ETL/ELT development, data mapping, and pipeline orchestration
• 2+ years proficiency in SQL and relational data modeling concepts
• Experience working with both structured and unstructured data, including document-based records
• 1+ year Experience supporting or developing MuleSoft integrations, including API development, data transformations, and system-to-system data flows
• 1+ years experience with MuleSoft Anypoint Platform, including DataWeave and API-led connectivity patterns
• Familiarity with cloud-based SaaS platforms and distributed data architectures
• Familiarity with metadata management, data lineage, and audit frameworks
• Experience working in federal or highly regulated environments
• Experience supporting Agile delivery teams and cross-functional collaboration
• Experience supporting large-scale, document-centric system migrations
• Familiarity with Docusign eSignature and Contract Lifecycle Management (CLM) products a plus
• Experience with Salesforce Data 360 (Data Cloud), including data harmonization and identity resolution
• Experience with Salesforce Document AI / Intelligent Document Processing (IDP) tools for extracting structured data from documents
• Understanding of data governance, security, and compliance requirements, particularly for sensitive data (e.g., PII)

Tech Stack

• Cloud
• ETL
• Informatica
• SQL

Benefits

• Reasonable Accommodations
• Health insurance,401(k) matching,Flexible work hours,Paid time off,Remote work options