Senior Data Engineer- Remote

*We are open to supporting 100% remote work anywhere within the continental US*

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth.

We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.

ICF is seeking a talented Data Engineer to contribute to our work supporting the Centers for Medicare and Medicaid Services (CMS).

Responsibilities:  

As part of a team involved in the digital modernization of a legacy system, a successful Data Engineer candidate will have the following responsibilities:

• Design and build data processing pipelines using tools and frameworks in the AWS ecosystem.

• Analyzes requirements and architecture specifications to create a detailed design document.

• Responsible for data engineering functions including data extract, transformation, loading, integration in support of modern cloud computing platforms like AWS.

• Work with huge data sets and other Data Engineers and/or Scientists on analyzing this data using various algorithms.

• Implement and configure big data technologies as well as tune processes for performance at scale.

• Design and build ETL pipelines to automate the ingestion and data migration of structured and unstructured data.

• Work with DevOps engineers on CI, CD, and IaC (Continuous Integration, Continuous Delivery, and Infrastructure as Code) processes; read specifications and translate them into code and design documents; and perform code reviews and develop processes for improving code quality.

• Be proactive and constantly pay attention to the scalability, performance, and availability of our systems.

• Responsible for deploying the developed solution in AWS environment and examine the results for accuracy.

Basic Qualifications:

• Bachelors Degree in Computer Science or a closely related field and 5 years of experience as a Data Engineer, Software Developer, Tech Lead, or in a related position.

• 5+ years of experience with AWS RDBMS services, such as PostgreSQL RDS and Redshift 

• 5+ years of experience with Python, or another OOP language.

• 2+ years of experience with NoSQL products, such as JSON.

• 2+ years of experience with advanced SQL features - regular expressions, analytical functions (e.g., RANK, PARTITION, LEAD, LAG, etc.).

• 1 year of experience using a query planner and database metrics to analyze and optimize queries, table structure, indices, and partitioning strategies.

• Candidate must reside in the United States and be able to obtain a Public Trust clearance.

• Candidate must have resided in the US 3 of the last 5 years.

Preferred Qualifications: 

• Masters Degree

• Experience in the healthcare domain or with healthcare quality data sets 

• Familiarity with other query languages - e.g., XPath, MongoDB query language, Elasticsearch query language, JSON Path, SPARQL, etc.

• Experience with the following technologies is also highly desirable:  Airflow, Typescript, JavaScript

• Federal Government contracting work experience.

• Prior experience working remotely full-time.

Professional Skills:

• Strong technical communication skills; both written and verbal.

• Strong problem solving and structuring skills.

• Ability to identify and learn applicable new techniques independently as needed.

• Flexible and willing to accept a change in priorities, as necessary.

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 can only solve the world'