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.
- Requires an MS Degree in Computer Science or a closely related field and 3 years of experience as Data Engineer, Software Developer, Tech Lead, or in a related position.
- Will also accept BS 5 years of experience. Basic Qualifications:
5 years' experience with AWS RDBMS services, such as PostgreSQL RDS and Redshift 5 years' experience with Python, or another OOP language.
2 years' Experience with NoSQL products, such as JSON.
2 years' experience with advanced SQL features - regular expressions, analytical functions (e.g., RANK, PARTITION, LEAD, LAG, etc.).
1 year 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: - 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'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. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about workplace discriminationrights ,the Pay Transparency Statement , or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position is :
$87,069.00 - $148,017.00 Virginia Remote Office (VA99)