Data Integration Engineer

Socket.dev; Virginia (MN); Hybrid; USD 99,000 - 168,000; Full time

Job summary

ICF is seeking a Data Integration Engineer to design secure data pipelines and migrations for government data. You will map legacy data to target schemas, build integrations via APIs, and ensure data quality, validation, and traceability in a collaborative, delivery-focused environment.

Remote work is authorized with US Eastern time alignment; candidates must be a US citizen and pass a Public Trust background check. Minimum five years of experience in end-to-end data pipelines is required.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Strong SQL skills and experience with Microsoft SQL Server.
• Experience with SSIS and at least one of Python, Java, Scala, or R.
• Experience with APIs, relational and NoSQL databases, and cloud data platforms.
• Ability to work effectively in Agile delivery teams and collaborate with government and contractor stakeholders.
• Clear written and verbal communication skills, strong organization, and attention to detail.
• Azure, AWS, GCP, or data-engineering certification.
• Experience with Databricks, Azure Data Factory, Spark, Hadoop, or Kafka.

Responsibilities

• Design, build, and optimize ETL and data-integration pipelines.
• Map and transform legacy data into approved target schemas and models.
• Create integrations using APIs, database tools, and data-platform services.
• Implement data-quality checks, validation, monitoring, security, and traceability.
• Tune data movement and storage for reliability and performance.
• Collaborate with data governance personnel, subject-matter experts, developers, and testers.

Skills

SQL

SSIS

Python

Java

Scala

R

APIs

NoSQL databases

Cloud platforms

Agile

Education

Bachelor's degree

Tools

Microsoft SQL Server

Azure Data Factory

Databricks

Spark

Hadoop

Kafka

Job description

The Work

Our Digital Modernization Division is an information technology and management consulting department that offers integrated, strategic solutions to public- and private-sector clients. ICF brings the expertise, agility, and commitment to design, build, and operate high-performance IT solutions that support clients' missions.

The Data Integration Engineer will design and implement secure, traceable data pipelines and integrations for the migration and modernization of government data. The role focuses on mapping, transformation, validation, monitoring, and reliable movement of structured and unstructured data.

Job Location:

Remote work is authorized. Must support US Eastern time zone working hours.

*If you accept this position, you should note that ICF does monitor employee work locations blocks access from foreign locations/foreign IP addresses and prohibits personal VPN connections.

What You Will Do

• Design, build, and optimize ETL and data-integration pipelines.

• Map and transform legacy data into approved target schemas and models.

• Create integrations using APIs, database tools, and data-platform services.

• Implement data-quality checks, validation, monitoring, security, and traceability.

• Tune data movement and storage for reliability and performance.

• Collaborate with data governance personnel, subject-matter experts, developers, and testers.

What You Will Bring With You

• Candidate must reside in the U.S., be authorized to work in the U.S., and all work must be performed in the U.S.

• Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years

• Candidate must be able to pass successful Public Trust background check

• US Citizenship is required by the federal government for this position

• Minimum five years of experience designing and optimizing end-to-end data pipelines, ETL, data models, validation, storage, and retrieval.

What We Would Like You To Bring With You

• Bachelor's degree in a related field; directly related experience may be considered in place of education.

• Strong SQL skills and experience with Microsoft SQL Server.

• Experience with SSIS and at least one of Python, Java, Scala, or R.

• Experience with APIs, relational and NoSQL databases, and cloud data platforms.

• Ability to work effectively in Agile delivery teams and collaborate with government and contractor stakeholders.

• Clear written and verbal communication skills, strong organization, and attention to detail.

• Azure, AWS, GCP, or data-engineering certification.

• Experience with Databricks, Azure Data Factory, Spark, Hadoop, or Kafka.

Professional Skills

• Highly effective analytical, problem-solving, and decision-making capabilities.

• Excellent communication and interpersonal skills to work effectively across business, technical, and client teams.

• Organized, detail-oriented, and able to prioritize multiple assignments in a delivery-focused environment

Bot and Third-Party Applications

Please note that this application must be submitted directly by the applicant for consideration.Failure to do so may result in the application being excluded for consideration. Applicants needing an accommodation for disability or religious purposes in connection with the application process should contact [e-mail] for assistance.

Working at 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 theirexpertiseand collaborate with others to achieve personal and professional goals. For more information, please read ourEEOpolicy.

We will consider for employment qualified applicants with arrest and conviction records.

Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals withsincerely heldreligious beliefs, in all phases of the application and employment process. To requestan accommodation,please email [e-mail] and we will be happy toassist. All information you provide will be kept confidential and will be used only to the extentrequiredto provide needed reasonable accommodations.

Read more aboutworkplacediscriminationrightsor our benefit offerings which are included in theTransparency in (Benefits) CoverageAct.

Candidate AI Usage Policy

At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate orassistwith responses during interviews (whether in-person or virtual) is notpermitted. This policy is in place tomaintainthe integrity and authenticity of the interview process.

However, we understand that some candidates may require accommodationthat involves the use of AI. Ifsuch anaccommodation is needed, candidates are instructed to contact us in advance at [e-mail]. Weare dedicated to providingthe necessary support to ensure that all candidates have an equal opportunity to succeed.

Pay Range

The pay range for this position based on full-time employment is:

$98,614.00 - $167,644.00Nationwide Remote Office (US99)