Data Engineer, Hybrid
Role details
Job location
Tech stack
Job description
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., 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.
What You Will Do
- 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
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., * 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