Data Engineer

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 [email protected] 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.

Work Authorization and Sponsorship All candidates must be authorized to work in the United States. This position is not eligible for new H-1B visa sponsorship by ICF. Candidates who currently hold valid work authorization may be considered for a change of employer petition, subject to company policy and applicable immigration requirements.

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 [email protected] 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. 

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.00Nationwide Remote Office (US99)