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.

We are seeking a talented Data Engineer who is responsible for creating OLTP queries used by front-end engineers to display reports to the end users. You will be working with the team offull stack engineers. If you are someone who wants your work to contribute to systems that collect healthcare data used by hundreds of thousands of daily users, we want to (virtually) meet you!  

 

You will work on projects that support the Centers for Medicare and Medicaid Services (CMS) as we develop a next-generation analytics and reporting system that directly impacts healthcare quality.  

This program allows for the continued quality of clinicians’ work according to CMS standards. We are a collaborative company, so we want you to use your knowledge of Spark to teach others, inform design decisions, and debug runtime problems.  

 

Our mission is to help the government improve healthcare for patients and reduce costs. We value individuals that are experts in their disciplines, highly communicative, and self-motivated to own their work. Technology and domain experts work side-by-side in highly dynamic teams with all the roles necessary to deliver high-quality digital services. In addition, critical to our success is forming teams of highly diverse individuals passionate about making a difference.  

Tools & Technology:

• Postgres, SQL, StoredProcedures 
• Jenkins  
• AWS Redshift   
• Git and GitHub  
• Confluence 
• Typescript and React experience are a plus 

Key Responsibilities:

• Write new database stored procedures and functions to support QMIR Reports data needs. 
• Maintain existing Reports stored procedures and functions in Redshift and Postgres database 
• Support Production issues with investigation and performance tuning of SQL code. 
• Maintain and perform alembic migrations scripts in Git repo for script changes and incident tickets. 
• Analyze existing stored procedures and rewrite/tune for better performance and alignment with newer reports 

Basic Qualifications:

• Bachelor’s Degree  
• 5+ years of experience with Postgres, SQL, and Redshift 
• 2+ years of experience with Agile methodology  
• 5+ years of experience performing data pipeline and data validation  
• Must live in the United States, have lived in the US for 3 of the last 5 years, and be able to obtain a Public Trust Clearance. 
• Work must be performed in the US

Preferred Qualifications:

• MS and 5+ years of technical experience   
• Experience working in the healthcare industry with PHI/PII  
• Federal Government contracting work experience  
• Expertise working as part of a dynamic, interactive Agile team 
• Strong written and verbal communication skills  
• Demonstrated time management skills.  
• Strong organizational skills with attention to detail  
• Curiosity about how things work, ability to look out for potential risks  

COVID-19 Policy: New or prospective U.S. employees must provide proof of complete vaccination on the date of their commencement of employment. If selected for employment, you will provide proof of your full vaccination status, defined as vaccinated two weeks after receiving the requisite number of doses of a COVID-19 vaccine approved or authorized for emergency use by the FDA.

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 icfcareercenter@icf.com 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 non-discrimination:  EEO is the law and  Pay Transparency Statement.

Pay Range - There are multiple factors that are considered in determining final salary 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.