17 days ago
Reston, VA, USAMid Level
Base Salary
$81k - $168k/yr
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 DataConnect reporting integrations using AWS QuickSight and Databricks.
- Develop APIs and reusable components for secure data access and system integration.
- Support extraction, transformation, and loading of data from multiple sources.
- Create 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, participate in code reviews, and translate technical and business requirements into code and 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 and participate in Agile planning and continuous improvement.
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 PostgreSQL experience and strong knowledge of relational database concepts and SQL.
- Experience with cloud-based data platforms and version-controlled development workflows.
- Ability to translate technical specifications and business requirements 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.
- Preferred qualifications include Databricks data workflows, AWS QuickSight datasets or dashboards, Spark, Airflow, AWS data services, REST APIs, TypeScript, GitHub Actions, Terraform, data governance, metadata, data lineage, secure data sharing, Agile teams, and test-driven development.
Benefits
- Remote work is available, but the position must be performed entirely within the United States.
- ICF provides reasonable accommodations during the application and employment process.
Tech Stack
Categories
Data Engineering
About ICF
ICF is a global consulting and technology services firm serving government and commercial clients across domains such as energy, health, climate, and digital modernization. It delivers advisory, program implementation, analytics, and software-enabled solutions on platforms like ServiceNow. Founded in 1969 and headquartered in Reston, Virginia, ICF is a public company traded on NASDAQ and works extensively with U.S. federal, state and local agencies as well as regulated industries.