Data Engineer (Python) - Remote USA

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.
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 Candidateaccommodation@icf.com 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 their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO 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 email Candidateaccommodation@icf.com and 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 about workplace discrimination rights or our benefit offerings which are included in the Transparency 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 at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.