Data Engineer (Remote)

ICF is growing, and we are looking for a talented, highly motivated Data Engineer to join ICF’s Digital Modernization and Experience (DMX) Division. The Data Engineer will support our projects by collaborating and working with a cross-functional team to deliver quality, innovative, and highly scalable applications to end clients. The ideal candidate will have prior experience working with cross-disciplinary teams in the government space.

You are a team player and can embrace ambiguity to translate client requirements using an agile delivery framework to deliver technical solutions that achieve mission value and measurable outcomes. You are a strategic problem-solver that has a willingness to learn and grow with our team and be part of our client’s digital transformation journey. 

At ICF, we implement smart solutions to drive digital transformation at scale and speed, relentless in making sure it pays off for our clients and committed to helping them achieve mission outcomes. Join our community of mission-driven project managers, data experts, strategists, and technologists to build agile solutions that meet our client’s changing needs. 

What will you be doing? 

• Lead and develop data engineering design and build efforts for our client initiative, working as part of an extended system development team on project execution 

• Develop extract, transform, and load (ETL) processing routines and data engineering pipelines, creating necessary data structures and data models to support data at all stages 

• Perform extensive data profiling and analysis based on client data 

• Work with UI, UX and business analysis team members and the client to define data and reporting requirements 

• Design and implement custom data analytic and BI/reporting products, custom reports, and data visualization products 

• Work closely with the client to understand and address their needs, ensuring seamless communication and delivery 

• Write, optimize, and maintain complex SQL queries for querying large datasets efficiently. 

• Quickly learn and navigate through databases to understand structure, optimize performance, and ensure data quality. 

• Develop and maintain SAS scripts and stored processes, ensuring their accuracy and performance. 

• Work with cloud-based platforms such as Snowflake and AWS (e.g., S3, Lambda) to integrate, process, and manage data. 

• Troubleshoot and resolve data-related issues, optimizing processes for speed and efficiency. 

• Provide insights and recommendations on improving the performance and architecture of data systems. 

• Document technical processes, queries, and database configurations for internal and client use. 

What you must have: 

What we’d like you to know: 

• Demonstrated experience showing strong critical thinking and problem-solving skills paired with a desire to take initiative. 

• Experience building CI/CD pipelines with tools such as Jenkins. 

• Experience with Agile development process 

• Strong proficiency in SQL, including the ability to write complex queries and optimize them for performance. 

• Hands-on experience with SAS programming (reading/writing SAS scripts) and creating/managing SAS stored processes. 

• Knowledge of cloud-based platforms, particularly Snowflake and AWS services (e.g., S3, Redshift, EC2, Lambda). 

• Ability to quickly learn and adapt to new databases and technologies. 

• Excellent communication skills, with the ability to work closely with clients and internal teams to gather requirements and deliver results. 

• Strong problem-solving abilities and attention to detail. Ability to handle large datasets and work with data in various formats (structured and unstructured). 

• Experience with data modeling, ETL processes, and database optimization techniques is a plus. 

• Familiarity with data warehousing concepts and modern cloud data architectures. 

• Prior experience in client-facing roles is a plus. 

• Good to know: Python programming for data manipulation, automation, or additional scripting tasks. 

Technologies you'll use in this role (not limited to): 

AWS Glue, Lambda, Athena, S3, Redshift/Postgres, ETL, SQL, Python/R, Agile, CI/CD 

#DMX
#LI-CC1
#Indeed