Data Engineer (Python) - Remote USA

ICF; Reston (VA); Remote; USD 81,000 - 168,000; Full time

Job summary

ICF is seeking a Data Engineer to design and operate reliable data pipelines and reporting integrations across PostgreSQL, SQL, Databricks, and DataConnect with AWS QuickSight. The candidate will translate requirements into maintainable code and collaborate with senior engineers, data scientists, analysts, and DevOps teams.

The role emphasizes secure data access, CI/CD practices, and agile collaboration, with a focus on delivering scalable data solutions across cloud platforms.

Qualifications

• Bachelor's degree in a related field.
• 3+ years hands-on software development or data engineering experience.
• Ability to obtain and maintain a Public Trust clearance.
• Candidate must reside in the United States and be authorized to work in the United States.

Responsibilities

• Design, develop, test, and maintain data pipelines and transformation workflows using SQL, Python, Databricks, and cloud technologies.
• Develop and optimize PostgreSQL database objects, queries, data models, and data-access patterns.
• Build and maintain integrations that support DataConnect reporting through AWS QuickSight and Databricks.
• Develop API services and reusable components that facilitate secure data access and system integration.
• Support extraction, transformation, and loading of data from multiple sources while meeting functional and non-functional requirements.
• Create and maintain data-quality checks, validation jobs, monitoring, and operational alerts.
• Troubleshoot data issues and improve pipeline reliability, performance, availability, and refresh timeliness.

Skills

SQL

Python

Data pipelines

REST APIs

CI/CD

Education

Bachelor's degree

Tools

Databricks

PostgreSQL

AWS QuickSight

GitHub Actions

Terraform

Job description

Description

ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference, and we seek candidates who are passionate about building a culture that encourages, embraces, and hires dimensions of difference. Our Health Engineering Systems (HES) team works side by side with customers to define a vision for success and deliver practical, secure solutions. We are seeking a Data Engineer to develop and support reliable data pipelines, database solutions, and reporting integrations across PostgreSQL, SQL, Databricks, and the DataConnect reporting environment using AWS QuickSight.

Description

ICF is a mission-driven company filled with people who care deeply about improving the lives of others and making the world a better place. Our core values include Embracing Difference, and we seek candidates who are passionate about building a culture that encourages, embraces, and hires dimensions of difference. Our Health Engineering Systems (HES) team works side by side with customers to define a vision for success and deliver practical, secure solutions. We are seeking a Data Engineer to develop and support reliable data pipelines, database solutions, and reporting integrations across PostgreSQL, SQL, Databricks, and the DataConnect reporting environment using AWS QuickSight. The ideal candidate can translate requirements into maintainable code and contribute independently while partnering with senior engineers, data scientists, analysts, and DevOps team members.

Responsibilities

• Design, develop, test, and maintain data pipelines and transformation workflows using SQL, Python, Databricks, and cloud technologies.
• Develop and optimize PostgreSQL database objects, queries, data models, and data-access patterns.
• Build and maintain integrations that support DataConnect reporting through AWS QuickSight and Databricks.
• Develop API services and reusable components that facilitate secure data access and system integration.
• Support extraction, transformation, and loading of data from multiple sources while meeting functional and non-functional requirements.
• Create and maintain data-quality checks, validation jobs, monitoring, and operational alerts.
• Troubleshoot data issues and improve pipeline reliability, performance, availability, and refresh timeliness.
• Write unit and integration tests for data-processing code and participate in code reviews.
• Translate technical specifications and business requirements into code, data designs, and implementation documentation.
• Collaborate with DevOps engineers on CI/CD, infrastructure as code, deployment, and environment support.
• Apply security and privacy controls for data at rest and in transit.
• Contribute to Agile planning, refinement, estimation, and continuous improvement activities.
• Other duties as assigned.

Minimum Qualifications

• Bachelor's degree
• 3+ years of hands-on software development or data engineering experience.
• Candidate must be able to obtain and maintain a Public Trust clearance.
• Candidate must reside in the United States, be authorized to work in the United States, and have lived in the United States for three full years out of the last five years.

What You Will Bring

• 2+ years of experience developing data pipelines or data-processing solutions using SQL and Python or a comparable programming language.
• Hands-on experience with PostgreSQL and strong knowledge of relational database concepts and SQL.
• Experience working with cloud-based data platforms and version-controlled development workflows.
• Ability to read technical specifications and translate them into working code and documentation.

Preferred Qualifications

• Experience developing data workflows on the Databricks platform.
• Experience creating datasets, dashboards, or reporting integrations with AWS QuickSight.
• Experience with Spark, Airflow, AWS data services, or similar pipeline and orchestration technologies.
• Experience building or supporting REST APIs.
• Working knowledge of TypeScript for services, integrations, automation, or data-access applications.
• Familiarity with CI/CD pipelines, GitHub Actions, Terraform, or other infrastructure-as-code tools.
• Experience with data governance, metadata, data lineage, and secure data-sharing practices.
• Experience working in Agile teams and using test-driven development practices.

Job Location

This position requires that the job be performed in the United States. The candidate must reside in the United States, be authorized to work in the United States, and perform all work in the United States. ICF monitors employee work locations, blocks access from foreign locations and foreign IP addresses, and prohibits personal VPN connections.

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 their expertise and collaborate with others to achieve personal and professional goals. For more information, please read ourEEO policy.

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 with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please [e-mail] we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.

Read more aboutworkplacediscriminationrights or our benefit offerings which are included in theTransparency in (Benefits) Coverage Act.

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 or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.

However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance [e-mail]. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.

Pay Range

There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.

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

$81,499.00 - $167,644.00

Nationwide Remote Office (US99)