Data Engineer (Python) - Remote USA

ICF Olson; United States; Remote; USD 81,000 - 168,000; Full time

Job summary

ICF is a mission-driven company improving lives and solving complex challenges from health to technology. Our Health Engineering Systems (HES) team partners with customers to define success and deliver secure data solutions using modern cloud platforms.

We are seeking a Data Engineer to design and maintain data pipelines and databases (PostgreSQL, SQL, Databricks) and to build reporting integrations with AWS QuickSight.

Qualifications

• Bachelor's degree in a related field.
• 3+ years of hands-on data engineering or software development experience.
• Ability to obtain and maintain a Public Trust clearance.
• Authorized to work in the United States and reside in the United States for the past three years.

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 access patterns.
• Build and maintain integrations supporting DataConnect reporting via AWS QuickSight and Databricks.
• Develop API services and reusable components for secure data access and system integration.
• Support ETL of data from multiple sources while meeting functional and non-functional requirements.
• Create data-quality checks, monitoring, and operational alerts.
• Troubleshoot data issues and improve pipeline reliability, performance, and availability.
• Write unit and integration tests for data-processing code and participate in code reviews.

Education

Bachelor's degree

Tools

PostgreSQL

Databricks

AWS QuickSight

Python

SQL

REST APIs

Spark

Airflow

AWS data services

TypeScript

GitHub Actions

Terraform

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

Workplace Policies

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 [e-mail] 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.

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 [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)

About ICF

About ICF ICF is a global consulting and technology services company with approximately 9,000 employees, but we are not your typical consultants. At ICF, business analysts and policy specialists work together with digital strategists, data scientists and creatives. We combine unmatched industry expertise with cutting-edge engagement capabilities to help organizations solve their most complex challenges. Since 1969, public and private sector clients have worked with ICF to navigate change and shape the future. Learn more at icf.com.