ICF
Senior Data Engineer
ICF, Reston, Virginia, United States, 22090
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.
ICF is seeking a talented Data Engineer to contribute to our work supporting the Centers for Medicare and Medicaid Services (CMS).
Responsibilities:
Design and build data processing pipelines using tools and frameworks in the AWS ecosystem.
Analyze 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.
Pay Range:The pay range for this position is: $87,069.00 - $148,017.00. 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.
#J-18808-Ljbffr
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.
ICF is seeking a talented Data Engineer to contribute to our work supporting the Centers for Medicare and Medicaid Services (CMS).
Responsibilities:
Design and build data processing pipelines using tools and frameworks in the AWS ecosystem.
Analyze 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.
Pay Range:The pay range for this position is: $87,069.00 - $148,017.00. 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.
#J-18808-Ljbffr