Data Engineer (Python) - Remote USA

ICF•Reston, VA

10d•$81,499 - $167,644•Remote

About The Position

ICF is seeking a Data Engineer for its Health Engineering Systems team 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 role involves translating technical specifications and business requirements into maintainable code, data designs, and documentation, working independently, and partnering with senior engineers, data scientists, analysts, and DevOps team members. The position requires all work to be performed in the United States. Candidates must reside in the United States, be authorized to work in the United States, and have lived in the country for three full years out of the last five years. The candidate must be able to obtain and maintain a Public Trust clearance. ICF does not offer new H-1B visa sponsorship for this position. This is a remote position with a stated full-time pay range of $81,499 to $167,644. Final pay depends on factors including relevant experience, skills, certifications, competencies, location, education, and contract provisions.

Requirements

Bachelor's degree.
At least 3 years of hands-on software development or data engineering experience.
At least 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.
Ability to obtain and maintain a Public Trust clearance.
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.
Must perform all work in the United States.

Nice To Haves

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.

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 supporting DataConnect reporting through AWS QuickSight and Databricks.
Develop API services and reusable components to 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.
Perform other duties as assigned.