Be on Alert – Fraudulent Employment Offers. Learn More

Raleigh, North Carolina, United States of America
JOB #R2205506

Senior Data Engineer - Remote

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 of full 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 you will be using:  

  • Postgres, SQL, Stored Procedures 

  • Jenkins  

  • AWS Redshift   

  • Git and GitHub  

  • Confluence 

  • Typescript and React experience are a plus 

What you will be doing: 

  • 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 

What you must have:  

  • 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

What we would like you to have:  

  • 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  




Working at ICF

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.

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

N Carolina Remote Office (NC99)

Who is ICF?

A global consulting services company with approximately 8,000 people across 75+ countries, but we are not your typical consultants.

More jobs you might like

Nov 22, 2022
Multiple locations
Nov 22, 2022
San Juan, Puerto Rico
Nov 21, 2022
Multiple locations
Nov 17, 2022
Atlanta, Georgia, United States of America
Nov 15, 2022
Multiple locations
Nov 11, 2022
Reston, Virginia, United States of America
See All Jobs

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.