Key skills
PythonSQLETLELTData EngineeringData WarehousingData LakeAnalyticsTableauRedshiftDatabricksSparkApache SparkKafkaAWSJenkinsLambdaS3RDSGluePostgreSQLOracleGitAgileCI/CDCommunicationCollaboration
About this role
ICF is a global advisory and technology services provider, and they are seeking a Data Engineer to support federal government programs by designing, building, and maintaining scalable data solutions. The role involves working within a modern cloud-based data ecosystem to enable analytics and reporting across enterprise systems.
Responsibilities:
- 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:
- Must be a U.S. Citizen with the ability to obtain and maintain a government clearance
- Ability to obtain and maintain a Public Trust
- 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
- 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
- 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)
- 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