ICF logo
ICF

ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy.

Data Engineer

Data EngineerData EngineerFull TimeRemoteSeniorTeam 5,001-10,000Since 1969Company SiteLinkedIn

Location

Virginia + 1 moreAll locations: Virginia | West Virginia

Posted

3 days ago

Salary

$98.6K - $167.6K / year

Seniority

Senior

Bachelor Degree6 yrs expEnglishCloudETLInformaticaSQL

Job Description

Data Engineer

ICF

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

Job 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 (preferred)
  • Experience supporting DHS or other federal agencies (preferred)
  • 1+ year Experience using Informatica (e.g., PowerCenter, IICS) for ETL/ELT development, data mapping, and pipeline orchestration (preferred)
  • 2+ years proficiency in SQL and relational data modeling concepts (preferred)
  • Familiarity with cloud-based SaaS platforms and distributed data architectures (preferred)
  • Familiarity with metadata management, data lineage, and audit frameworks (preferred)
  • Experience working in federal or highly regulated environments (preferred)
  • Experience supporting Agile delivery teams and cross-functional collaboration (preferred)
  • Experience supporting large-scale, document-centric system migrations (preferred)
  • Familiarity with Docusign eSignature and Contract Lifecycle Management (CLM) products a plus (preferred)
  • Experience with Salesforce Data 360 (Data Cloud), including data harmonization and identity resolution (preferred)
  • Experience with Salesforce Document AI / Intelligent Document Processing (IDP) tools for extracting structured data from documents (preferred)
  • Understanding of data governance, security, and compliance requirements, particularly for sensitive data (e.g., PII) (preferred).

Benefits

  • Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process.

Related Categories

Related Job Pages

More Data Engineer Jobs

Full TimeRemoteTeam 10,001+

• Design and build the AWS-native data foundation behind enterprise AI applications • Lead the design and evolution of the knowledge graphs and ontologies powering AI's reasoning, retrieval, and explainability • Align enterprise data into a coherent, queryable graph with clear provenance across structured, semi-structured, and unstructured sources • Curate grounding corpora, eval datasets, and retrieval benchmarks for LLM-based features • Build ingestion and transformation pipelines in Python and SQL using AWS services • Author infrastructure as code in CloudFormation and apply AWS best practices • Partner with security and platform teams to integrate data access with enterprise identity and access policies • Set the design direction for data and semantic modeling across the team

United States
$95K - $159K / year
Hanover logo

Senior Data Protection Engineer

Hanover

Achieving Remarkable Results through Exceptional People - Executive Search, Consulting, Coaching & Outplacement

Data Engineer3 days ago
Full TimeRemoteTeam 51-200Since 1996

• Design and develop solutions addressing new features, interoperability, vulnerabilities, and system limitations. • Evaluate current capabilities, anticipate future needs, and partner with stakeholders and vendors to deliver enhancements. • Research, design, and implement enterprise security solutions that align with business strategy and protect organizational data. • Support and influence change management and security initiatives across assigned areas. • Integrate security into business processes and assess risks associated with new applications and technologies. • Provide recommendations to mitigate risk and support business objectives. • Serve as a security subject matter expert to engineering, architecture, and development teams. • Perform advanced troubleshooting and provide support, including participation in on-call rotations. • Deliver timely reports and findings to management and leadership. • Recommend and interpret security policies, standards, and best practices. • Identify risk gaps and develop appropriate solutions. • Stay current on emerging threats and trends, assessing impact and integrating improvements into security strategies. • Drive process improvements that enhance quality and efficiency across teams. • Provide guidance and technical direction on complex initiatives. • Develop and maintain correlation searches and alerts using diverse log sources. • Optimize detection and response through automation, orchestration, and advanced analytics. • Monitor and ensure the effectiveness of prevention, detection, and response capabilities. • Collaborate with cybersecurity engineering and threat intelligence teams to improve security tools and processes. • Contribute to the development of cybersecurity procedures. • Mentor and train team members. • Demonstrate initiative and accountability in achieving results.

Massachusetts
Hanover logo

Data Engineer – Associate to Senior Level

Hanover

Achieving Remarkable Results through Exceptional People - Executive Search, Consulting, Coaching & Outplacement

Data Engineer3 days ago
Full TimeRemoteTeam 51-200Since 1996

• Design, build, and optimize data pipelines and ETL workflows • Develop scalable data models, data structures, and data integrations • Work with modern cloud platforms including Azure Synapse, Data Factory, Data Lake, and Databricks • Ensure data quality, governance, security, and compliance • Partner with business stakeholders, analysts, and data scientists • Contribute to or lead complex, cross-functional data initiatives • Improve platform reliability through monitoring, validation, and automation • Create clear documentation, runbooks, and data lineage • Mentor junior engineers (Senior-level roles)

Massachusetts
Hanover Insurance Group logo

Senior Data Protection Engineer

Hanover Insurance Group

Hanover Insurance Group has consistently been named one of America’s Best Midsized Employers by Forbes magazine and one of Business Insurance magazine's Best

Data Engineer3 days ago

• Design and develop solutions addressing new features, interoperability, vulnerabilities, and system limitations. • Evaluate current capabilities, anticipate future needs, and partner with stakeholders and vendors to deliver enhancements. • Research, design, and implement enterprise security solutions that align with business strategy and protect organizational data. • Support and influence change management and security initiatives across assigned areas. • Integrate security into business processes and assess risks associated with new applications and technologies. • Provide recommendations to mitigate risk and support business objectives. • Serve as a security subject matter expert to engineering, architecture, and development teams. • Perform advanced troubleshooting and provide support, including participation in on-call rotations. • Deliver timely reports and findings to management and leadership. • Recommend and interpret security policies, standards, and best practices. • Identify risk gaps and develop appropriate solutions. • Stay current on emerging threats and trends, assessing impact and integrating improvements into security strategies. • Drive process improvements that enhance quality and efficiency across teams. • Provide guidance and technical direction on complex initiatives. • Develop and maintain correlation searches and alerts using diverse log sources. • Optimize detection and response through automation, orchestration, and advanced analytics. • Monitor and ensure the effectiveness of prevention, detection, and response capabilities. • Collaborate with cybersecurity engineering and threat intelligence teams to improve security tools and processes. • Contribute to the development of cybersecurity procedures. • Mentor and train team members. • Demonstrate initiative and accountability in achieving results.

Massachusetts