Design, develop, and maintain scalable data pipelines and ETL/ELT processes
Build and optimize data solutions within cloud environments using AWS services and Databricks
Ingest, transform, and integrate structured and unstructured data from multiple sources
Develop and maintain data models, data marts, and database structures to support analytics and reporting
Ensure data quality, integrity, and availability through validation, cleansing, and monitoring processes
Collaborate with architects, analysts, and developers to translate business requirements into technical solutions
Support CI/CD processes and automated deployments in collaboration with DevSecOps teams
Participate in Agile development processes, including sprint planning, backlog grooming, and daily stand-ups
Troubleshoot data issues, perform root cause analysis, and implement solutions in development and production environments
Create and maintain technical documentation for data pipelines, transformations, and workflows
Requirements
U.S. Citizenship required due to federal contract requirements
Ability to obtain and maintain a Public Trust clearance
Candidate must reside in the U.S. and be able to support onsite work in the Reston, VA area as needed
Candidate must have lived in the U.S. for three (3) full years out of the last five (5) years
3-5 years of experience in data engineering, data integration, or related technical roles
3+ years of strong proficiency in Python and SQL for data processing and transformation
Bachelor's degree in computer science, Engineering, or a related field (preferred)
2+ years of hands-on experience with AWS data services (e.g., S3, Glue, Lambda, Redshift, RDS or similar)
2+ years of experience working with Databricks and Apache Spark or similar distributed data processing platforms
3+ years of experience with ETL/ELT frameworks, data pipeline development, and data ingestion patterns
3+ years of experience working with relational databases such as Oracle or PostgreSQL
Familiarity with data integration techniques using APIs, JSON, or streaming tools such as Kafka
Understanding of data modeling concepts and data warehousing principles
Familiarity with CI/CD tools (e.g., Git, Jenkins or similar)
Experience working in Agile development environments
Experience with cloud-based data lake or Lakehouse architecture
Familiarity with data visualization or reporting tools (e.g., Tableau or similar)
Exposure to DevSecOps practices, including infrastructure as code and automated deployments
Experience supporting secure and compliant data environments
Certifications (Preferred)
AWS Certifications (e.g. AWS or Databricks certifications)
Professional Skills
Strong communication skills with the ability to explain technical concepts to non-technical stakeholders
Ability to manage multiple priorities and deliver high-quality work in an Agile environment
Detail-oriented with a focus on data accuracy, performance, and reliability
Self-motivated with the ability to work independently and within a team
Strong problem-solving skills and ability to work in a fast-paced, collaborative setting
#Indeed
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 will consider for employment qualified applicants with arrest and conviction records.
Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individual
Additional Information
We are seeking a Data Engineer to support federal government programs by designing, building, and maintaining scalable data solutions that enable analytics and reporting across enterprise systems. This role works within a modern cloud-based data ecosystem and partners with cross-functional teams to support data-driven decision-making.
The ideal candidate brings experience with AWS, Databricks, and Python, along with a strong foundation in data engineering best practices, including data pipelines, transformation, and data quality.
Location
This is a hybrid role which may require occasional travel to the DC Metro area for onsite client meetings. Preference to candidates located within the Washington, DC Metro area.
If you accept this position, you should note that ICF does monitor employee work locations and blocks access from foreign locations/foreign IP addresses and also prohibits personal VPN connections.
Security Requirement
Must be a U.S. Citizen with the ability to obtain and maintain a government clearance.
Icf · Reston, VA